Simple Machines Community Forum

I want to convert phpbb forum in smf,but I have problem because convert.php tell me this:

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 'name_of_database'@'localhost' for table 'phpbb_users'

How can I fix that?

you need to give the mysql user for the SMF database access to the phpbb database.  in cpanel, this is the 'add user to database' option

I would really like to use simplemachines. I have installed it with some difficulty as I know not what I do  :-[

Now I am trying to convert my phpBB2 using the converter script. I get the following error message

LainaaSorry, 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 'wpsveterans'@'linweb12.atlas.pipex.net' for table 'phpbb_users'

I have searched all over and read for hours, but I just find this to be difficult as my
mind doesn't work the way it needs to for some of the complications of sql, phpadmin
etc.

I believe what follows is probably what I need to do...but don't know how to accomplish
that with PHPadmin which my server runs. I also don't know exactly what this means
"mysql user for the SMF database " because I have phpbb2 and smf both installed to the
same dbase I think. Trouble is...on my server I have two databases one called wpsveterans
and the other called wpsveterans2 and both seem to have phpbb2 in them. In wpsveterans
I can see the two different prefixes of phpbb2 and smf.

Lainaus käyttäjältä: BlackMage - syyskuu 29, 2007, 07:31:06 AP
you need to give the mysql user for the SMF database access to the phpbb database.  in cpanel, this is the 'add user to database' option

Any and all help would be appreciated in getting phpbb2 converted.

thank you

Maybe you don't actually have them installed on the same database. A look in the phpBB admin area should show where it is installed.

I think you are likely correct. In the phpbb2 admin section it is very
sparse so doesn't tell me. I looked in the config.php and....

// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql';

$dbhost = 'db-f2s';
$dbname = 'wpsveterans2';
$dbuser = 'wpsveterans2';
$dbpasswd = 'xxxxxxxx';

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>

As I say there are phpbb tables in both wpsveterans and wpsveterans2...perhaps
because I screwed up before.

So...if that's the case do I need to install SMP in wpsveterans2 db or is there a
way to leave it like it is and still convert?

thanks for the reply

Lainaa
$dbname = 'wpsveterans2';

That would be the phpBB database. You can have SMF in a different database, but the SMF user needs SELECT permission on the phpBB database. I believe cPanel lets you set this up, but if you are unsure how to do this or you don't see the option in whatever interface you have, ask your host.

Thank you  :)

A lot easier than getting a reply from the host
was to install smf into the other database

then ran the conversion script without a hitch
and couldn't believe how fast it was.

thanks again