3rd try-IPB v1.2 to SMF RESOLVED:-)

[catfished]

Well I tried it again and I got all the same errors. I'll start with the errors during the actual conversion process:
Converting members... successful.
Converting categories... successful.
Converting boards...
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 553

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/catfish/public_html/forums/invision_to_smf.php on line 554
successful.
Converting topics... successful.
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... successful.
Converting board permissions... successful.
Converting board access... successful.
Converting smileys... successful.
Recalculating forum statistics... successful.
Converting forum settings... successful.
Perhaps these errors are causing all my other problems? If so, how do I fix them?

Thanks

Edit: I looked up lines 553 & 554 in the converter, here they are:
list ($nextParent) = mysql_fetch_row($parents);
mysql_free_result($parents);

[Oldiesmann]

Hmmm... The problem is somwhere in that query that is used to figure out where sub-boards should go...

Run this query in phpMyAdmin and show me what you get:

Code Select Expand

SHOW COLUMNS FROM {prefix}forums

Just replace {prefix} with whatever prefix (ie, ipb_) is used for the tables.

[catfished]

Thanks for your reply but this is hopeless since I have no idea how to run a query or what a query is in this application of the word. I just recently figured out how to create and add users to databases but I have never even clicked on phpMyAdmin until now. I figured out how to get to my IPB database and then clicked on query and got a bunch of drop down boxes and stuff that I have no idea about:

Server: localhost   Database: catfish_forums 
  Structure   SQL   Export   Search   Query   
 
Sort:     Ascending Descending    Ascending Descending    Ascending Descending 
Show:         
Criteria:           
Ins:   And:   
Del:   Or:   
       
Modify:

I have no problem installing, SMF forums, moving them to a new server and upgrading them but converting from IPB v 1.2 to SMF 1.03 is becoming incredibly complicated.  I think I'm wayyy too stupid to ever figure it out.

[Oldiesmann]

Go into phpMyAdmin, and click on the "SQL" tab. Then, enter the code I gave you above into that box.

[catfished]

