Invision 1.3 converter - MySQL error converting group and board permissions

Started by Sirjump, May 21, 2006, 01:55:20 PM

Previous topic - Next topic

Sirjump

SMF Version: SMF 1.0.7
I am trying to download the invision 1.3 and below to smf file, but nothing happens when I go to the download page. I was able to get the new convert.php but it gives an error message, so I need the first version. Can someone please help me obtain the correct file?

Thanks.
Sirjump

kegobeer

It works for me.  Have you checked your browser's security settings?  Can you try downloading with another browser and/or another computer?

This is the link to the converter.  Try again.

http://www.simplemachines.org/download/index.php/invision_to_smf.php
"The truth of the matter is that you always know the right thing to do. The hard part is doing it." - Norman Schwarzkopf
Posting and you (Click "WATCH THIS MOVIE")

Sirjump

All I get when I click that link is the php file shown in text format... maybe I should install Opera browser and try again.

kegobeer

Right click, save as.  Choose all files as the file type.
"The truth of the matter is that you always know the right thing to do. The hard part is doing it." - Norman Schwarzkopf
Posting and you (Click "WATCH THIS MOVIE")

Sirjump

Ok got it and started it. Now this is the error I get;

Converting...
Converting messages... (this may take some time) successful.
Converting messages (step 2)... successful.
Converting polls... successful.
Converting poll options... successful.
Converting previous poll votes... successful.
Converting personal messages... successful.
Converting personal messages (step 2)... successful.
Converting personal messages (step 3)... successful.
Converting topic notifications... successful.
Converting board notifications... successful.
Converting moderators... successful.
Converting group permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sirjump/public_html/forum/invision_to_smf.php on line 1671

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/sirjump/public_html/forum/invision_to_smf.php on line 1711
successful.
Converting board permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sirjump/public_html/forum/invision_to_smf.php on line 1781

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/sirjump/public_html/forum/invision_to_smf.php on line 1786
successful.
Converting board access... successful.
Converting smileys... successful.
Recalculating forum statistics... successful.
Converting forum settings... successful.


And I get a database error when testing the forum...

Anyone? =)

kegobeer

Look in invision_to_smf.php and see what code is on line 1671, 1711, 1781 and 1786.  Also, now that you have an error message you can search the forum for similar conversion errors and potential solutions.

If you have any custom invision group/board permissions, or you altered those tables in any way, it's possible that's the root of the error.  However, I don't have any experience with the converters, so I'm sure you'll get better help when another support tech or dev reads this thread.
"The truth of the matter is that you always know the right thing to do. The hard part is doing it." - Norman Schwarzkopf
Posting and you (Click "WATCH THIS MOVIE")


Oldiesmann

Those errors indicate that the query which is attempting to convert group permissions didn't return any rows. If you can give me a copy of the structure for IPB's groups tables, I should be able to modify the converter to work for you.
Michael Eshom
Christian Metal Fans

Sirjump

Great! However you need to treat me like a newbie with this... I hope it is this file: http://www.gsrf.net/temp/sirjump_ivbd1.sql [nofollow] which I copied from the IPB sql database. Let me know if it's something else you need.

Thanks in advance,
Sirjump

Sirjump


Sirjump

Hmmm... would it be easier if I just try to convert the mysql database?

Advertisement: