PHPBB to SMF Problems

[mr.bobo]

I'm getting the following error when trying to convert.


phpBB2 to SMF Converter
Converting...
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 286

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 296
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 401

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 411
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 492

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 502
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 586

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 596
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 684

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 694
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 770

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 780
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 850

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 860
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 929

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 939
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1014

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1024
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1093

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1103
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1173

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/phpbb2_to_smf.php on line 1183
successful.
Recalculating forum statistics... successful.
Conversion Complete



Any ideas?

[Oldiesmann]

Make sure you've still got all your phpBB tables and have entered the correct path for both phpBB and SMF. You also need to make sure you install SMF before you try to convert.

[mr.bobo]

the forums are setup http://newforums.dumpsterworld.com [nofollow] is SMF, and http://www.dumpsterworld.com [nofollow] is PHPBB.  The PHPBB is still working so I assume that all my tables work.  I'm 99.9% sure the paths are correct /home/dumpster/public_html/newforums and /home/dumpster/public_html/ for SMF, PHPbb respectively.  Got any ideas?

Thanks in advance.

-Bob

[Oldiesmann]

Are you sure you entered the correct database prefix for phpBB? Also, are SMF and phpBB running on the same database?

[mr.bobo]

[Oldiesmann]

Ok. That's what's causing the problem. The convertor assumes that the two boards are running on the same database. Upload install.php and re-install SMF on the dumpster_forums database. Then run the convertor again and it should work fine.

[[Unknown]]

No, it doesn't.  But, it does assume that the users for each have access to each...

-[Unknown]

[mr.bobo]

Sorry for being a pain but I did what Oldies said, and reinstalled using the same DB as phpbb, but now I get this :

phpBB2 to SMF Converter
Converting...
Converting members...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 286

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 296
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 401

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 411
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 492

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 502
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 586

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 596
successful.
Converting messages... (this may take some time)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 684

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 694
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 770

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 780
successful.
Converting poll options...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 850

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 860
successful.
Converting previous poll votes...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 929

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 939
successful.
Converting personal messages...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1014

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1024
successful.
Converting personal messages (step 2)...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1093

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1103
successful.
Converting topic notifications...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1173

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/dumpster/public_html/newforums/phpbb2_to_smf.php on line 1183
successful.
Recalculating forum statistics... successful.

Conversion Complete
Congratulations, the conversion has completed sucessfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the phpBB2 installation.

We hope you had a smooth transition,

Simple Machines

[Oldiesmann]

I have no idea what to tell you. For some reason it can't seem to find the tables you need or something...

[[Unknown]]

This is probably caused by strange characters in your database name.  Please try changing, temporarily, your database name to:

`whatever it is`

Note the backticks - it's the key next to 1 on your keyboard. (it must be that type of quote!)  After conversion, please try changing the database name back.

It will have to be changed in both phpBB and SMF.  Again, this has been solved in the working copy and will not be neccessary for the next release.

-[Unknown]

[mr.bobo]

Sorry for asking such a dumb questions, but how do I change the DB name?  Thanks so much for all your help so far it's been much appreciated and I'm looking forward to using SMF.

[Oldiesmann]

Edit config.php (for phpBB) and Settings.php (for SMF).

[mr.bobo]

Ok, but how do I change the actual name of the DB so all the settings are transfered over to the new one?

Thanks,

Bob

[[Unknown]]

Don't worry; SMF supports database names with strange characters in them - the problem is only the converter.  If you just add `s to both sides of the name in them, it will work properly and then you can change it back without any problems.

-[Unknown]

[mr.bobo]

ahh, sorry I misunderstood you ok, I'll give that a try and post back here with the results.

[mr.bobo]

Don't worry; SMF supports database names with strange characters in them - the problem is only the converter.  If you just add `s to both sides of the name in them, it will work properly and then you can change it back without any problems.

-[Unknown]

Where exactly do I enter the ` s?

Sorry,

Bob

[Eris Siva]

I got this same issue when trying to convert. Now that you've explained it-I understand.

Is it possible to just have it (the script) to install to a specified database so that this problem doesn't occur?

[mr.bobo]

adonis think you could explain it to me?  I'm still not understanding exactly what must be done.

[Eris Siva]

As far as I can tell, you would put the backticks in the config files and also in your SQL database (prob. using phpMyAdmin), but around your database name.

For example:

smartmachines_database

becomes

`smartmachines_database`



Is that it?

[mr.bobo]

maybe I should just wait for the next release, I can't seem to figure out how to change the DB name... when will the next release be out?