Solve : Convert PHPBB3 to SMF?

1.	Solve : Convert PHPBB3 to SMF?
Answer» I am having troubles converting PHPBB3 to SMF. Here are the steps I took and what went wrong. 1) Installed PHPBB3. 2) Members registered, post were made, and so fourth. 3) Installed SMF. 4) Now have SMF and PHPBB3 on the same server. 5) I have a mysql database for SMF and another for PHPBB3. 6) Placed SMF's converstion tool in the root of the SMF folder. 7) Converstion tool is giving an error. Here is basically what the error message says. ------------------------ 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: SELECT command denied to user 'a3456r_smf''11.2.2.11' for table 'phpbb_users' ------------------------ I am almost 100% sure that the error is "that the Database account used does not have permissions to access it." I am just unsure how to fix this issue as I don't know MUCH about PHPMyAdmin.give the a3456r_smf user permissions to the PHPBB database? In phpmyadmin, open the "privileges" tag, look for the user "a3456r_smf" and click the "Edit Privileges" item, then scroll down and tweak the Database specific privileges items until you're satisfied that the user is no longer RESTRICTED from the phpbb database. Quote from: BC_Programmer on December 23, 2011, 07:11:03 PM open the "privileges" tag Where would I find this? I am confused. Also which database am I LOOKING under? Quote from: thumbtak on December 23, 2011, 07:32:07 PM Where would I find this? In phpmyadmin. Quote Also which database am I looking under? None. When I go to phpmyadmin I see only a way to enter one of the databases and edit that database. How do I get to the screen you show above?your webhost might be configured to not show you all of it, or you might only be allowed to use a SUBSET of the functionality of phpMyAdmin. If you can list the databases, though, they should have a "Edit privileges" icon next to them in the list, which should take you to a similar screen.This is what I basically see in the host.

Answer»

I am having troubles converting PHPBB3 to SMF.

Here are the steps I took and what went wrong.

1) Installed PHPBB3.
2) Members registered, post were made, and so fourth.
3) Installed SMF.
4) Now have SMF and PHPBB3 on the same server.
5) I have a mysql database for SMF and another for PHPBB3.
6) Placed SMF's converstion tool in the root of the SMF folder.
7) Converstion tool is giving an error.

Here is basically what the error message says.

------------------------
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:
SELECT command denied to user
'a3456r_smf''11.2.2.11' for table 'phpbb_users'
------------------------

I am almost 100% sure that the error is "that the Database account
used does not have permissions to access it." I am just unsure how to fix this issue as I don't know MUCH about PHPMyAdmin.give the a3456r_smf user permissions to the PHPBB database?

In phpmyadmin, open the "privileges" tag, look for the user "a3456r_smf" and click the "Edit Privileges" item, then scroll down and tweak the Database specific privileges items until you're satisfied that the user is no longer RESTRICTED from the phpbb database. Quote from: BC_Programmer on December 23, 2011, 07:11:03 PM

open the "privileges" tag

Where would I find this? I am confused. Also which database am I LOOKING under? Quote from: thumbtak on December 23, 2011, 07:32:07 PM

Where would I find this?

In phpmyadmin.

Quote

Also which database am I looking under?

None.

When I go to phpmyadmin I see only a way to enter one of the databases and edit that database. How do I get to the screen you show above?your webhost might be configured to not show you all of it, or you might only be allowed to use a SUBSET of the functionality of phpMyAdmin. If you can list the databases, though, they should have a "Edit privileges" icon next to them in the list, which should take you to a similar screen.This is what I basically see in the host.

Solve : Convert PHPBB3 to SMF?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment