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 (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.
gonna try bumping this, since I made some modifications to the first post.
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
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) { - => array(4) { ["file"]=> string(49) "/home/XXXXXX/public_html/forum/yabb21_to_smf.php" ["line"]=> int(219) ["function"]=> string(10) "alterTable" ["args"]=> array(4) {
- => &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) {
- => &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) {
- => &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 ''
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...
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 (http://www.simplemachines.org/community/index.php?topic=122338.msg3735854#msg3735854)). 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 :-\
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 ;)
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.
Quote from: Bazie on December 01, 2014, 05:19:38 AMQuote 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)
Thank you.
This converter clearly needs some "love" :( I was never able to run YaBB myself :(