Coppermine missing tables?

[drfeces]

I am receiving this error constantly and I have NO idea what is causing it. I recently transfered servers and moved the databases and all the files properly, but ever since then I am receiving this error and I can't access the gallery at all. Any ideas of what this may be?

Heres the error:

FATAL ERROR:

While executing query "SELECT * FROM cpg148_config" on 0

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



Any idea how to fix this?

[Nibbler]

Make sure include/config.inc.php is correct.

[drfeces]

What do you mean correct? I've looked at that file before but im not sure what I should be looking for.

[Nibbler]

The database name in the file should be the name of your Coppermine database, the prefix should be prefix used for tables in that database and the username and password should correspond to a valid mysql user with access to that database.

[drfeces]

Well I looked over the config.inc.php file and it should be all correct but still no good. Any other suggestions? Im really at a loss lol.

[Nibbler]

Ask your host. We can't tell you what the correct values are.

[drfeces]

Well I went and contacted my host and they told me what the table prefix should be, I put it in in the config.inc.php file but it still not working. It seems like everything is set correctly but Im still not sure why I can't get the images to display.

Still staring at this fatal error:
While executing query "SELECT * FROM justinpa_config" on 0

mySQL error: Table 'justinpa_cop1.justinpa_config' doesn't exist

[Joachim Müller]

Nibbler's answer still applies: the error message is quite straightforward - it complains that the table doesn't exist, so you need to make sure that you have used the proper data. Also make sure that the table exists in the first place - if it got deleted, restore it from a backup. Ask you webhost to review this thread - they should know what to do.