Aloha - I am having quite a lot of trouble getting the SMF conversion for Invision to run.
Here is what I get:
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 284
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 335
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 442
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 452
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 532
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 566
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 649
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 659
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 668
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 693
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 781
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 791
successful.
Converting messages (step 2)... successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 944
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 954
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1001
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1020
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1090
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1100
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1175
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1185
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 /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1332
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1342
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1412
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1422
successful.
Converting board notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1483
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1493
successful.
Converting moderators...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1562
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1572
successful.
Converting group permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1652
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1693
successful.
Converting board permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1763
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1768
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1781
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/horry499/domains/horatians.org/public_html/invision_to_smf.php on line 1872
successful.
Converting board access... successful.
Converting smileys... successful.
Recalculating forum statistics... successful.
Converting forum settings... successful.
When I go to SMF the entire board is blank - and there are no users. Now I can't even admin the install.
Any suggestions? Thanks !
Either the MySQL user accounts you use for Invision and SMF have to be the same, or the SMF user has to be able to access tables in the Invision database.
These errors indicate that neither of the above are true. Future versions will give a better error message.
-[Unknown]
Is there anyway to convert the database without making the users the same? This host will not allow multiple users to share the same database. I can add multiple users but they must all be uniquely named.
So weird!
It is called DirectAdmin Web Control Panel.
Ideas? Sorry to be such a pest.
I would suggest simply installing SMF into the same database as Invision - it should be fine and cause no problems.
-[Unknown]
Thank you thank you thank you! Worked like a charm although not all the messages were converted. The post totals are all off, but it is a fairly good conversion :)
Quote from: Elora on November 16, 2004, 02:27:50 PM
Thank you thank you thank you! Worked like a charm although not all the messages were converted. The post totals are all off, but it is a fairly good conversion :)
Please go to Admin -> Forum Maintenance -> Recount all forum totals and statistics, as well as Find and repair all forum errors.
All of the posts should have been converted, but currently the totals are wrong.
-[Unknown]
Hi
I'm new to SMF and indeed yabb, i'm also not very familiar with using mySQL itself.
We've been asked by our host to close our invisionboard due to security problems, and have installed SMF, but we've loads we'd like to move onto the new forums.
We use version 1.1a of invision so would the above work ?
Are there any pitfalls we need to look out for ?
Our conversion went really well. After applying the above fixes, everything converted perfectly. I have a problem with orphan posts - but I think we can fix that.
I think SMF is a thousand times better than Invision. I can't believe it took us so long
I wish ours had :(
I get lots of errors and can't access the board at all now.
I copied the invision database and then our host populated the SMF database with the invision data, and we ran the script, the following was the result.....
Has anyone got any suggestions ? What did I do wrong ?
QuoteConverting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 284
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 335
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 347
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 349
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 355
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 367
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 442
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 452
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 532
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 566
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 649
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 659
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 668
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 693
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 781
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 791
successful.
Converting messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 829
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 870
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 944
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 954
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1001
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1020
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1090
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1100
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1175
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1185
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1223
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1263
successful.
Converting personal messages (step 3)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1332
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1342
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1412
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1422
successful.
Converting board notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1483
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1493
successful.
Converting moderators...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1562
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1572
successful.
Converting group permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1652
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1693
successful.
Converting board permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1763
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1768
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1781
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1872
successful.
Converting board access...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1903
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1905
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1912
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1918
successful.
Converting smileys...
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1974
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1976
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1985
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 1986
successful.
Recalculating forum statistics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2040
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2083
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2092
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2097
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2105
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2106
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2112
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2113
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2119
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2120
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2126
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/tcadmin/public_html/steh_SMF2/invision_to_smf.php on line 2127
successful.
Converting forum settings... successful.
Your errors were almost the same as mine - The solution was to install the SMF database WITH the Invison database. After the conversion process is complete and you are happy with the results delete the tables with the Invision prefix and you will be all set.
The errors as explain above are happening because the MySQL databases do not have the same passwords and/or usernames.
Hope this helps!
Quote from: Elora on November 21, 2004, 04:26:09 PM
The errors as explain above are happening because the MySQL databases do not have the same passwords and/or usernames.
Hope this helps!
Thanks, but not really, i'm no expert with mySQL as is probably obvious.
I exported the mySQL database from the IPB forum, and our host imported it back as the SMF forum, I've then run the conversion. I don't understand the "mySQL databases do not have the same passwords and/or usernames" since to my knowledge there is only one mySQL associated with the SMF forum. I'm concerned about losing the IPB forum as we have a big database.
I hope that makes sense, I know what I mean :)
Do you have cpanel ? Do you have PHPmyAdmin?
Yes both, though I can't access them from here (working) but i'm going home shortly for an hour or so.
With CPanel, give access to both the database SMF uses and Invision uses to the user for the SMF database.
For example, you might have "username_invision" and "username_smf" as databases and users. This is very common, and may very well have been what your host did.
For terminology:
MySQL: Database engine.
Your MySQL server: an installation of MySQL, on your server (hoster's) computer.
Database: One "area" of tables and data in MySQL; often, you can have up to five (or some number) of these per hosting account.
User account: A username and password used to access the MySQL server and its databases.
Does that help?
-[Unknown]
I have done that, but still get the same error messages.
If I understand you correctly in cPanel under user..... tcadmin_smf2 I give ALL priveledges to use tcadmin_our ipb database (I don't want to post the name as there is a security issue), i've done this but the errors still exist.
Please try the attached.
-[Unknown]
I think the issue is that the databases have to have the same user name and pass. Not just the permissions ... make sense?
Thanks both, the file you attached [Unknown] is that a different one than the one I was using for the conversion ? Thanks anyway I have uploaded it to the directory.
Elora - it makes sense but i'm not sure I can do that while our IPB is working still, and I don't want to close one and risk not getting the conversion to work.
I think maybe i'm part of the problem here, and misunderstood something early on.
I have re-installed and now have an SMF database and an IPB database (before I copied the IPB one and renamed it so that SMF looked at it), the SMF one is now a bare bones database, and there is access to the IPB one for the SMF user.
I'm going to try again shortly.
Quote from: cleavers1066 on November 21, 2004, 06:18:58 PM
Thanks both, the file you attached [Unknown] is that a different one than the one I was using for the conversion ? Thanks anyway I have uploaded it to the directory.
Elora - it makes sense but i'm not sure I can do that while our IPB is working still, and I don't want to close one and risk not getting the conversion to work.
I think maybe i'm part of the problem here, and misunderstood something early on.
I have re-installed and now have an SMF database and an IPB database (before I copied the IPB one and renamed it so that SMF looked at it), the SMF one is now a bare bones database, and there is access to the IPB one for the SMF user.
I'm going to try again shortly.
If you need more help - while I am no expert on SMF I am realy comfotable with the cpanel phpmyAdmin interface. Please let me know if you need naything else.
I'm getting nowhere sadly, i've un-installed and re-installed, but I cannot get it to work.
How i'm going about the process.
1. I install SMF.
2. I give permission for SMF to access to the invisionboard database.
3. I run the conversion.
I've had several answers, one posted above, another saying that the SMF database password is incorrect, and finally one telling me that SMF cannot access the invisionboard database.
Its very frustrating, as i'm obviously doing something wrong, but my knowledge of mySQL and phpMyAdmin are very limited.
Not sure what I did right, but after many attempts, the new day brought immediate success - funny that.
Thanks for all the help.
I call that "The Unexplained Law of Settling Technology" :D So glad you up and running! Good luck!
Quote from: [Unknown] on November 21, 2004, 05:56:26 PM
Please try the attached.
-[Unknown]
Not exactly sure what's different about this one than the one that's available on your download page, but this one converted my invision no problems (1.3f) whereas the other one just hung up and died.
Thanks! :D
Quote from: [Unknown] on November 21, 2004, 05:56:26 PM
Please try the attached.
-[Unknown]
Thanks for this patch, it worked like a charm 8) I can now dump my IPB forever!
SMF Rocks.
hi guys,
i am new to SMF, But just managed to convert my forum from Invision 1.2 (with the help of this thread).
But I have now a new problem.
Whenever i click on Boards in Admin CP it says
An Error Has Occurred! :-[
Board Java Software does not have a valid parent. Use the 'find and repair errors' function to fix this.
Please help ....
Admin -> Forum Maintenance -> find and repair errors'
And it should help you fix the errors.
Nopes !
already tried it ...
Not working :(
Waiting for a reply,
Please somebody help me out with this, I have been also facing problem with members logging in now, cause of conversion.
Well, worst case, try this query:
UPDATE smf_boards
SET ID_PARENT = 0, childLevel = 0;
What is phpMyAdmin? (http://www.simplemachines.org/community/index.php?topic=21919.0)
You'll have to reset all the child boards, but it will work.
-[Unknown]
Thats Great,
The query worked
thanks a Lot, i am Loving it :)
Saty
http://e-newideas.com/ (http://e-newideas.com)