Yabb to SMF conversion process stuck!

[rooster]

Hi,

I was trying out the conversion of YaBB Gold SP 1.1 to SMF.

No problems installing SMF 1.02.

The conversion process with yabb_to_smf.php also seemed to be going well UNTIL at one stage, the page was constantly refreshing:

http://www.mywebsite.com/forum/yabb_to_smf.php?step=11&start=0

with the usual comments:

Converting...
Converting topics... (part 2) 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.



After 10 hours since the start of conversion, it was still refreshing...

Has anyone experienced this problem before? What should I do?

Thanks.

[Oldiesmann]

Hmmm... That "start" value on the end of the URL should be increasing each time it refreshes...

[[Unknown]]

Actually, it won't for that step.  Even so, it shouldn't take 10 hours.

Step 11 is setting the ID_MSG though, not converting topics.  Can you run these two queries, please, and tell me trh results?

SELECT COUNT(*)
FROM smf_messages;

SELECT COUNT(*)
FROM smf_messages
WHERE ID_MSG = 0;

What is phpMyAdmin?

Are you completely sure you're using the latest version of the converter?

-[Unknown]

[kyke]

Hello,

I'm having this same problem!  After several hours of migration, it still reloads on step=11 and start=0. The two SQL queries give me the same number, 35790 messages. Maybe the second number should be lower on each step?

I've downloaded the converter "yabb_to_smf.php" from the downloads section on this web.

Thanks in advance!

[kyke]

more info for the debuggers... from "mysql.log" i can get this while "function doStep11()" is on exec:

                   2089 Query       ALTER TABLE `ostua`.smf_messages
                        ORDER BY posterTime
050901 23:33:56    2089 Query       SELECT ID_MSG + 1
                FROM `ostua`.smf_messages
                ORDER BY ID_MSG DESC
                LIMIT 1
050901 23:33:57    2089 Quit
050901 23:34:01    2091 Connect     ostua@localhost on
                   2091 Query       SELECT value
                FROM `ostua`.smf_settings
                WHERE variable = 'smfVersion'
                LIMIT 1
                   2091 Query       ALTER TABLE `ostua`.smf_messages
                        ORDER BY posterTime
050901 23:34:21    2091 Query       SELECT ID_MSG + 1
                FROM `ostua`.smf_messages
                ORDER BY ID_MSG DESC
                LIMIT 1
050901 23:34:23    2091 Quit
050901 23:34:26    2092 Connect     ostua@localhost on
                   2092 Query       SELECT value
                FROM `ostua`.smf_settings
                WHERE variable = 'smfVersion'
                LIMIT 1
                   2092 Query       ALTER TABLE `ostua`.smf_messages
                        ORDER BY posterTime
050901 23:34:46    2092 Query       SELECT ID_MSG + 1
                FROM `ostua`.smf_messages
                ORDER BY ID_MSG DESC
                LIMIT 1
050901 23:34:48    2092 Quit
050901 23:34:51    2093 Connect     ostua@localhost on
                   2093 Query       SELECT value
                FROM `ostua`.smf_settings
                WHERE variable = 'smfVersion'
                LIMIT 1
050901 23:34:52    2093 Query       ALTER TABLE `ostua`.smf_messages
                        ORDER BY posterTime
050901 23:35:10    2093 Query       SELECT ID_MSG + 1
                FROM `ostua`.smf_messages
                ORDER BY ID_MSG DESC
                LIMIT 1
050901 23:35:12    2093 Quit

and so on...

so checking the PHP file it seems it never enters the while loop on line 1640?