Topic: php33 getting error while using converter

[hailstorm]

Hello can someone please help me

I'm trying to convert using phpbb32 converter to convert phpbb33 to SMF 2.0.17

but i get this error

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 Database account used does not have permissions to access it.
The error that was received from the Database was: 1142

i've double checked and it's and it's got permission

any help on how to get around this or is there a php33 convert out?

kind regards,
hailstorm

[vbgamer45]

You don't have the right mysql permissions setup https://www.google.com/search?client=firefox-b-1-d&q=1142+database+error
 I have not tested phpbb3.3 on the convertor.

[hailstorm]

Hello vbgamer45

Here is my permissions on my cpanel, i can't see what else would be wrong

[Illori]

This is a topic for common errors that you might experience while converting to SMF.

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

you are looking at the permissions within the database, not the access that database user has between different databases.

[hailstorm]

This is a topic for common errors that you might experience while converting to SMF.

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

you are looking at the permissions within the database, not the access that database user has between different databases.

Trying the last one you said, to reinstall and use same database however i changed hosting providers and my usernames are different on both hosting providers

So how do i go about making a new MSQ username for that ?

kind regards,
hailstorm

[Dzonny]

User you're using blameshift_smf718 should have all privileges to both SMF and phpbb databases. So you should seek for "add user to database" or something like that in your cPanel - mysql databases.
Something like this:

Code: [Select]

https://www.liquidweb.com/kb/how-to-assign-a-user-to-a-mysql-database-in-cpanel/
Тhen manage that user to have all privileges to both databases, and you should be good to go.

[hailstorm]

User you're using blameshift_smf718 should have all privileges to both SMF and phpbb databases. So you should seek for "add user to database" or something like that in your cPanel - mysql databases.
Something like this:

Code: [Select]

https://www.liquidweb.com/kb/how-to-assign-a-user-to-a-mysql-database-in-cpanel/
Тhen manage that user to have all privileges to both databases, and you should be good to go.

I've tried that after re-installing again recently, it and nope still stuck with this

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 Database account used does not have permissions to access it.
The error that was received from the Database was: 1142

this is really annoying,.might have to cut my losses and just start from scratch cause this isn't working

[Dzonny]

You're 100% sure that your user have access and privileges to smf and phpbb databases?
If you feel comfortable, you can send me cpanel access so I can take a look for ya.

[hailstorm]

Thank you for the offer, we've just gone ahead and start doing it from scratch but thank you anyway