Problems with Forum after move

[Henrietta]

I spent yesterday reading in the forums how to change my php.config file to allow login to my site's phpbb2 forum, using File Manager & editor. Which brings me to the usual questions:

 

1. Can I have only one user on both my databases?

 

2. I uploaded the forum to the public_html folder, is this the right place for it to be?

 

3. this is the error message I get when I try to access the forum:

 

phpBB : Critical Error

 

Could not query config information

 

DEBUG MODE

 

SQL Error : 1146 Table 'myusername_mydatabase.phpbb_config' doesn't exist

 

SELECT * FROM phpbb_config

 

Line : 215

File : common.php

 

Obviously I have foofoo-ed (AGAIN) bigtime, WOTASURPRISE!!!!

 

This is what was originally in my php.config file:

 

<?php

 

 

// phpBB 2.x auto-generated config file

// Do not change anything in this file!

 

$dbms = 'mysql4';

 

$dbhost = 'mysql273.secureserver.net';

$dbname = 'MYDATABASENAME';

$dbuser = 'MYDATABASEUSER';

$dbpasswd = 'MYPASSWORD';

 

$table_prefix = 'phpbb_';

 

define('PHPBB_INSTALLED', true);

 

?>

 

and this is what I changed it to:

 

<?php

 

 

// phpBB 2.x auto-generated config file

// Do not change anything in this file!

 

$dbms = 'mysql';

 

$dbhost = 'localhost';

$dbname = 'MYUSERNAME_THECORRECTDATABASENAME';

$dbuser = 'MYUSERNAME_MYDBUSERNAME';

$dbpasswd = 'MYDBPASSWORD';

 

$table_prefix = 'phpbb_';

 

define('PHPBB_INSTALLED', true);

 

?>

 

 

WOT went wrong?

[TCH-Thomas]

I am assuming you have created the database in cpanel. Otherwise, please see this movie tutorial.

This part looks wrong:

 

$dbhost = 'mysql273.secureserver.net';

$dbname = 'MYDATABASENAME';

$dbuser = 'MYDATABASEUSER';

$dbpasswd = 'MYPASSWORD';

 

It should be:

 

$dbhost = 'localhost';

$dbname = 'cpanelusername_databasename';

$dbuser = 'cpanelusername_databaseusername';

$dbpasswd = 'your chosen password';

[TCH-Don]

You can add more users in PhpMsql

and then add them to a database.

 

Remember to add at least one user to your database in MySql

[Henrietta]

Thank you for moving this to the right place. I am sorry, I was not clear on my original post, let me try to clarify -

This is what was originally in my php_config file which I imported from GoDaddy which is why it looks odd:

 

<?php

// phpBB 2.x auto-generated config file

// Do not change anything in this file!

 

$dbms = 'mysql4';

 

$dbhost = 'mysql273.secureserver.net';

 

$dbname = 'MYDATABASENAME';

$dbuser = 'MYDATABASEUSER';

$dbpasswd = 'MYPASSWORD';

 

$table_prefix = 'phpbb_';

 

define('PHPBB_INSTALLED', true);

 

?>

 

I changed it here (on TCH) to:

 

<?php

// phpBB 2.x auto-generated config file

// Do not change anything in this file!

 

$dbms = 'mysql';

 

$dbhost = 'localhost';

$dbname = 'cpanelusername_databasename';

$dbuser = 'cpanelusername_databaseusername';

$dbpasswd = 'my chosen password';

 

$dbhost = 'localhost';

 

 

 

 

$table_prefix = 'phpbb_';

 

define('PHPBB_INSTALLED', true);

 

?>

 

This is the error message I get when I try to access the forum on my site, now hosted on TCH:

 

phpBB : Critical Error

 

Could not query config information

 

DEBUG MODE

 

SQL Error : 1146 Table 'cpanelusername_databasename.phpbb_config' doesn't exist

 

SELECT * FROM phpbb_config

 

Line : 215

File : common.php

 

I uploaded the forum to the public_html folder, is this the right place for it to be?

 

$dbms = 'mysql'; is this line correct? On GoDaddy it read "$dbms = 'mysql4';"

[Henrietta]

Good movie, thank you Thomas.

I cut and pasted the script as shown.

I now have a new error message:

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'cpanelusername@'localhost' (using password: YES) in /home3/cpanelusername/public_html/forum/config.php on line 7

I cannot connect to the database because: Access denied for user 'cpanelusername_databasename'@'localhost' (using password: YES)

[TCH-Andy]

Can I check that you have changed "cpanelusername" to the correct cpanel username for your account ? And that databasename is the name of your database etc. ?

 

 

In the error above I would usually expect "Access denied for user 'cpanelusername_databaseUSERname'@'localhost' (using password: YES)" so it looks as if you have the databasename not the database username for the user.

[Henrietta]

Andy,

 

All of my issues with this were due to a Major DUH! Factor.

 

I had not installed phpBB2 on this host.

 

I feel so stupid, but at the same time rather pleased that I figured it out.

Even if it did take me two days.

 

I am not sure that this is the correct forum to continue this saga, if not please feel free to move me again.

[TCH-Andy]

we've all had those moments - I know I certainly have

 

I'm glad you sorted it all out though

[Henrietta]

I hope I am allowed to post this here.

 

I found this yesterday on the phpBB2 forum before they went down"

 

get Big Dump

Dont try to go to your board until you have finished all the steps, you will

get errors.

 

At old board, go to admin panel;

1.set style back to subSilver

2.change domain name and script path to what the new one will be

 

3.backup database , making sure that you have the DROP TABLE command

 

How to phpmyadmin

 

4. If you want to keep all your old phpbb files instead of using the new ones,

then copy your phpbb folder from the server to your computer.

( this is usually only necessary if you have lots of MODs installed and

don't want to install them again. )

 

 

 

At new board;

1. create new database

 

2.upload all phpbb files

 

3.install phpbb

 

4.create folder named "dump"

 

5. open bigdump.php, edit to include database info for new database

 

6. upload bigdump.php and old database backup to the "dump" folder

 

7. in your browser, go to : ******/yourphpbb/dump/bigdump.php

 

8. click the start restore link, when it is done;

 

9. in your browser, go to: ******/phpbb/install/update_to_latest.php

 

10.get this:

Auto Cookies MOD

then, unzip it to your computer,

 

then upload the install folder ,

 

then , in your browser, go to:

******/yourphpbbb/install/cookie.php

 

then click the button to accept the settings it finds.

 

 

11. delete the install and contrib folders.