Title: xmb - smf convertor not working
Post by: jmiller on June 28, 2004, 06:30:58 PM
Post by: jmiller on June 28, 2004, 06:30:58 PM
hey i have a large forum thats on xmb software that i'd like to convert to smf and i set up both forums on my test server to see if they worked and when i ran the xmb_to_smf.php file to convert my xmb over everything completed but theres a ton of errors along with it as it was converting which is shown above. Ive also gotten both forums installed completely and working before trying to run the conversion file. There anything i need to chmod or what to get this workin, thanks :-\
Code Select
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 283
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 293
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 400
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 410
successful.
Converting boards)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 505
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 515
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 527
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 536
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 551
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 630
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 640
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 649
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 676
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 758
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 768
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 817
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 877
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 954
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 964
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1033
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1043
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1114
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1124
successful.
Converting banned members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1209
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1219
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1231
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1238
successful.
Converting forum settings...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1296
Warning: Invalid argument supplied for foreach() in /home/jmiller/public_html/board/xmb_to_smf.php on line 1298
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1309
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1349
Warning: Invalid argument supplied for foreach() in /home/jmiller/public_html/board/xmb_to_smf.php on line 1351
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1356
successful.
Converting board moderators...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1402
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/jmiller/public_html/board/xmb_to_smf.php on line 1415
successful.
Converting board access... successful.
Converting smileys... successful.
Recalculating forum statistics... successful.
Title: Re: xmb - smf convertor not working
Post by: Grudge on June 28, 2004, 06:38:42 PM
Post by: Grudge on June 28, 2004, 06:38:42 PM
I would guess both forums are installed on seperate databases. If that is the case you need to ensure your mySQL database user for the SMF database has access to the XMB database too.
Title: Re: xmb - smf convertor not working
Post by: [Unknown] on June 28, 2004, 06:39:11 PM
Post by: [Unknown] on June 28, 2004, 06:39:11 PM
What version of XMB was this?
-[Unknown]
-[Unknown]
Title: Re: xmb - smf convertor not working
Post by: jmiller on June 28, 2004, 06:42:02 PM
Post by: jmiller on June 28, 2004, 06:42:02 PM
Quote from: [Unknown] on June 28, 2004, 06:39:11 PM
What version of XMB was this?
-[Unknown]
xmb 1.8 sp2 but the large forum im converting will be 1.8 sp3 should work, so put the smf database user on the same database as xmb and it should work?
Title: Re: xmb - smf convertor not working
Post by: Grudge on June 28, 2004, 06:43:35 PM
Post by: Grudge on June 28, 2004, 06:43:35 PM
Quote from: jmiller on June 28, 2004, 06:42:02 PMQuote from: [Unknown] on June 28, 2004, 06:39:11 PM
What version of XMB was this?
-[Unknown]
xmb 1.8 sp2 but the large forum im converting will be 1.8 sp3 should work, so put the smf database user on the same database as xmb and it should work?
It will certainly have a much better chance yes. By which I mean it won't work at all otherwise!
Title: Re: xmb - smf convertor not working
Post by: jmiller on June 28, 2004, 06:44:46 PM
Post by: jmiller on June 28, 2004, 06:44:46 PM
thanks alot guys ;D
Title: Re: xmb - smf convertor not working
Post by: jmiller on June 28, 2004, 07:36:57 PM
Post by: jmiller on June 28, 2004, 07:36:57 PM
hey it worked on my large forum but i get this and i hit continue and it loads and stays at the same page :o help please. The forums and topics are converted but no members or anything. new forum: http://4130riders.com/forums
Code Select
Converting...
Converting messages... (this may take some time) 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.
Title: Re: xmb - smf convertor not working
Post by: Oldiesmann on June 29, 2004, 09:46:21 AM
Post by: Oldiesmann on June 29, 2004, 09:46:21 AM
Try running it again from the beginning, but this time check the box next to "output extra debugging information". This will give you more details as to what it's doing.
Title: Re: xmb - smf convertor not working
Post by: jmiller on June 29, 2004, 12:34:22 PM
Post by: jmiller on June 29, 2004, 12:34:22 PM
Quote from: Oldiesmann on June 29, 2004, 09:46:21 AM
Try running it again from the beginning, but this time check the box next to "output extra debugging information". This will give you more details as to what it's doing.
i put the xmb_to_smf.php file in the xmb directory correct? i did that and it did work so now im sititng here waiting for my host to send me the backup he made of the sql yesterday because all the xmb settings have been erased somehow in the tables >:(, I dont see that output extra debugging information area heres all i see in step 1.
Title: Re: xmb - smf convertor not working
Post by: Oldiesmann on June 29, 2004, 02:33:33 PM
Post by: Oldiesmann on June 29, 2004, 02:33:33 PM
Ok. Nevermind then. Most of those things have an option to output extra debugging info. As far as where you put the file, it's best to put it in the directory you're installing SMF in, which in your case is the same as the XMB directory.
Title: Re: xmb - smf convertor not working
Post by: [Unknown] on June 30, 2004, 02:25:31 AM
Post by: [Unknown] on June 30, 2004, 02:25:31 AM
SMF's converters don't touch the xmb tables with any write queries.
-[Unknown]
-[Unknown]