News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Error message when converting YaBB 2.1 to SMF 2

Started by daoloth, August 06, 2011, 01:27:00 PM

Previous topic - Next topic

daoloth

That was not a lot to go on, I know.
Clarification: I have installed SMF 2.0 @ localhost (using WAMP) and all I have of the Yabb 2.1 is a backup, the server it was installed on is gone. I'm using the converter downloaded from http://download.simplemachines.org/?converters;software=yabb and it stops when converting members from the old Yabb forum.
The thing is, that I don't really need to bring over the members from the old forum, all I really need is the posts, so is there any way I can skip this step perhaps?

The error message I'm getting is this:

Warning: Missing argument 1 for smf_db_list_indexes(), called in C:\wamp\www\smf_2-0_install\convert.php on line 2864 and defined in C:\wamp\www\smf_2-0_install\Sources\DbPackages-mysql.php on line 530
and
Notice: Undefined variable: table_name in C:\wamp\www\smf_2-0_install\Sources\DbPackages-mysql.php on line 534

I don't really know that much about php &c. but it seems to me that this is an error caused by the convert.php file, and not something else. Or?

Would greatly appreciate any help.

daoloth

gonna try bumping this, since I made some modifications to the first post.

duuso

#2
Bump!

I'm also trying to convert YABB 2.1 to SMF 2.0.2 using converter Yabb 2.1 to SMF 2-0 from http://download.simplemachines.org/?converters;software=yabb

I unpacked files to SMF root and head to Convert.php, fill information and hit convert button. This is the outcome:
Successful.
Converting membergroups...
Successful.
Converting members...
array(6) { [0]=> array(4) { ["file"]=> string(51) "/home/jackrs2/public_html/foorumi/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) { [0]=> &string(7) "members" [1]=> &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { ["id_member"]=> string(74) "CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0" } } } [1]=> array(2) { ["function"]=> string(12) "convertStep3" ["args"]=> array(0) { } } [2]=> array(4) { ["file"]=> string(45) "/home/jackrs2/public_html/foorumi/convert.php" ["line"]=> int(1346) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(12) "convertStep3" } } [3]=> array(4) { ["file"]=> string(45) "/home/jackrs2/public_html/foorumi/convert.php" ["line"]=> int(973) ["function"]=> string(17) "run_php_converter" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(7) "doStep1" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(45) "/home/jackrs2/public_html/foorumi/convert.php" ["line"]=> int(51) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(7) "doStep1" } } }
Warning: Missing argument 1 for smf_db_list_indexes(), called in /home/jackrs2/public_html/foorumi/convert.php on line 2864 and defined in /home/jackrs2/public_html/foorumi/Sources/DbPackages-mysql.php on line 530

Notice: Undefined variable: table_name in /home/jackrs2/public_html/foorumi/Sources/DbPackages-mysql.php on line 534
Incorrect table name ''


Convert.php, line 2864:
$availableKeys = array_flip($smcFunc['db_list_indexes']());

ie. it's missing "$tableName" inside parenthesis - in line #2870 there's similar function with it. So I modified line 2864 to:
$availableKeys = array_flip($smcFunc['db_list_indexes']("$tableName"));

Then I went again to convert.php, after hitting OK I'll get:
This query:
    ALTER TABLE `jackrs2_smf1`.smf_members
    CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0,
    DROP PRIMARY KEY;

Caused the error:
    Can't DROP 'PRIMARY'; check that column/key exists

This comes probably because there's yet no member id's in smf_members - smf_members.id_member cannot be primary key field as there's duplicate values. YABB is flat file based, no database, and there's no member id's assigned - members are distinguished by member name. So I guess member_id's should be assigned (by registeration date) before dropping primary key, but how?

##
edit ok I found myself a way (yabb2.1 -> smf 1.1 -> smf 2). Instructions here http://www.simplemachines.org/community/index.php?topic=457735.0 read those, converter here: http://www.simplemachines.org/community/index.php?topic=344465.msg2778613#msg2778613

Bazie

I'm trying to update Yabb 2.1 to SMF and I get that same error message like duuso. How this problem is solved?

QuoteConverting...
Successful.
Converting membergroups...
Successful.
Converting members...
array(6) { [0]=> array(4) { ["file"]=> string(49) "/home/XXXXXX/public_html/forum/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) { [0]=> &string(7) "members" [1]=> &array(1) { ["PRIMARY"]=> string(16) "DROP PRIMARY KEY" } [2]=> &string(0) "" [3]=> &array(1) { ["id_member"]=> string(74) "CHANGE COLUMN id_member id_member mediumint(8) unsigned NOT NULL default 0" } } } [1]=> array(2) { ["function"]=> string(12) "convertStep3" ["args"]=> array(0) { } } [2]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(1346) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(12) "convertStep3" } } [3]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(973) ["function"]=> string(17) "run_php_converter" ["args"]=> array(0) { } } [4]=> array(2) { ["function"]=> string(7) "doStep1" ["args"]=> array(0) { } } [5]=> array(4) { ["file"]=> string(43) "/home/XXXXXX/public_html/forum/convert.php" ["line"]=> int(51) ["function"]=> string(14) "call_user_func" ["args"]=> array(1) { [0]=> &string(7) "doStep1" } } }
Warning: Missing argument 1 for smf_db_list_indexes(), called in /home/XXXXXX/public_html/forum/convert.php on line 2864 and defined in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 530

Notice: Undefined variable: table_name in /home/XXXXXX/public_html/forum/Sources/DbPackages-mysql.php on line 534
Incorrect table name ''

margarett

I would advise you to try the converter from this topic
http://www.simplemachines.org/community/index.php?topic=122338.0
And try with SMF 1.1.19. I am not sure if the converter was properly tested with SMF 2.0 :( I tried to debug the issues with the converter a bunch of times but I cannot get YaBB to install in my local machine...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Bazie

Quote from: margarett on November 30, 2014, 05:27:25 PMI would advise you to try the converter from this topic
http://www.simplemachines.org/community/index.php?topic=122338.0
I have used that converter (as you advised me on that same topic). But I'm now stuck with this error message :-\

Quote from: margarett on November 30, 2014, 05:27:25 PMAnd try with SMF 1.1.19.
I can try but I believe I can't install 1.1 because of newer version MySQL :-\

margarett

Which version are you running? SMF 1.1.19 will still run on PHP 5.5, but will throw a bunch of errors in your error log. Should work, nevertheless ;)
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Bazie

Quote from: margarett on December 01, 2014, 05:01:33 AMWhich version are you running? SMF 1.1.19 will still run on PHP 5.5, but will throw a bunch of errors in your error log. Should work, nevertheless ;)
Version is 5.5.40-cll. I will try conversion with 1.1.19 later today.

Bazie

Quote from: Bazie on December 01, 2014, 05:19:38 AM
Quote from: margarett on December 01, 2014, 05:01:33 AMWhich version are you running? SMF 1.1.19 will still run on PHP 5.5, but will throw a bunch of errors in your error log. Should work, nevertheless ;)
Version is 5.5.40-cll. I will try conversion with 1.1.19 later today.
Finally. Now it's done :D Thank you margarett for pointing me to right direction :)

I installed 1.1.19. Then I tried conversion with this:
Quote from: margarett on November 30, 2014, 05:27:25 PM
I would advise you to try the converter from this topic
http://www.simplemachines.org/community/index.php?topic=122338.0
Not good. Error message after error message. Then I used conversion tool for Yabb 2.4 here: http://www.simplemachines.org/community/index.php?topic=344465.msg2778613#msg2778613

And after that it was done. Then update from 1.1.19 to 2.0.9.

I had to create new membergroups and then update all users profiles to correct membergroup. Also private message's date, sender and topic are now X.X.1970, Re: Yabb to SMF and IP-address. Some other small adjustment and forum is now online 8)

margarett

Thank you.
This converter clearly needs some "love" :( I was never able to run YaBB myself :(
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Advertisement: