problem converting yabb gold 1.4 to smf 1.1.10

[p44online]

this is the error i am getting during the conversion any help would be greatly appreciated.

Converting membergroups... Successful.
Converting members... Unsuccessful!
This query:

    ALTER TABLE `p44onlin_p44forum`.smf_members
    DROP PRIMARY KEY,
    CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint( unsigned NOT NULL default 0;

Caused the error:

    Can't DROP 'PRIMARY'; check that column/key exists

I have tried going through the posts on this board and have tried all of the patched converters i could find this is where I am stuck now.

[ThorstenE]

the old YaBB converters modify the SMF database during conversion.. was it the first time you had started the conversion or have you tried it before?

I'm not sure, but believe the solution would be to re-install SMF and then restart the conversion ..

[p44online]

thank you so much that got me alot further here is where i am at now:
members are there but all boards are there but all of my posts are missings. Also this is the new error i am getting form the convert script.
Converting members...
Notice: Undefined index: Juan_Blanco in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: kilralpine in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Dave944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Frosty in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Patrick in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Buckeyechuck in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: JOHN in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: jonathan in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: reddog in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Sask944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: shovelhead in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: vicaccusonic in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: vjay944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: js944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: grayfox in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Mr._Bill in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: 944virgin in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: earl in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Randall178 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: speedracer in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: 87porsche944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: markxiii in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: rstickswalker in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: Ryan944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: BUCKETHEAD in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: tkw in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: chuck_inguanez in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482

Notice: Undefined index: kortzie in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1482
Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:

    INSERT INTO `p44onlin_p44online`.smf_log_boards
    (ID_MEMBER, ID_BOARD)
    VALUES ('303', '13'),
    ('258', '7'),
    ('5325', '14'),
    ('3484', '13'),
    ('3484', '8'),
    ('879', '8'),
    ('879', '6'),
    ('879', '14'),
    ('879', '13'),
    ('1712', '9'),
    ('3476', '5'),
    ('3476', '16'),
    ('3476', '9'),
    ('3476', '13'),
    ('3476', '15'),
    ('3476', '14'),
    ('4191', '14'),
    ('4191', '8'),
    ('3851', '13'),
    ('3851', '15'),
    ('3851', '8'),
    ('3632', '7'),
    ('3632', '5'),
    ('3632', '15'),
    ('3632', '16'),
    ('2983', '12'),
    ('2983', '9'),
    ('2983', '14'),
    ('5095', '7'),
    ('5095', '9'),
    ('5095', '13'),
    ('5095', '12'),
    ('5095', '15'),
    ('5095', '16'),
    ('5095', '6'),
    ('5095', '14'),
    ('5095', '11'),
    ('5095', '5'),
    ('5095', '8');

Caused the error:

    Duplicate entry '1712-9' for key 1

[ThorstenE]

Please try the modified version (attached)..

[p44online]

started with a fresh install again and this one seems to be worse. this is the error

Converting membergroups... Unsuccessful!
This query:

    INSERT INTO `p44onlin_p44online`.smf_membergroups
    (groupName, onlineColor, minPosts, stars)
    VALUES (SUBSTRING('admin center', 1, 80), '', -1, '';

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

[p44online]

Does anyone have any suggestions ? I would really like to get this to work.

[ThorstenE]

sorry, I can't test it myself, please try the attached version (the bug should be fixed).

[p44online]

seems to keep getting stuck in the same place. I can do another fresh install and give you access to the site if you think you can get this to work right.

here is the error

Converting...
Converting members...
Notice: Undefined index: Jake356 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: laketrash in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Juan_Blanco in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: kilralpine in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Dave944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Frosty in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Patrick in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Buckeyechuck in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: JOHN in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: jonathan in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: reddog in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Sask944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: shovelhead in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: vicaccusonic in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: vjay944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: js944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: grayfox in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Mr._Bill in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: 944virgin in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: earl in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Randall178 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: speedracer in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: 87porsche944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: markxiii in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: rstickswalker in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: Ryan944 in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: BUCKETHEAD in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: tkw in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: chuck_inguanez in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401

Notice: Undefined index: kortzie in /home/p44onlin/public_html/forum2/yabb_to_smf.php on line 1401
Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:

    INSERT IGNORE INTO `p44onlin_p44forum`.smf_log_boards
    (logTime, ID_MEMBER, ID_BOARD)
    VALUES ('1205196762', '3351', '13'),
    ('1234409305', '4647', '8'),
    ('1234240943', '4647', '4'),
    ('1243549022', '4740', '14'),
    ('1234025337', '4645', '6'),
    ('1234063489', '4645', '4'),
    ('1234025302', '4645', '14'),
    ('1234025208', '4645', '12'),
    ('1245298622', '5200', '15'),
    ('1247431665', '5200', '8'),
    ('1245281848', '5200', '12'),
    ('1245298609', '5200', '14'),
    ('1245345674', '5200', '13'),
    ('1156816234', '779', '6'),
    ('1156811837', '779', '4'),
    ('1221862258', '3057', '14'),
    ('1221862699', '3057', '4'),
    ('1218571427', '3846', '13'),
    ('1209061942', '3157', '7'),
    ('1207333487', '3157', '13'),
    ('1208372702', '3157', '12'),
    ('1235830455', '4671', '10'),
    ('1235488479', '4671', '4'),
    ('1234706219', '4671', '12'),
    ('1235830487', '4671', '11'),
    ('1235488202', '4671', '14'),
    ('1211433074', '3636', '8'),
    ('1211433071', '3636', '13'),
    ('1232464922', '4564', '6'),
    ('1232465318', '4564', '9'),
    ('1232465297', '4564', '8'),
    ('1232660148', '4564', '4'),
    ('1124749859', '142', '9'),
    ('1124749964', '142', '10'),
    ('1124749332', '142', '4'),
    ('1171075685', '1171', '13'),
    ('1203225287', '3288', '4'),
    ('1246348544', '4929', '4'),
    ('1244882249', '4929', '15'),
    ('1241895782', '5015', '6'),
    ('1183957903', '1640', '12'),
    ('1202833662', '3240', '6'),
    ('1203003571', '3240', '12'),
    ('1202411995', '3240', '14'),
    ('1203003728', '3240', '13'),
    ('1202150028', '3240', '4'),
    ('1202412009', '3240', '15'),
    ('1203003272', '3240', '7');

Caused the error:

    Unknown column 'logTime' in 'field list'

[ThorstenE]

ok.. another bug :-/

After searching the forum for a while I found this
http://www.simplemachines.org/community/index.php?topic=236771.msg1527516#msg1527516
Hopefully the attached version will finish without errors..

[p44online]

There wasn't anything attached to your post should i get the file from that link? Also should I start with a fresh install again ?

[ThorstenE]

Sorry, I meant the file attached to the linked post and yes, it's better to start with a fresh installation..

[p44online]

That script worked alot better this is where i am at now

Converting posts (part 2)... Unsuccessful!
This query:

    ALTER TABLE `p44onlin_p44forum2`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY;

Caused the error:

    Multiple primary key defined

[p44online]

so i commented out this line in the yabb_to_smf.php file
#convert_query("
         #ALTER TABLE {$to_prefix}messages
         #CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY");
and i got past that error now i have this
Recalculating forum statistics... Successful.
Unsuccessful!
This query:

    REPLACE INTO {$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1248721622),
    ("conversion_from", "yabb_to_smf.php");

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 '{$to_prefix}settings (variable, value)
    VALUES ("conversion_time", 1248721622)' at line 1

if this is just for the stats then i am not worried about it how ever i would like to know what my previous error is for.

although it seems like all of my posts are there i do notice i am missing some members and my ban list is empty.

[ThorstenE]

the last error was after the final important conversion step: "Recalculating forum statistics... Successful.".. this is a variable we add to the database for support reasons.. don't care about this error.

Many missing members or possibly only members, who never activate their accounts?

[p44online]

so commenting out this line in the script to get it to finish is ok?

#convert_query("
         #ALTER TABLE {$to_prefix}messages
         #CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY");

i just want to make sure i am not doing anything that may cause problems later. like i said besides some of the members that i am missing the only other thing i see missing is my banned members list.