Converting PHPBB3 to SMF

#1 10-09-2009

G'day guys.

I've installed PHPBB3 and have been running with it for a couple of weeks now, but I've come to the abrupt realisation that it's rather crap and have been looking for something else.

I've come across SMF and it looks pretty awesome, so I've installed it and have been trying to convert my old PHPBB3 database into SMF using SMF's conversion tools. Unfortunately, I'm stuck.

The conversion tools ask for the following information which I've tried to enter:

Code:

Path to SMF: /hosted/subs/ulmb.com/o/g/ogc/public_html/smf
Path to phpBB3: /hosted/subs/ulmb.com/o/g/ogc/public_html/phpBB3
SMF database password: ***********
Set SMF's default character set to: ISO-8859-1
Empty the convert error log? *unchecked*

It sprouts the following error:

Code:

Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB3. 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 '16169_smf'@'208.167.230.137' for table 'phpbb_users'

A quick read of the SMF forums gives me this tidbit of info:

Code:

Problem: SELECT command denied to user
Info: The cause of this error is that SMF and Software X are in separate databases and the SMF database user does not have access to Software X's database.
Fix: If your host has cPanel you can add the SMF database user to Software X's database.  If your host does not have cPanel you can contact them with regards on how to accomplish this. As well as a last resort, what you can do is reinstall SMF in the same database as Software X.

I don't want to reinstall SMF in the same database as PHPBB3. So, I'm hoping someone will be able to tell me how to add SMF's database user to PHPBB3's database?

Cheers!

#2 10-09-2009

Unfortunately your only choice will be to install SMF into phpbb3's database.

There is no technical reason why SMF can't login to the phpbb database, they just chose to do it the awkward way.

#3 10-09-2009

Thanks. This really doesn't surprise me. Typical of open-source developers