Database Password Problem

[Lysanda]

Hi there,

I'm trying (yes, 'trying') to convert my board from phpBB to SMF.. and while all seems to be going well.. when I run the phpbb2_to_smf.php and land in the screen where it prompts for the two board paths, and then the SMF Database password, I enter my password.. and it keeps saying that it's incorrect.

Any ideas why?

[[Unknown]]

Make sure you're giving it the password to the account you installed SMF with.  You may wish to verify your settings in the Server Settings portion of the admin area, or in Settings.php.

-[Unknown]

[Lysanda]

Thanks for that Unknown.. I picked the password out of settings.php.. which was great.

Now I get this result...

I've antichristed it somewhere... erm.. help?! 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 215

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 303
Converting members...
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 458

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 459

Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 476

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 477

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 491

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 524
successful.
Converting additional member groups...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 621

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 655
successful.
Converting categories...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 721

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 731
successful.
Converting boards...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 827

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 843
successful.
Converting topics...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 927

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1038
successful.
Converting polls...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1114

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

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

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

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

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1527
successful.
Converting board access...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1587

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1755
successful.
Converting group access permissions...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1802

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1887
successful.
Copying avatar image files...
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1918

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1919

Warning: copy(/home/wytch/public_html/board1/avatars/index.php): failed to open stream: Permission denied in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2961
successful.
Converting censored words...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1968

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 1973
successful.
Converting reserved names...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2016

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2018
successful.
Converting ban list...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2057

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2097
successful.
Converting misc settings...
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2125

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2211

Notice: Undefined variable: phpbb_forum_name in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2214

Notice: Undefined variable: phpbb_admin_email in /home/wytch/public_html/board/phpbb2_to_smf.php on line 2215

Warning: fopen(/home/wytch/public_html/board1/Settings.php): failed to open stream: Permission denied in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3012

Warning: fclose(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3013

Warning: fopen(/home/wytch/public_html/board1/Settings.php): failed to open stream: Permission denied in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3016

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3019

Warning: fwrite(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3022

Warning: fclose(): supplied argument is not a valid stream resource in /home/wytch/public_html/board/phpbb2_to_smf.php on line 3023
successful.
Recalculating forum statistics... successful.

[[Unknown]]

The new revision of the converter (which will be released when 1.0 is) would give you this error message:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2.  This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

In any event, as explained on the converter, the user for the SMF database *must* have access to read from the phpBB database.  Many have found it easiest to simply put SMF in the same database as the phpBB install (which causes no problems) but, depending on your control panel, it may be easy to simply allow one user access to both databases.

-[Unknown]

[Lysanda]

Thankyou again.

I'll try putting SMF into ikonnz database and see how that pans out. 

[Lysanda]

Ok, I think I've gone over and over this so many times now that I'm not seeing things straight.

Is there anywhere I can get step by step info about installing the SMF directly into the old phpBB database? 
I think I've got to a point where I'm getting progessively dumber the more I work on this.

[Oldiesmann]

When you get to the page asking you for your MySQL info, use the same database info that you're using for phpBB (same database name, username and password). As long as the table prefix is something other than phpBB_ (or whatever phpBB uses now), you shouldn't run into any problems. In fact, I recommend just leaving it at smf_ unless you have a good reason for not using that one.

[Lysanda]

This is when installing from a download here.. rather than from Fantastico in cPanel?

[Oldiesmann]

Yes. I've never installed it via Fantastico, so I can't give you instructions from there.

[Lysanda]

It worked!!

I'd never installed it thru ftp before, only Fantastico.. but I did what you advised and it worked.

Thankyou so much for your help

[Oldiesmann]

No problem. SMF has only been available through Fantastico for a few days, so I'm glad to know it's being used that way

[Lysanda]

Ahh ok.. now I know why I've never noticed it there before.

It seems great, I've worked with phpBB, Invision & Ikonboard.. and so far SMF is superior.

[Oldiesmann]

Glad you're enjoying SMF.