from YaPP to SMF

[JayBachatero]

WTF was I thinking .  I was working on both of them at the same time.

[Poasters]

haha, I figured as much.

This last one appears to hang at the topic notifications conversion. I let it go for about 45 min.

./smf/convert.php?step=1&substep=23&start=0

Converting...
Converting topic notifications... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.

[JayBachatero]

So it never increases or refreshes?

[Poasters]

Well it continues to refresh, but it is stuck on the same page for 90 min. now.

[JayBachatero]

./smf/convert.php?step=1&substep=23&start=0 that hasn't changed?

[JayBachatero]

Try this one.

[Poasters]

Yes. It started the same way the previous converter started. Members were converted, message topics converted, etc. Then it reached that page and continued refreshing, but had not advanced further.

EDIT: OK, I'll try this new one.

[JayBachatero]

Let me know how that one goes.

[Poasters]

This one gives the following error:
./smf/convert.php?step=1&substep=10&start=81200

Converting...
Converting posts (this may take some time)... Unsuccessful!
This query:

    INSERT INTO `xpoaster_steve2`.smf_messages
    (ID_MSG, ID_TOPIC, ID_BOARD, ID_MEMBER, posterTime, posterName, posterEmail, posterIP, subject, smileysEnabled, modifiedTime, modifiedName, body, icon)
    VALUES ('83856', '13256', '4', '4114', '1139159648', 'johnamazing', '[email protected]', '69.216.18.135', 'Re:My House is Sinking Around My Computer!', '1', '', '', 'Yeah, that JimZ, he\'s hired! ', 'xx'),

[truncated for neatness]

Caused the error:

    Duplicate entry '83856' for key 1

EDIT: it seems that several people on this board today are having the same duplicate entry error. Maybe someone left a tag open somewhere?

[JayBachatero]

Ok give this one a try.

[Poasters]

This was the result:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...
Notice: Undefined variable: to_prefis in /home/xpoaster/public_html/steve2/smf/convert.php(714) : eval()'d code on line 1
Unsuccessful!
This query:

    ALTER TABLE messages
    DROP PRIMARY KEY
    DROP INDEX topic,
    DROP INDEX ID_BOARD,
    DROP INDEX ID_TOPIC,
    DROP INDEX ID_MEMBER;

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 'DROP INDEX topic,
    DROP INDEX ID_BOARD,
    DROP INDEX ID_TOPIC,
    DROP INDEX ID_MEM' at line 3

[JayBachatero]

mental note to self.  ALWAYS check spelling .

[Poasters]

Here was the result:

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    ALTER TABLE `xpoaster_steve2`.smf_messages
    DROP PRIMARY KEY,
    DROP INDEX topic,
    DROP INDEX ID_BOARD,
    DROP INDEX ID_TOPIC,
    DROP INDEX ID_MEMBER;

Caused the error:

    Incorrect table definition; there can be only one auto column and it must be defined as a key

[JayBachatero]

Ok hopefully this one will work.

[Poasters]

After converting the posts, it stopped with this error:

Converting...
Converting posts (this may take some time)... Successful.
Redtoring Keys and indexes... Unsuccessful!
This query:

    ALTER TABLE `xpoaster_steve2`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY"
    ALTER TABLE `xpoaster_steve2`.smf_messages
    ADD UNIQUE INDEX topic (ID_TOPIC, ID_MSG);

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 '"
    ALTER TABLE `xpoaster_steve2`.smf_messages
    ADD UNIQUE INDEX topic (ID_TOPIC, I' at line 2

[JayBachatero]

Damn it.

[Poasters]

Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Unsuccessful!
This query:

    ALTER TABLE `xpoaster_steve2`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    DROP INDEX topic,
    DROP INDEX ID_BOARD,
    DROP INDEX ID_TOPIC,
    DROP INDEX ID_MEMBER;

Caused the error:

    Can't DROP 'PRIMARY'; check that column/key exists

[JayBachatero]

ARGGGGG.  I was expecting this.

Run this query in phpmyadmin.

Code Select Expand

ALTER TABLE smf_messages
CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL auto_increment PRIMARY KEY;

Ok use these two files.

[Poasters]

OK, here is the result of the SQL query:

Your SQL query has been executed successfully (Query took 0.0963 sec)
SQL query: ALTER TABLE smf_messages CHANGE COLUMN ID_MSG ID_MSG int( 10 ) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY ;

The converter just posted failed:

Converting...
Converting members...
Fatal error: Call to undefined function: stripos() in /home/xpoaster/public_html/steve2/smf/convert.php on line 698

[JayBachatero]

Darn it.  I thought stripos was built into 4.x also not just 5.x.  Here.