Print

[glennk]

Hi There.

I recently moved hosts. I transferred the database across and was met by a screen saying mysql could not connect. After searching around this forum I realised I had the databse username and password wrong in the inc/config file.

I set the configuration right and am not met by a screen saying fatal erorr.

My site url is :

http://www.whitbyseaanglers.co.uk/members-gallery/index.php

Your help would be appreciated.

[Joachim Müller]

Enable debug mode in coppermine's config, then post the actual error message (the query that fails - not the debug_output). If you can't go to the config screen to enable debug mode, read up Tutorial: Manually enabling debug_mode

[glennk]

Thankyou for that. The resulting error message says

While executing query "select * from cpg_plugins order by priority asc;" on 0

mySQL error: Table 'copp1.cpg_plugins' doesn't exist

[phill104]

Have you correctly set the database name in include.config.inc.php ?

The database name will have changed too which is likely to be your problem.

[glennk]

Hi Phil,

Wouldnt the error be different if that was the case ? would it not just say unable to connect ?

[glennk]

This is whats in the file. I think its right but then again I could be wrong :

<?php

    define ( 'SILLY_SAFE_MODE' , 1 ) ;

    $CONFIG['dbserver'] = 'localhost' ;
    $CONFIG['dbuser'  ] = 'copp1user' ;
    $CONFIG['dbpass'  ] = ' [Edit] ' ;
    $CONFIG['dbname'  ] = 'copp1'   ;

    $CONFIG['TABLE_PREFIX'] = 'cpg_';

?>

[phill104]

Not if the table prefix was incorrect. However, in that case you would probably get a config table missing error at that is processed before the plugins.

Check using phpmyadmin that the copp1.cpg_plugins does exist. If not restore it from your backup

[phill104]

Now after running update.php for you there is a different error.

'copp1.cpg_users'

It certainly looks like you haven't restored your database correctly.

[glennk]

Cheers Phil. 

I was wondering what was happening there as I noticed the error message changed. I have spoken to support and the hosts are going to try install the database again from the original dump.

I will post back to let you know how it goes.

[phill104]

Always take regular dumps yourself, being regular is good for you

Seriously though, taking regular backups is essential. Had you done that yourself you would not have to await your host.

[glennk]

Cheers Phil,

I will have to get into the habbit of weekly dumps.

Indeed you were right, the database had not imported properly. I started from scratchg and with the help of the hosts, all appears to be working now.

Many thanks for your help yet again guys, and ofcourse, thanks to joachim for not shouting at me.