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:<br /><br />1. Can I have only one user on both my databases?<br /><br />2. I uploaded the forum to the public_html folder, is this the right place for it to be?<br /><br />3. this is the error message I get when I try to access the forum:<br /><br /><b>phpBB : Critical Error<br /><br />Could not query config information<br /><br />DEBUG MODE<br /><br />SQL Error : 1146 Table 'myusername_mydatabase.phpbb_config' doesn't exist<br /><br />SELECT * FROM phpbb_config<br /><br />Line : 215<br />File : common.php</b><br /><br />Obviously I have foofoo-ed (AGAIN) bigtime, WOTASURPRISE!!!!<br /><br />This is what was originally in my php.config file:<br /><br /><?php<br /><br /><br />// phpBB 2.x auto-generated config file<br />// Do not change anything in this file!<br /><br />$dbms = 'mysql4';<br /><br />$dbhost = 'mysql273.secureserver.net';<br />$dbname = 'MYDATABASENAME';<br />$dbuser = 'MYDATABASEUSER';<br />$dbpasswd = 'MYPASSWORD';<br /><br />$table_prefix = 'phpbb_';<br /><br />define('PHPBB_INSTALLED', true);<br /><br />?><br /><br />and this is what I changed it to:<br /><br /><?php<br /><br /><br />// phpBB 2.x auto-generated config file<br />// Do not change anything in this file!<br /><br />$dbms = 'mysql';<br /><br />$dbhost = 'localhost';<br />$dbname = 'MYUSERNAME_THECORRECTDATABASENAME';<br />$dbuser = 'MYUSERNAME_MYDBUSERNAME';<br />$dbpasswd = 'MYDBPASSWORD';<br /><br />$table_prefix = 'phpbb_';<br /><br />define('PHPBB_INSTALLED', true);<br /><br />?><br /><br /><br />WOT went wrong?<!--content-->
I am assuming you have created the database in cpanel. Otherwise, please see <a href="http://totalchoicehosting.com/help/tutorials/cpanel/createmysql.html" target="_blank">this movie tutorial</a>.<br />This part looks wrong:<br /><br />$dbhost = 'mysql273.secureserver.net';<br />$dbname = 'MYDATABASENAME';<br />$dbuser = 'MYDATABASEUSER';<br />$dbpasswd = 'MYPASSWORD';<br /><br />It should be:<br /><br />$dbhost = 'localhost';<br />$dbname = 'cpanelusername_databasename';<br />$dbuser = 'cpanelusername_databaseusername';<br />$dbpasswd = 'your chosen password';<!--content-->
You can add more users in PhpMsql<br />and then add them to a database.<br /><br />Remember to add at least one user to your database in MySql<!--content-->
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 -<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->This is what was originally in my php_config file <b>which I imported from GoDaddy</b> which is why it looks odd:<br /><br /><?php<br />// phpBB 2.x auto-generated config file<br />// Do not change anything in this file!<br /><br />$dbms = 'mysql4';<br /><br />$dbhost = 'mysql273.secureserver.net';<br /><br />$dbname = 'MYDATABASENAME';<br />$dbuser = 'MYDATABASEUSER';<br />$dbpasswd = 'MYPASSWORD';<br /><br />$table_prefix = 'phpbb_';<br /><br />define('PHPBB_INSTALLED', true);<br /><br />?><br /><br />I changed it here (on TCH) to:<br /><br /><?php<br />// phpBB 2.x auto-generated config file<br />// Do not change anything in this file!<br /><br />$dbms = 'mysql';<br /><br />$dbhost = 'localhost';<br />$dbname = 'cpanelusername_databasename';<br />$dbuser = 'cpanelusername_databaseusername';<br />$dbpasswd = 'my chosen password';<br /><br />$dbhost = 'localhost';<br /><br /><br /><br /><br />$table_prefix = 'phpbb_';<br /><br />define('PHPBB_INSTALLED', true);<br /><br />?><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />This is the error message I get when I try to access the forum on my site, now hosted on TCH:<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->phpBB : Critical Error<br /><br />Could not query config information<br /><br />DEBUG MODE<br /><br />SQL Error : 1146 Table 'cpanelusername_databasename.phpbb_config' doesn't exist<br /><br />SELECT * FROM phpbb_config<br /><br />Line : 215<br />File : common.php<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br /> I uploaded the forum to the public_html folder, is this the right place for it to be?<br /><br />$dbms = 'mysql'; is this line correct? On GoDaddy it read "$dbms = 'mysql4';"<!--content-->
Good movie, thank you Thomas.<br />I cut and pasted the script as shown.<br />I now have a new error message:<br /><br /><b>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<br />I cannot connect to the database because: Access denied for user 'cpanelusername_databasename'@'localhost' (using password: YES)</b><!--content-->
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. ?<br /><br /><br />In the error above I would usually expect "Access denied for user 'cpanelusername_database<b>USER</b>name'@'localhost' (using password: YES)" so it looks as if you have the databasename not the database username for the user.<!--content-->
Andy,<br /><br />All of my issues with this were due to a Major DUH! Factor.<br /><br />I had not <u>installed</u> phpBB2 on this host.<br /><br />I feel so stupid, but at the same time rather pleased that I figured it out.<br />Even if it did take me two days.<br /><br />I am not sure that this is the correct forum to continue this saga, if not please feel free to move me again.<!--content-->
we've all had those moments - I know I certainly have <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /> <br /><br />I'm glad you sorted it all out though <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><!--content-->
I hope I am allowed to post this here.<br /><br />I found this yesterday on the phpBB2 forum before they went down"<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->get Big Dump<br />Dont try to go to your board until you have finished all the steps, you will<br />get errors.<br /><br />At old board, go to admin panel;<br />1.set style back to subSilver<br />2.change domain name and script path to what the new one will be<br /><br />3.backup database , making sure that you have the DROP TABLE command<br /><br />How to phpmyadmin<br /><br />4. If you want to keep all your old phpbb files instead of using the new ones,<br />then copy your phpbb folder from the server to your computer.<br />( this is usually only necessary if you have lots of MODs installed and<br />don't want to install them again. )<br /><br /><br /><br />At new board;<br />1. create new database<br /><br />2.upload all phpbb files<br /><br />3.install phpbb<br /><br />4.create folder named "dump"<br /><br />5. open bigdump.php, edit to include database info for new database<br /><br />6. upload bigdump.php and old database backup to the "dump" folder<br /><br />7. in your browser, go to : ******/yourphpbb/dump/bigdump.php<br /><br />8. click the start restore link, when it is done;<br /><br />9. in your browser, go to: ******/phpbb/install/update_to_latest.php<br /><br />10.get this:<br />Auto Cookies MOD<br />then, unzip it to your computer,<br /><br />then upload the install folder ,<br /><br />then , in your browser, go to:<br />******/yourphpbbb/install/cookie.php<br /><br />then click the button to accept the settings it finds.<br /><br /><br />11. delete the install and contrib folders.<!--QuoteEnd--></div><!--QuoteEEnd--><!--content-->
I am assuming you have created the database in cpanel. Otherwise, please see <a href="http://totalchoicehosting.com/help/tutorials/cpanel/createmysql.html" target="_blank">this movie tutorial</a>.<br />This part looks wrong:<br /><br />$dbhost = 'mysql273.secureserver.net';<br />$dbname = 'MYDATABASENAME';<br />$dbuser = 'MYDATABASEUSER';<br />$dbpasswd = 'MYPASSWORD';<br /><br />It should be:<br /><br />$dbhost = 'localhost';<br />$dbname = 'cpanelusername_databasename';<br />$dbuser = 'cpanelusername_databaseusername';<br />$dbpasswd = 'your chosen password';<!--content-->
You can add more users in PhpMsql<br />and then add them to a database.<br /><br />Remember to add at least one user to your database in MySql<!--content-->
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 -<br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->This is what was originally in my php_config file <b>which I imported from GoDaddy</b> which is why it looks odd:<br /><br /><?php<br />// phpBB 2.x auto-generated config file<br />// Do not change anything in this file!<br /><br />$dbms = 'mysql4';<br /><br />$dbhost = 'mysql273.secureserver.net';<br /><br />$dbname = 'MYDATABASENAME';<br />$dbuser = 'MYDATABASEUSER';<br />$dbpasswd = 'MYPASSWORD';<br /><br />$table_prefix = 'phpbb_';<br /><br />define('PHPBB_INSTALLED', true);<br /><br />?><br /><br />I changed it here (on TCH) to:<br /><br /><?php<br />// phpBB 2.x auto-generated config file<br />// Do not change anything in this file!<br /><br />$dbms = 'mysql';<br /><br />$dbhost = 'localhost';<br />$dbname = 'cpanelusername_databasename';<br />$dbuser = 'cpanelusername_databaseusername';<br />$dbpasswd = 'my chosen password';<br /><br />$dbhost = 'localhost';<br /><br /><br /><br /><br />$table_prefix = 'phpbb_';<br /><br />define('PHPBB_INSTALLED', true);<br /><br />?><!--QuoteEnd--></div><!--QuoteEEnd--><br /><br />This is the error message I get when I try to access the forum on my site, now hosted on TCH:<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->phpBB : Critical Error<br /><br />Could not query config information<br /><br />DEBUG MODE<br /><br />SQL Error : 1146 Table 'cpanelusername_databasename.phpbb_config' doesn't exist<br /><br />SELECT * FROM phpbb_config<br /><br />Line : 215<br />File : common.php<!--QuoteEnd--></div><!--QuoteEEnd--><br /><br /> I uploaded the forum to the public_html folder, is this the right place for it to be?<br /><br />$dbms = 'mysql'; is this line correct? On GoDaddy it read "$dbms = 'mysql4';"<!--content-->
Good movie, thank you Thomas.<br />I cut and pasted the script as shown.<br />I now have a new error message:<br /><br /><b>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<br />I cannot connect to the database because: Access denied for user 'cpanelusername_databasename'@'localhost' (using password: YES)</b><!--content-->
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. ?<br /><br /><br />In the error above I would usually expect "Access denied for user 'cpanelusername_database<b>USER</b>name'@'localhost' (using password: YES)" so it looks as if you have the databasename not the database username for the user.<!--content-->
Andy,<br /><br />All of my issues with this were due to a Major DUH! Factor.<br /><br />I had not <u>installed</u> phpBB2 on this host.<br /><br />I feel so stupid, but at the same time rather pleased that I figured it out.<br />Even if it did take me two days.<br /><br />I am not sure that this is the correct forum to continue this saga, if not please feel free to move me again.<!--content-->
we've all had those moments - I know I certainly have <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /> <br /><br />I'm glad you sorted it all out though <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><!--content-->I hope I am allowed to post this here.<br /><br />I found this yesterday on the phpBB2 forum before they went down"<br /><br /><!--quoteo--><div class='quotetop'>QUOTE</div><div class='quotemain'><!--quotec-->get Big Dump<br />Dont try to go to your board until you have finished all the steps, you will<br />get errors.<br /><br />At old board, go to admin panel;<br />1.set style back to subSilver<br />2.change domain name and script path to what the new one will be<br /><br />3.backup database , making sure that you have the DROP TABLE command<br /><br />How to phpmyadmin<br /><br />4. If you want to keep all your old phpbb files instead of using the new ones,<br />then copy your phpbb folder from the server to your computer.<br />( this is usually only necessary if you have lots of MODs installed and<br />don't want to install them again. )<br /><br /><br /><br />At new board;<br />1. create new database<br /><br />2.upload all phpbb files<br /><br />3.install phpbb<br /><br />4.create folder named "dump"<br /><br />5. open bigdump.php, edit to include database info for new database<br /><br />6. upload bigdump.php and old database backup to the "dump" folder<br /><br />7. in your browser, go to : ******/yourphpbb/dump/bigdump.php<br /><br />8. click the start restore link, when it is done;<br /><br />9. in your browser, go to: ******/phpbb/install/update_to_latest.php<br /><br />10.get this:<br />Auto Cookies MOD<br />then, unzip it to your computer,<br /><br />then upload the install folder ,<br /><br />then , in your browser, go to:<br />******/yourphpbbb/install/cookie.php<br /><br />then click the button to accept the settings it finds.<br /><br /><br />11. delete the install and contrib folders.<!--QuoteEnd--></div><!--QuoteEEnd--><!--content-->