Advertisement:

Author Topic: Error message when converting YaBB 2.1 to SMF 2  (Read 17027 times)

Offline daoloth

  • Newbie
  • *
  • Posts: 2
Error message when converting YaBB 2.1 to SMF 2
« on: August 06, 2011, 01:27:00 PM »
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:

Code: [Select]
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 530and
Code: [Select]
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.
« Last Edit: August 17, 2011, 07:32:54 AM by daoloth »

Offline daoloth

  • Newbie
  • *
  • Posts: 2
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #1 on: August 17, 2011, 07:34:05 AM »
gonna try bumping this, since I made some modifications to the first post.

Offline duuso

  • Semi-Newbie
  • *
  • Posts: 11
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #2 on: January 29, 2013, 08:33:45 AM »
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:
Code: [Select]
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:
Code: [Select]
$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:
Code: [Select]
$availableKeys = array_flip($smcFunc['db_list_indexes']("$tableName"));
Then I went again to convert.php, after hitting OK I'll get:
Code: [Select]
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
« Last Edit: January 30, 2013, 03:35:43 PM by duuso »

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #3 on: November 30, 2014, 01:37:06 PM »
I'm trying to update Yabb 2.1 to SMF and I get that same error message like duuso. How this problem is solved?

Quote
Converting...
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 ''

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #4 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
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

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

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #5 on: December 01, 2014, 01:24:57 AM »
I 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 :-\

And try with SMF 1.1.19.
I can try but I believe I can't install 1.1 because of newer version MySQL :-\

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #6 on: December 01, 2014, 05:01:33 AM »
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

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

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #7 on: December 01, 2014, 05:19:38 AM »
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 ;)
Version is 5.5.40-cll. I will try conversion with 1.1.19 later today.

Offline Bazie

  • Semi-Newbie
  • *
  • Posts: 92
  • Gender: Male
  • Tä?
    • Bazie.net
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #8 on: December 01, 2014, 02:28:21 PM »
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 ;)
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:
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)

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: Error message when converting YaBB 2.1 to SMF 2
« Reply #9 on: December 01, 2014, 02:34:27 PM »
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

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