site is down due to Table 'dbasename.cpg148_config' doesn't exist

[emjoven]

Fatal error :

While executing query "SELECT * FROM cpg148_config" on 0

mySQL error: Table 'dpino3_coppermine.cpg148_config' doesn't exist


this is what you will see when you visit my site http://www.dpinoyweb.com/celebgallery/

What is wrong here?

[Joachim Müller]

Did you verify that the table the error message complains about is actually there?

[emjoven]

I opened the sql database via phpadmin, the table exist and it has contents. That's why I'm puzzled with the error.

[Joachim Müller]

Make sure that the permissions of the mySQL user specified in your_coppermine_gallery/include/config.inc.php haven't changed.

[emjoven]

<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['dbserver'] =  'localhost';        // Your database server
$CONFIG['dbuser'] =    'dpxxx_xxxxxxx';        // Your mysql username
$CONFIG['dbpass'] =    'xxxxxxx';                // Your mysql password
$CONFIG['dbname'] =   'dpxxx_xxxxxxxxxx';        // Your mysql database name


// MySQL TABLE NAMES PREFIX
$CONFIG['TABLE_PREFIX'] =  'cpg148_';
?>

This is the content of my CONFIG.INC.PHP file, just put "x" on the important info.  I don't see any discrepancy here.

[Joachim Müller]

Did you check the permissions of your mySQL user as suggested? You don't do this in coppermine. Usually, your webhost will provide you with some setup panel that will enable you to create and edit a mySQL user. If this is not the case, you may have to ask your webhost for support.

[emjoven]

I'm talking to my hosting support now. will be restoring the sql database this might solve the problem. will keep you posted.

thank you for your reply.