Hello!
Thanks for this nice software first!!
Im trying to convert from Inv to SMF right now with the converter, everything is installed correctly and running (smf and invision), but it gives the following errors when running the converter:
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 283
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 293
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 400
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 410
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 491
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 501
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 584
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 594
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 603
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 628
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 710
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 720
successful.
Converting messages (step 2)... successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 871
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 881
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 928
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 946
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1016
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1026
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1101
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1111
successful.
Converting personal messages (step 2)... successful.
Converting personal messages (step 3)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1256
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1266
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in D:\WWW\fscforums\www\invision_to_smf.php on line 1336
and so it continues with all tables....
What should I do? I have already closed the old board so its extremely important for me to get it up quickly :(.
Thanks!!
P.S.
Its a Windows 2003 Server machine with MySQL 4.0 and Apache2.
Make sure you entered the correct database prefix for your IPB. If you're using two different databases, make sure that the same user has access to both databases.
Yeah got it! Thanks!
No problem.
Quote from: Oldiesmann on June 01, 2004, 10:32:03 AM
Make sure you entered the correct database prefix for your IPB. If you're using two different databases, make sure that the same user has access to both databases.
I'm trying to convert also and having the same problem. My two forums are in two different databases. What do you mean by make sure the same user has access to both databases and how do I do that?
Well, if you're using cpanel:
Login and click on "MySQL Databases"
Scroll down to the bottom. Select the username that you're using for the IPB database from the "User:" drop-down list. Select the SMF database from the "Database:" drop-down list and click "Add user to db". This will allow you to access the SMF and IPB databases with the same username and password.