News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

YABb 2.1 conversion errors

Started by vfrjon, August 06, 2008, 09:48:14 PM

Previous topic - Next topic

vfrjon

Sorry if I shouldnt start a new thread re this, but I am having trouble converting a YABB 2.1 forum to SMF.

Following is the conversion report I am getting, it seems to have numerous errors in it.

Can anyone advise what I have done wrong, what I need to do to get this to work.

Any help appreciated.

Jon

Quote
Converting...

Notice: Undefined index: convert_script in *****www.mywebsite*****/htdocs/smf/convert.php on line 580

Warning: Invalid argument supplied for foreach() in *****www.mywebsite*****/htdocs/smf/convert.php on line 583

Notice: Undefined index: convert_script in *****www.mywebsite*****/htdocs/smf/convert.php on line 588
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 935

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 945

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 953

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 963

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 976

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 989

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1035

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1037

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1043

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1049

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1060

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1061

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1069

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1071

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1077

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1078

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1084

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1085

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1109

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1111

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1117

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1129

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1154

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1156

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1192

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1193

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1236

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1299

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1335

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1354

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1827

Notice: Undefined variable: result in *****www.mywebsite*****/htdocs/smf/convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in *****www.mywebsite*****/htdocs/smf/convert.php on line 1378
Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)

Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the
Notice: Undefined index: name in *****www.mywebsite*****/htdocs/smf/convert.php on line 1454
installation.

We hope you had a smooth transition!

vfrjon

OK, I found the problem. Had something to do with php sessions which I have rectified.

I now get this result.......

Converting...
Converting membergroups... Successful.
Converting members... Unsuccessful!
This query:

    ALTER TABLE `vfr_smf`.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



I have a member list, but no posts or boards in the forum

Regards Jon

SleePy

Give this file a go and let me know if it works :)
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

Thanks Sleepy.

It got through the above errors, but now it hangs (over an hour, before I gave up) at 'Converting posts (part 3)...'

Should I flush the database, upload and install fresh SMF, and then convert?

Regards Jon

JMB

Quote from: vfrjon on August 10, 2008, 07:31:50 AM
Thanks Sleepy.

It got through the above errors, but now it hangs (over an hour, before I gave up) at 'Converting posts (part 3)...'

Should I flush the database, upload and install fresh SMF, and then convert?

Regards Jon

Converting posts (part 3) can take hours! My forum has over 250,000 posts and part 3 takes over 4 hours to complete. Have patience!  ;)

SleePy

Yes the last part can take hours.

You can try to change the block_size though if you want. If your server can easily handle the larger size of data at once then go for it. You can't change it though if you are converting via command line since the file isn't reloaded.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

Forum only has about 11000 posts, so its not that big.

I just let it run for a bit over an hour before the server timed out. Trying it again now......

If that fails, I will try changing the block size. 
Its currently set at 100 I believe. What would you suggest? 200?

SleePy

Depends on what your server can handle.

During a test of a very big board I had (it was over 500 mb), on my laptop (which is a dual 2.2 ghz, 2 gb ram, and php/mysql has no memory limits usage) I pushed it all the way to 100,000 posts at a time :D This was a Yabb 2.2 board, but it doesn't make a difference.

I think part of the issue may be missing indexes which slow down the selects. I may need to look into seeing if I can't add any sort of index there and see if it works ok still.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

#8
Stiil hangs until server times out on Converting posts (part 3)... Incomplete.

I have noticed that the stpes in the Address bar are not increasing as they had in all other steps. They are stuck at .......forum/convert.php?step=1&substep=12&cstep=12&start=0

Ive had a look at the data base it has built and populated.....
All posts are there, and looking at all the other tables in the db, they too have been populated.
I can not log in to the forum, it claims only registered usres can!

Regards Jon

SleePy

Step 12 doesn't increment like the others. Since what it does in its work is attempts to remove guest posts and topics that need to be linked to profiles, it only is looking for that until it has found them all.

Though you can give the below one a try, it just increments the steps, even though it has no affect on the converter. It at least gives user feedback  :P
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

Thanks for your replys and your patience  :D

Got it to run, sort of..........

Server timed out a few times, but because the steps were displayed in the address bar, I could just hit "go" again and it would continue on. This kept up for about 6 hours and at Step 1 Substep ~64500 cstep 12 I changed to Step 1 Substep0 cstep 13 for fun! It continued on and displayed this......

Quote
Converting...
Cleaning up (part 2)... Unsuccessful!
This query:

    SELECT t.ID_TOPIC, MIN(m.ID_MSG) AS ID_FIRST_MSG, MAX(m.ID_MSG) AS ID_LAST_MSG
    FROM (`vfrsmf`.smf_topics AS t, `vfrsmf`.smf_messages AS m)
    WHERE m.ID_TOPIC = t.ID_TOPIC
    GROUP BY t.ID_TOPIC
    LIMIT 1800, 150;

Caused the error:

    The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay


SleePy

Run this query in phpmyadmin
SET SQL_BIG_SELECTS=1

http://dev.mysql.com/doc/refman/5.0/en/set-option.html

That is just saying that the data you are trying to grab is bigger than what is allowed in a select. You just need to tell it to ignore this for a while.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

OK, Ill give that a try. 
Can I restart mid conversion, or should i start from scratch again?

Should it take that long to convert (over 6 hours)? We only have about 11000 posts and 300 members. Seems a long time in reference to JMB's reply
QuoteConverting posts (part 3) can take hours! My forum has over 250,000 posts and part 3 takes over 4 hours to complete. Have patience!  ;)


SleePy

What is the current url after the convert.php?
I am mainly looking for the substep in that to see what it is currently at. This number should usually reflect how many of something it has converted, since this is posts it would mean most likely how many posts it has gone through in that step (Though this may be that weird step that doesn't have this done in it).

Have you also looked at the mysql process list? I used this while testing the yabb 2.2 converters to identify what it was doing exactly. It may be that it is taking so long due to it having to copy to the temp table while doing a select. Which would explain why this is taking a while.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

Pretty sure the url was convert.php&step=1&substep=64500&cstep=12&start=0 when I killed it as I had to log off and go home.
No,, I havent looked at the mysql process list. I will h=get it running when I get home and have a look.

SleePy

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

#16
OK, runs fine throught the post converting now, but still stops with the same error as shown above
(at convert.php?step=1&substep=1800&cstep=15&start=0)

This is after I set SET SQL_BIG_SELECTS=1 in myphpadmin on the SQL TAB
Can I verify this is set somehow. It returned saying it was sucsessful.
When I check in the variable list it says its off!

SleePy

Are you able to browse to the SMF Forum? We might just need to do the very last step ourselves in the Admin panel under Forum Maintenance.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

vfrjon

Yes, I can get to the forum, but cant log in any more.


Advertisement: