phpBB2 - SMF... again

[MicKPM]

SMF Version: SMF 1.0.7
Hi all... I've just jumped from the phpBB2 ship after finding SMF and after seeing it's standard features I decided that I just had to use it on my updated version of my site. The only problem is that I have an existing online community with close on 6000 users which I'd sooner not ask to re-register for fear of a lynching. I've tried to use the converters but I have to admit to being a complete newbie when it comes to php/MySQL and so on but I'm trying to learn. When I run the converter I get the following message:

Code Select Expand

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.

The error MySQL gave was: select command denied to user: 'rscsmf@localhost' for table 'phpbb_users'

Now I know that both DB's exist as they're both being used... please point out the error here before I'm forced to stick a pencil in to my eye

Mick

[xenovanis]

Are they both using the same database?

[MicKPM]

Hello and no they are both running on individual DB's.

I'm also having a similar issue with my CMS/Forum intergration which is giving a similar error. I'm guessing that it's now a permission issue with the DB's themselves but I don't have a clue how to login in to MySQL/AdminPhP as "ROOT@localhost" and use the 'GRANT ALL' on the DB's. When I login through my control panel and try it under the "USERNAME@localhost" I apparently don't have permission to do it! Any suggestions would be greatly appreciated although understand that this is looking like a MySQL issue and so not your problem

Mick

[xenovanis]

The most easy way would be using the same database and different prefixes. Since your SMF forum is relativy new, I'd reinstall it and point it at your pbpBB database. Ofcourse, you could always transfer a dump from your SMF database to the phpBB database.

[MicKPM]

Thanks but be warned... I'm now going to ask a REALLY stupid question

If I use the same DB but add new prefixes how will SMF know to use my current user, passwords, sections/topics and thread content? I guess i could tell SMF to use a "phpBB" prefix but would this not erase the contents of the current tables?

Mick

[xenovanis]

You definately don't want to use the same prefixes, that will screw up your phpBB install. If your phpBB tables have the prefix phpBB; you can use the prefix smf_ for your SMF install.

The converter knows where to find the phpBB install, because it looks at your phpBB configuration files, where all settings are saved.

[MicKPM]

Thanks for the prompt reply however a little session on Google and a good old "RTM" session has found a solution. Login to MySQL via SSH and grant permissions to my SMF user to my phpBB2 DB. Converter is working away as we speak!

Quite simple really when you know how - Doh. I just used the command:
"grant all on (database_name).* to (user)@(hostname) identified by '(password)';"

Many thanks

Mick

[Tom Lewandowski]

I've been experimenting with SMF, having been using phpBB for the past few years.  I've installed the latest version of SMF and ran the "phpBB2_to_SMF.php" converter, but am having some problems with both Internet Explorer, and Firefox, while trying to perform the conversion.  I've been able to convert "some" of my phpBB database, but only about 30 of the 1400 members show up on the member list (even though, phpBB members seem to be able to log into the SMF board using their phpBB user ID's and passwords.)  And, only a portion of the posts converted -- up to about six months ago.  I believe the problem with the partial conversion is because of Firefox and I.E., and how they handle the converter:

When I use IE to run the php converter script, after entering in the location/password information, I recieve a "Page Not Found" error from IE.  "Some" of the conversion takes place, however -- but only a small bit of data is converted.  When I use Firefox, after a few seconds, a popup asks me to choose what app I want to use to run the php script, along with an option to save the script to my hard drive.  However, at least half of the phpBB database data is converted to the SMF database before that popup appears.  I don't know why this is happening in either browser. 

Can anyone offer some possible solutions that will allow me to run the converter script throught to its completion?

Thanks!

Tom Lewandowski
QUEST STUDIOS

[青山 素子]

Tom, that sounds like a problem with the server. A popup like that means the server's little mind broke and it isn't doing what it is supposed to. And with a 404 in IE (turn of friendly errors, they hurt troubleshooting!), something really is up there...