Error on IPB 2.3.x converter for SMF 2.0RC2

[rafaelcp]

Hello friends, I'm new here and my English is not fluent, I am Brazilian and I've always liked the SMF.
I'm having problem when migrating from IPB 2.3.x to SMF 2.0 RC2.
The converter I am using it here in the same forum.

The error says:

Code Select Expand

Converting...
Error in convert script - line 22!
Converting members...
Error in convert script - line 23!
Unsuccessful!
This query:

    SELECT
    m.id AS id_member, SUBSTRING(m.name, 1, 80) AS member_name,
    m.joined AS date_registered,
    IF(m.mgroup = 4, 1, IF(m.mgroup = 3, 0, IF(m.mgroup > 5, m.mgroup + 3, 0))) AS id_group,
    posts, m.last_visit AS last_login, SUBSTRING(m.members_display_name, 1, 80) AS real_name,
    SUBSTRING(me.yahoo, 1, 32) AS yim, m.msg_total AS instant_messages,
    SUBSTRING(mc.converge_pass_hash, 1, 64) AS passwd,
    SUBSTRING(mc.converge_pass_salt, 1, 5) AS password_salt,
    SUBSTRING(m.email, 1, 255) AS email_address,
    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, 1, m.bday_year), IF(m.bday_month = 0, 1, m.bday_month), IF(m.bday_day = 0, 1, m.bday_day))) AS birthdate,
    SUBSTRING(me.website, 1, 255) AS website_title,
    SUBSTRING(me.website, 1, 255) AS website_url, me.signature,
    SUBSTRING(me.location, 1, 255) AS location,
    SUBSTRING(me.icq_number, 1, 255) AS icq,
    SUBSTRING(me.msnname, 1, 255) AS msn, SUBSTRING(me.aim_name, 1, 16) AS aim,
    m.hide_email AS hide_email, m.email_pm AS pm_email_notify,
    SUBSTRING(IF(me.avatar_location = 'noavatar', '', me.avatar_location), 1, 255) AS avatar,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
    '' AS personal_text, '' AS time_format, '' AS usertitle, '' AS member_ip,
    '' AS secret_question, '' AS secret_answer, '' AS validation_code,
    '' AS additional_groups, '' AS smiley_set, '' AS member_ip2
    FROM `teamones_ipbforum`.ibf_members AS m
    LEFT JOIN `teamones_ipbforum`.ibf_member_extra AS me ON (m.id = me.id)
    LEFT JOIN `teamones_ipbforum`.ibf_members_converge AS mc ON (m.id = mc.converge_id)
    WHERE m.id != 0
    LIMIT 0, 500;

[color=red]Caused the error:

    Table 'teamones_ipbforum.ibf_member_extra' doesn't exist[/color]

I am 3 days looking for a solution and can not find anything!
Thanks for now!

[Ash-1993]

To me your installing this wrong. What files/folders are you uploading.?

[Norv]

Hello there, and welcome!

In addition to Ash-1993's question, can you please tell, if IPB has some setting to enable additional informations about members, then please enable it and try again.

[sandrabright10]

Hi!
I've also faced same prob.

At script start there was an error

Converting...
    Converting personal messages (step 1)...
    Successful.
    Converting personal messages (step 2)... Successful.
    Converting personal messages (step 3)... Unsuccessful!
    This query:
    UPDATE `samuraismf`.smf_personal_messages
    SET deleted_by_sender = '0'
    WHERE id_pm =;
    Caused the error:
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

I have rectified an error having set a flag "deleted" = 1 in table smf_pm_recipients. May be it can help you!