Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: Majji on August 13, 2009, 06:22:12 AM

Title: YaBB 1 Gold - SP 1.3.1 conversion (Without being able to upgrade to 2.4)
Post by: Majji on August 13, 2009, 06:22:12 AM
Update:  I downloaded the yabb_to_smf.php file found on another post.  Members transferred.  But now I'm getting a new error below...

Converting...
Converting personal messages...
Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 452

Notice: Undefined offset: 1 in /public_html/forum/yabb_to_smf.php on line 457

Notice: Undefined offset: 2 in /public_html/forum/yabb_to_smf.php on line 458

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 459

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 452

Notice: Undefined offset: 1 in /public_html/forum/yabb_to_smf.php on line 457

Notice: Undefined offset: 2 in /public_html/forum/yabb_to_smf.php on line 458

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 459

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 452

Notice: Undefined offset: 1 in /public_html//forum/yabb_to_smf.php on line 457

Notice: Undefined offset: 2 in /public_html/forum/yabb_to_smf.php on line 458

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 459

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 452

Notice: Undefined offset: 1 in /public_html/forum/yabb_to_smf.php on line 457

Notice: Undefined offset: 2 in /public_html/forum/yabb_to_smf.php on line 458

Notice: Undefined offset: 3 in /public_html/forum/yabb_to_smf.php on line 459
Unsuccessful!
This query:

    ALTER TABLE `_smf1`.smf_personal_messages
    CHANGE COLUMN ID_PM ID_PM int(10) unsigned NOT NULL auto_increment PRIMARY KEY;

Caused the error:

    Multiple primary key defined

Any Ideas???

P.s. Original post below...


Hello,

I have an old Yabb forum vs. 1.3.1.  Its not likely I'll be able to upgrade it to 2.4 before making the conversion to SMS. So I gave the yabb 1 converter a try. 

Here is the error I'm getting...


YaBB 1 Gold to SMF Converter
Converting...
Converting members... Unsuccessful!
This query:

    ALTER TABLE `acneyoda_smf2`.smf_members
    ORDER BY ID_MEMBER = 0, dateRegistered;

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 '= 0, dateRegistered' at line 2

Anyone know how to fix?

Any help is greatly appreciated.


Title: Re: YaBB 1 Gold - SP 1.3.1 conversion (Without being able to upgrade to 2.4)
Post by: ThorstenE on August 22, 2009, 05:34:03 AM
Majji, do you still require assistance with this issue? Our old YaBB converters are buggy, is there any change to upgrade to a newer YaBB version (e.g. 2.1, 2.2)?