Convert from PunBB 1.2.14 to SMF 2.0RC2

[kmarabu]

Trying to convert forum from PunBB 1.2.14 to SMF 2.0.RC2 and have two problems.
First error:

Code Select Expand

Converting members... Unsuccessful!
This query:

    SELECT
    id AS id_member, SUBSTRING(username, 1, 80) AS member_name,
    registered AS date_registered, num_posts AS posts,
    IF(group_id = 1, 1, IF(group_id = 2, 2, 0)) AS id_group,
    SUBSTRING(title, 1, 255) AS usertitle, last_visit AS last_login,
    SUBSTRING(password, 1, 64) AS passwd,
    SUBSTRING(IFNULL(real_name, username), 1, 255) AS real_name,
    SUBSTRING(location, 1, 255) AS location,
    SUBSTRING(email, 1, 255) AS email_address,
    SUBSTRING(url, 1, 255) AS website_title,
    SUBSTRING(url, 1, 255) AS website_url, SUBSTRING(aim, 1, 16) AS aim,
    SUBSTRING(icq, 1, 255) AS icq, SUBSTRING(signature, 1, 65534) AS signature,
    SUBSTRING(yahoo, 1, 32) AS yim, SUBSTRING(msn, 1, 255) AS msn,
    IF(email_setting = 0, 0, 1) AS hide_email,
    timezone AS time_offset, SUBSTRING(registration_ip, 1, 255) AS member_ip,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
    '' AS personal_text, '' AS time_format, '' AS avatar, '' AS usertitle,
    '' AS secret_question, '' AS secret_answer, '' AS validation_code,
    '' AS additional_groups, '' AS smiley_set, '' AS password_salt,
    SUBSTRING(registration_ip, 1, 255) AS member_ip2
    FROM `akva_smf2`.users
    WHERE id != 1
    LIMIT 0, 500;

Caused the error:

    Unknown column 'real_name' in 'field list'


I check 'punbb_to_smf.sql', replace 'real_name' with 'realname', and try again. This issue fixed but have new problem:

Code Select Expand

Converting members...
Successful.
Converting avatars... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Duplicate entry '630' for key 'PRIMARY'

PunBB worked correctly. Mysql database rechecked - all tables correct, but in table 'smf_topics' I see only 500 records. And topic with ID=630 not a last in 'smf_topics'
Maybe this problem occurred when convert script trying to split large amount of records?
Convert from this PunBB forum to SMF 1.1.10 done without any errors.
Any ideas to fix this?

[Norv]

Judging from your error messages, it seems to me that you have installed SMF 1.1.10, and try to use the converter to SMF 2.0 RC2. Can you please verify if that is the case? It won't work, please make sure you install SMF 2.0 RC2 and convert to it.

Or, if you want the use the older SMF 1.1.10 version, then please make sure you use the converter files to 1.1.10.
They can all be found in this site's Downloads > Converters.

[kmarabu]

I try to convert in this order:
- install clean SMF 2.0RC2, use clean database;
- copy to this database tables from worked PunBB, configure copy of worked PunBB to use this database;
- use smf_2-0-rc2_punbb_converter.zip

After errors in convert I completely remove SMF 2.0RC2 (files and database tables) and try to convert to SMF 1.1.10 in same order as above.
About first error - PunBB 'users' table use field "realname", not a "real_name" (SMF 1.1.10 converter proper).

[Norv]

About first error - PunBB 'users' table use field "realname", not a "real_name" (SMF 1.1.10 converter proper).

You are absolutely right, I corrected that error in our 2.0 converter. Thank you for your report on this.