Topic: YaBB 1 Gold SP 1.3.1 --> SMF 1.1.2 problem

[kailef]

I'm tearing my hair out on this one.     YaBB is a mind-bogglingly annoying forum system.  SMF is it's natural evolution, and I really want to use it, but not at the expense of losing 30,000 posts and my entire user base.

I'm getting the following error when I try to convert:

Code: [Select]

Converting...
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Unsuccessful!
This query:

    ALTER TABLE `wowguild_com_-_smf`.smf_categories
    ADD tempID tinytext;

Caused the error:

    Duplicate column name 'tempID'

I've tried the normal yabb_to_smf.php as well as the one posted by Boris with the same results.

Interestingly enough, the FIRST time this happened I got errors when converting the "mark read data", which is the step after this one.  That's what prompted me to use Boris' version, and from that point forward I've been getting the above error every time, regardless of which 'yabb_to_smfold.php' I use.  I'm afraid I didn't save a copy of the very first error I got.

[kailef]

I created a clean install of SMF again, and ran Boris' conversion script so that I could get the error that I originally saw.  The first time I run the convert script on a clean SMF install, it DOES successfully convert boards and categories, and then fails on 'mark read data'.  Here's the error.  I suspect that perhaps the error listed in my last post is irrelevant, since on a first run it works.  Maybe the converter isn't properly clearing out the boards that it imported before?  I'm just guessing, I'm not much of a coder.  Anyhow, here's the first-run error:

Code: [Select]

YaBB 1 Gold to SMF Converter
Converting...
Converting membergroups... Successful.
Converting members... Successful.
Converting settings... Successful.
Converting personal messages... Successful.
Converting boards and categories... Successful.
Converting mark read data... Unsuccessful!
This query:

    INSERT INTO `wowguild_com_-_smf`.smf_pif_log_boards
    (ID_MEMBER, ID_BOARD)
    VALUES ('', '2'),
    ('16', '1'),
    ('152', '5'),
    ('152', '4'),
    ('152', '3'),
    ('152', '2'),
    ('217', '5'),
    ('64', '11'),
    ('64', '5'),
    ('64', '2'),
    ('64', '13'),
    ('64', '3'),
    ('64', '4'),
    ('10', '3'),
    ('10', '1'),
    ('10', '2'),
    ('10', '12'),
    ('10', '16'),
    ('23', '2'),
    ('23', '12'),
    ('8', '7'),
    ('8', '1'),
    ('8', '3'),
    ('8', '9'),
    ('8', '13'),
    ('8', '10'),
    ('8', '5'),
    ('8', '4'),
    ('8', '11'),
    ('8', '6'),
    ('8', '2'),
    ('8', '18'),
    ('26', '17'),
    ('26', '12'),
    ('26', '5'),
    ('26', '7'),
    ('26', '1'),
    ('26', '3'),
    ('26', '4'),
    ('26', '11'),
    ('26', '9'),
    ('26', '6'),
    ('26', '8'),
    ('26', '2'),
    ('26', '13'),
    ('26', '16'),
    ('26', '10'),
    ('127', '10'),
    ('127', '5'),
    ('127', '1'),
    ('127', '8'),
    ('127', '2'),
    ('127', '4'),
    ('43', '5'),
    ('43', '2'),
    ('43', '4'),
    ('1', '12'),
    ('1', '7'),
    ('1', '1'),
    ('1', '3'),
    ('1', '9'),
    ('1', '13'),
    ('1', '10'),
    ('1', '17'),
    ('1', '5'),
    ('1', '4'),
    ('1', '14'),
    ('1', '11'),
    ('1', '6'),
    ('1', '8'),
    ('1', '2'),
    ('1', '16'),
    ('1', '15'),
    ('1', '18'),
    ('33', '11'),
    ('33', '2'),
    ('33', '1'),
    ('33', '12'),
    ('33', '13'),
    ('67', '2'),
    ('60', '2'),
    ('51', '11'),
    ('51', '2'),
    ('51', '3'),
    ('51', '4');

Caused the error:

    Duplicate entry '0-2' for key 1

Anyone able to help?

[kailef]

I solved the issue, so for the benefit of anyone who runs into this particular problem in the future, here's what I did:

By the way, the procedure worked on my second YaBB installation as well... That forum had exactly the same problems, but was 1.3.2 rather than 1.3.1.

I had to (A) use the modified script found here: http://www.simplemachines.org/community/index.php?topic=134431.0  and (B) delete all the *.dat files that store the read/unread flags in YaBB's /members folder.  Then, the script will run and fail at the second part of the message conversion phase, saying that MSG_ID has duplicate entry ####### for key 1.  At that time, I directly modify the SQL database by deleting MSG_ID, recreating it at the top with the same attributes (Integer, 10 characters, etc) and set it as an auto-incremented primary key.  This populates the MSG_ID field with unique numbers.  Then, I remove the auto increment, and then drop the PRIMARY attribute, and tell the conversion script to "try again".  And viola, it works.  Pain in the butt, though, if you're not comfortable with goofing around with MySQL.