SMF Support > IPB

[SMF Converter] IPB 3.0

<< < (10/11) > >>

DieWacht:
I've done all the Fixes here in the Thread and have update the two files.

Use it on Your own Risk please.

Kind regards, Andy

VanKlomp:
Doesn't seem to work for IPB 3.2.X

nerix:
When i try to convert to smf it shows this error:

"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 3.0. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'dono91_diskusije'@'localhost' for table 'ipforum_members'"

i have installed ipboard 3.1.4 and smf 2.0 version. Can you help me pls.

HAMBONE0:

--- Quote from: DieWacht on August 04, 2011, 04:19:13 PM ---I've done all the Fixes here in the Thread and have update the two files.

Use it on Your own Risk please.

Kind regards, Andy

--- End quote ---

I have tried using these files and I still get the same error:



--- Code: ---Converting members...
Unsuccessful!
 This query:
SELECT
 m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
 SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
 SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
 SUBSTRING(pc.field_3, 1, 255) AS website_title,
 SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
 SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
 SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
 IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
 CASE
 WHEN (m.member_group_id = '4') THEN 1
 WHEN (m.member_group_id = '2') THEN -1
 WHEN (m.member_group_id = '6') THEN 2
 ELSE 0
 END AS id_group,
 CASE
 WHEN (pc.field_5 = 'm') THEN 1
 WHEN (pc.field_5 = 'f') THEN 2
 ELSE 0
 END AS gender
 FROM `kiss-clan_com_-_kissmain1`.ibf_members AS m
 LEFT JOIN `kiss-clan_com_-_kissmain1`.ibf_pfields_content AS pc ON (pc.member_id = m.member_id)
 LEFT JOIN `kiss-clan_com_-_kissmain1`.ibf_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
 LIMIT 0, 500;
 Caused the error:

Unknown column 'pp.pp_bio_content' in 'field list'
--- End code ---

IPB version 3.2.3

Any help would be greatly appreciated!

eddie1973:
I get this error. IPB 3.2


--- Code: ---Converting members... Unsuccessful!
This query:
SELECT
m.member_id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
SUBSTRING(m.members_display_name, 1, 255) AS real_name, m.email AS email_address,
SUBSTRING(m.members_pass_hash, 1, 64) AS passwd, SUBSTRING(m.members_pass_salt, 1, 8) AS password_salt,
SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle, m.last_visit AS last_login,
m.joined AS date_registered, SUBSTRING(pc.field_3, 1, 255) AS website_url,
SUBSTRING(pc.field_3, 1, 255) AS website_title,
SUBSTRING(pc.field_4, 1, 255) AS icq, SUBSTRING(pc.field_1, 1, 16) AS aim,
SUBSTRING(pc.field_8, 1, 32) AS yim, SUBSTRING(pc.field_2, 1, 255) AS msn,
SUBSTRING(pp.signature, 1, 65534) AS signature, m.ip_address AS member_ip, m.ip_address AS member_ip2, '0' AS total_time_logged_in,
IF (m.bday_year IS NULL, '0001-01-01', IF (m.bday_year = 0 AND m.bday_month != 0 AND m.bday_day != 0, CONCAT('0004-', m.bday_month, '-', m.bday_day), CONCAT_WS('-', IF(m.bday_year <= 4, 0001, m.bday_year), IF(m.bday_month = 0, 01, IF(m.bday_month < 10, CONCAT('0', m.bday_month), m.bday_month)), IF(m.bday_day = 0, 01, IF(m.bday_day < 10, CONCAT('0', m.bday_day), m.bday_day))))) AS birthdate, m.email_pm AS pm_email_notify,
CASE
WHEN (m.member_group_id = '4') THEN 1
WHEN (m.member_group_id = '2') THEN -1
WHEN (m.member_group_id = '6') THEN 2
ELSE 0
END AS id_group,
CASE
WHEN (pc.field_5 = 'm') THEN 1
WHEN (pc.field_5 = 'f') THEN 2
ELSE 0
END AS gender
FROM `flyakaco_myaka`.ibp_members AS m
LEFT JOIN `flyakaco_myaka`.ibp_pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `flyakaco_myaka`.ibp_profile_portal AS pp ON (pp.pp_member_id = m.member_id)
LIMIT 0, 500;
Caused the error:
Unknown column 'pp.pp_bio_content' in 'field list'
--- End code ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version