SMF Support > IPB

*Convert from IPB 3.1.2 to SMF 1.1.1* NEED HELP!

<< < (2/3) > >>

gregormendel:
I'm running an IPB 3.1.4 an want to convert to SMF.

I tried using the 3.0 > SMF 2.0 RC4 but get the following 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 `havenwow_eu`.ibf_members AS m
LEFT JOIN `havenwow_eu`.ibf_pfields_content AS pc ON (pc.member_id = m.member_id)
LEFT JOIN `havenwow_eu`.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 ---

TE:
gregormendel,
edit the ipb31_to_smf.sql and remove this code:

--- Code: ---SUBSTRING(pp.pp_bio_content, 1, 255) AS usertitle,
--- End code ---
then restart the converter.

gregormendel:
Thx TE, that got me a bit further. I am however using the ipb3_to_smf.sql - I'm not aware of an ipb31_to smf.sql is that a typo?

I had to include óne of your fixes from the pinned topic to get PM's converted, but now I hang at this:


--- Code: ---Converting...
Converting topic notifications...
Successful.
Converting board notifications... Successful.
Converting censored words... Successful.
Converting moderators...Wrong value type sent to the database. Integer expected. (id_board)

--- End code ---

TE:

--- Quote from: gregormendel on December 29, 2010, 06:24:13 AM ---Thx TE, that got me a bit further. I am however using the ipb3_to_smf.sql - I'm not aware of an ipb31_to smf.sql is that a typo?

--- End quote ---
yepp, typo ..

in ibb3_to_smf.sql find:

--- Code: ---if (empty($row['id_member']))
unset($row);

--- End code ---
replace with:

--- Code: ---if (empty($row['id_member']) || empty($row['id_board']))
unset($row);
--- End code ---

gregormendel:
I made the changes you surgested, but the converter still makes the same error.

Any further surgestions are appreciated .-)

Navigation

[0] Message Index

[#] Next page

[*] Previous page