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.
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.
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
And you are using these files (both the attached sql and linked convert.php)?
http://www.simplemachines.org/community/index.php?topic=122338.0