News:

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

Main Menu

YaBB 2.1 to SMF 1.1.4

Started by Kray-Z, April 30, 2008, 09:08:57 PM

Previous topic - Next topic

Kray-Z

I am trying to convert YaBB 2.1 to SMF 1.1.4 and right out of the gate I am getting these errors repeatedly:

Notice: Undefined index: webtitle in /PATH/yabb2_to_smf.php on line 296
Notice: Undefined index: weburl in /PATH/yabb2_to_smf.php on line 297
Notice: Undefined index: position in /PATH/yabb2_to_smf.php on line 300
Notice: Undefined index: icq in PATH/yabb2_to_smf.php on line 301
Notice: Undefined index: aim in /PATH/yabb2_to_smf.php on line 302
Notice: Undefined index: yim in /PATH/yabb2_to_smf.php on line 303
Notice: Undefined index: msn in /PATH/yabb2_to_smf.php on line 304

Followed by:

Converting personal messages... Unsuccessful!
This query:

    ALTER TABLE `emotiond_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 and all help would be appreciated.

SleePy

It seems like that the personal messages column didn't have its primary key dropped.
You could manually change the column in the database to not be auto_increment and then delete the primary key.
If you use phpMyAdmin you will have a nice GUI to do this without needing to know anything really :)
This all needs done in the SMF Database.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Kray-Z

SleePy:
OK, I changed it so it's not Auto Increment and dropped the Primary Key, but I am still getting errors, when it trys to convert members, I still get this:

Notice: Undefined index: webtitle in /PATH/yabb2_to_smf.php on line 296
Notice: Undefined index: weburl in /PATH/yabb2_to_smf.php on line 297
Notice: Undefined index: position in /PATH/yabb2_to_smf.php on line 300
Notice: Undefined index: icq in PATH/yabb2_to_smf.php on line 301
Notice: Undefined index: aim in /PATH/yabb2_to_smf.php on line 302
Notice: Undefined index: yim in /PATH/yabb2_to_smf.php on line 303
Notice: Undefined index: msn in /PATH/yabb2_to_smf.php on line 304



Then I get a TON of these (Only put the first few)

Warning: array_keys() [function.array-keys]: The first argument should be an array in /PATH/yabb2_to_smf.php on line 1422

Warning: implode() [function.implode]: Bad arguments. in /PATH/yabb2_to_smf.php on line 1422
Unsuccessful!
This query:

    INSERT INTO `tablename_smf1`.smf_members
    ()
    VALUES ('ferenes', '5506a2f1015b1bdf925386ca1c18b6a5', 'ferenes', '[email protected]', '', '', 'Use the light.', '11', '0', '', '', '', '[email protected]', '1', 'emotionDV Rules!', 'blank.gif', '1151514669', 'monterrey, mexico', '1979-06-23', '0', '1176329888', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
    ('PaspKayanda', '431b67f3bca68b333d019557ae1a2c9b', 'PaspKayanda', '[email protected]', '', '', '', '0', '0', '', '', '', '', '0', 'emotionDV Rules!', 'blank.gif', '1198761034', '', '0001-01-01', '1', '', '0', '0', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),

Caused the error:

    Column count doesn't match value count at row 1

SleePy

And you are using these files (both the attached sql and linked convert.php)?
http://www.simplemachines.org/community/index.php?topic=122338.0
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

Advertisement: