Database Name change

[-TRshady-]

http://www.trshady.com/gallery/ is my gallery.
Uploaded to a new server, made db back up and uploaded all files ... added it all and seems to have gone well but ..

Old hosting account had the username TRiley, now its TRshady which is reason behind the error im getting.
What I would like to ask is, where can I change the database name?

Thanks

[Nibbler]

in include/config.inc.php

[-TRshady-]

Thanks a lot for the reply, am now recieving the following error:


Notice: Undefined index: debug_mode in /home/trshady/public_html/gallery/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

Any ideas on what to do?

[-TRshady-]

any ideas people?

[Nibbler]

Enable debug mode and post the real error - posting 'There was an error while processing a database query' doesnt help anyone. If you cannot login, you will have to find cpg_config table and alter the 'debug_mode' field to '1'.

[skybax]

Coppermine appears to not be connecting to your database. Make sure that not only your username changed but mabe a prefix to the database name as well. I know some hosts place a prefix on the database name during the install. The code surrounding your error is that the query has failed.

lines 91-107

Code Select Expand


// Error message if a query failed
function db_error($the_error)
{
        global $CONFIG;

        if (!$CONFIG['debug_mode']) {
            cpg_die(CRITICAL_ERROR, 'There was an error while processing a database query', __FILE__, __LINE__);
        } else {

                $the_error .= "\n\nmySQL error: ".mysql_error()."\n";

                $out = "<br />There was an error while processing a database query.<br /><br/>
                    <form name='mysql'><textarea rows=\"8\" cols=\"60\">".htmlspecialchars($the_error)."</textarea></form>";

            cpg_die(CRITICAL_ERROR, $out, __FILE__, __LINE__);
        }
}


try setting up a small script to connect to your database and make sure you can access it first...