Well I finally figured out how to get the information you requested (or maybe it's not the right info?):
Field  Type  Null  Key  Default  Extra 
id smallint(5)   PRI 0   
topics mediumint(6) YES   NULL   
posts mediumint(6) YES   NULL   
last_post int(10) YES   NULL   
last_poster_id mediumint(     0   
last_poster_name varchar(32) YES   NULL   
name varchar(128)         
description text YES   NULL   
position tinyint(2) YES   NULL   
use_ibc tinyint(1) YES   NULL   
use_html tinyint(1) YES   NULL   
status varchar(10) YES   NULL   
start_perms varchar(255) YES   NULL   
reply_perms varchar(255) YES   NULL   
read_perms varchar(255) YES   NULL   
password varchar(32) YES   NULL   
category tinyint(2)   MUL 0   
last_title varchar(128) YES   NULL   
last_id int(10) YES   NULL   
sort_key varchar(32) YES   NULL   
sort_order varchar(32) YES   NULL   
prune tinyint(3) YES   NULL   
show_rules tinyint(1) YES   NULL   
upload_perms varchar(255) YES   NULL   
preview_posts tinyint(1) YES   NULL   
allow_poll tinyint(1)     1   
allow_pollbump tinyint(1)     0   
inc_postcount tinyint(1)     1   
skin_id int(10) YES   NULL   
parent_id mediumint(5) YES   -1   
subwrap tinyint(1) YES   0   
sub_can_post tinyint(1) YES   1   
quick_reply tinyint(1) YES   0   
redirect_url varchar(250) YES       
redirect_on tinyint(1)     0   
redirect_hits int(10)     0   
redirect_loc varchar(250) YES       
rules_title varchar(255)         
rules_text text         
has_mod_posts tinyint(1)     0   
topic_mm_id varchar(250) 

I have absolutely no idea what any of the above means, if it's not HTML it's gibberish to me. This is by far the most confusing project that I have ever done with a computer. At the rate I'm going I'll have the board converted just in time for SMF 9.9 final.  

[Oldiesmann]

That's the wrong table actually. You want the 'forums' table.

Again, as I said before...

After logging into phpMyAdmin and selecting the appropriate database, click on the SQL tab. Then, copy and paste the following code into that box and click the button:

Code Select Expand

SHOW COLUMNS FROM ipb_forums

Then, copy and paste the results here (enclose it in code tags so it won't parse smileys). If you want, you can PM me your cPanel info and I can look at it for you...

[catfished]

That's exactly what I did yesterday and it gave me that table. I did it again and it did the same thing, here's a screenshot, notice it says SQL-query: SHOW COLUMNS FROM ibf_forums :

Code Select Expand

 
Field Type Null Key Default Extra
id smallint(5)   PRI 0   
topics mediumint(6) YES   NULL   
posts mediumint(6) YES   NULL   
last_post int(10) YES   NULL   
last_poster_id mediumint(8)     0   
last_poster_name varchar(32) YES   NULL   
name varchar(128)         
description text YES   NULL   
position tinyint(2) YES   NULL   
use_ibc tinyint(1) YES   NULL   
use_html tinyint(1) YES   NULL   
status varchar(10) YES   NULL   
start_perms varchar(255) YES   NULL   
reply_perms varchar(255) YES   NULL   
read_perms varchar(255) YES   NULL   
password varchar(32) YES   NULL   
category tinyint(2)   MUL 0   
last_title varchar(128) YES   NULL   
last_id int(10) YES   NULL   
sort_key varchar(32) YES   NULL   
sort_order varchar(32) YES   NULL   
prune tinyint(3) YES   NULL   
show_rules tinyint(1) YES   NULL   
upload_perms varchar(255) YES   NULL   
preview_posts tinyint(1) YES   NULL   
allow_poll tinyint(1)     1   
allow_pollbump tinyint(1)     0   
inc_postcount tinyint(1)     1   
skin_id int(10) YES   NULL   
parent_id mediumint(5) YES   -1   
subwrap tinyint(1) YES   0   
sub_can_post tinyint(1) YES   1   
quick_reply tinyint(1) YES   0   
redirect_url varchar(250) YES       
redirect_on tinyint(1)     0   
redirect_hits int(10)     0   
redirect_loc varchar(250) YES       
rules_title varchar(255)         
rules_text text         
has_mod_posts tinyint(1)     0   
topic_mm_id varchar(250)        
If this is still wrong, I'll just give up and the heck with the $50 I just spent for Charter Member privleges.

[Oldiesmann]

Sorry about that. I guess I wasn't paying attention - for some reason I thought you posted the structure of the users table.

Anyway, I went through the converter and found a problem with that section. It's attempting to determine the ID of the parent board, which is fine. Only problem is, it's looking for an "ID_PARENT" column instead of a "parent_id" column. Please try the attached converter.

[[Unknown]]

Oldiesmann, I'm afraid that your change is actually detrimental.  I suggest you look in more depth at how the converters work, as the noted parts of the converter were not incorrect.

Catfished, I can understand your annoyance with the problems you're having.  If you want and are willing, please send me your FTP information and I would be more than willing to carry out the conversion for you.  However, from the error messages you've described I've found something that might be causing it.  Attached is a version of the converter which may work for you.

-[Unknown]

[Oldiesmann]

I'm sorry [Unknown]. I will make sure everything is correct next time...

[catfished]

Hi Unknown,

Thanks for your reply.

Well I deleted all the old databases and deleted the converted SMF 1.03  forum. Then I installed a fresh 1.03 version but it ended up being a completely screwed up converted forum. I did not use any convertor, just installed the fresh SMF 1.03 expecting to see an empty forum which I was going to try to convert using the convertor you (Unknown) provided but instead I'm seeing this: http://www.catfished.com/forums

I assume that there is still stuff in the database from my many previous attempts to convert this IPB forum so I am really at the end of my rope . I guess I could have prevented this by creating a new database for the SMF forum but I thought it was better to have both forums in the same database? This just keeps getting worse and worse, I really do not see me ever getting this done correctly, it's just way too confusing. I know I can have you do it but the whole idea for me was to be able to say I did it myself.

[[Unknown]]

The converter will clear out old things in the database, anyway, if you run it again.  And, you can use phpMyAdmin to select all the tables (there's a "select all" link or button) and then "DROP" them.

Looking at the forum, though... it looks okay.  Can you tell me what errors exactly you're still facing, aside from the ones posted in this topic during the conversion process?

-[Unknown]

[catfished]

Thanks Unknown, I ran the convertor and it ran perfectly, there were no errors but I found several errors in just a few minutes on the forum. I don't have time to do anything with it right now, maybe tonight but I'm about ready to give up. I imagine I could eventually straighten everything out but I don't wish to put in that kind of time. Some of the errors I found already: red X for everyone without an avatar (http://catfished.com/forums/avatars/noavatar), some attachments gone or distorted and permissions changed for some users. Obviously the ones listed are fixable but if there are as many as I suspect, it would take a lot of time.

[catfished]

Update: I finally got it converted and with no apparent errors, just the normal little irritants. Thank you everyone for all your help, especially Unknown, and for tolerating my rants.

[Oldiesmann]

Glad to hear you finally got it converted without any problems. Enjoy SMF