Trying to convert from YaBB 1.3.1 Gold to latest SMF

[doulos12]

Installed. No prob.
Ran converter: couldn't convert membergroups.
Found http://www.simplemachines.org/community/index.php?topic=134431.msg870746#msg870746

membergroups successful, but:

Converting members... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.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

[doulos12]

I tried starting over and got this:

Converting membergroups... Successful.
Converting members... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint( unsigned NOT NULL default 0;
Caused the error:
Can't DROP 'PRIMARY'; check that column/key exists

[SleePy]

I would recommend first upgrading to Yabb 2.1 before performing the conversion. The converters was targeted for Yabb 2.1
I edited the problem though out of the file. Since the conversion failed you will have to install SMF again.
Sadly for the converter to do its work, it needs to edit the tables in the SMF database to perform the conversion, since it failed it didn't make it to the step where it fixes them

[doulos12]

Better:

Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_personal_messages
ORDER BY ID_PM = 0, msgtime;
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, msgtime' at line 2

(And I can't upgrade YaBB, since I moved to a new server, and YaBB isn't working now--seemed like a good time to switch to SMF.)
If I have to reinstall again, does that mean delete the database as well as re-upload the php, or just delete & recreate the database? Sorry for the n00b question.

[SleePy]

Ok give this one a try. I found 3 others that had this weird code in it.

[doulos12]

It gets a little farther each time:

Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:
INSERT INTO `crossfe_oafc`.smf_log_boards
(ID_MEMBER, ID_BOARD)
VALUES ('91', '2'),
('91', '6'),
('', '2'),
('76', '2'),
('76', '6'),
('76', '3'),
('', '2'),
('', '1'),
('', '2'),
('', '2'),
('', '2'),
('', '2'),
('', '2'),
('', '2'),
('', '6'),
('', '2'),
('', '3'),
('', '5'),
('', '1'),
('', '4');
Caused the error:
Duplicate entry '0-2' for key 1

[SleePy]

Hopefully this one makes it
I added it to ignore the errors from those

[doulos12]

Looking pretty good now, but one more, looks like:

Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `crossfe_oafc`.smf_smileys
ORDER BY LENGTH(code) DESC;
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 'LENGTH(code) DESC' at line 2


Forum stats aren't all that important to me, so is that the last thing?

And BTW, I really appreciate your help here.

[SleePy]

Common conversion errors.

I am hoping with the SMF 2.0 converter I am working on shouldn't have this error, but for now its a simple edit of the file

[karel.mokry]

Hi, I have similar problem (need to upgrade from 1.3). I used latest converter from this thread and received following error:

Converting personal messages... Unsuccessful!
This query:

    INSERT INTO `smf`.smf_pm_recipients
    (ID_PM, ID_MEMBER, labels)
    SELECT hxxp:pm.id [nonactive]_PM, hxxp:mem.id [nonactive]_MEMBER, '-1' AS labels
    FROM (`smf`.smf_personal_messages AS pm, `smf`.smf_members AS mem)
    WHERE mem.memberName = pm.temp_toName
    AND pm.temp_toName != '';

Caused the error:

    Duplicate entry '0-46' for key 1

Any idea what to modify? Thanks for your support.

[ThorstenE]

slow server performance is sometimes a reason for duplicate entry.. try conversion again from the beginning.. if you receive the same error there must be a duplicate in the pm_recipients..

then edit the yabb_to_smf.php

search for

Code Select Expand

INSERT INTO {$to_prefix}pm_recipients
replace with

Code Select Expand

INSERT IGNORE INTO {$to_prefix}pm_recipients
and restart conversion.

Hope it works ..