update failed

[yohooo8]

Hi, i have 1.21 before and i updated it to the current version 1.31.  I ran the update.php  and this is the message after the updating on the updated page:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/photos/public_html/update.php on line 38

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/photos/public_html/update.php on line 41


and this is the message when i run the index.php
Notice: Undefined index: debug_mode in /home/photos/public_html/include/functions.inc.php on line 96
Fatal error :
There was an error while processing a database query

what should i do? thanks.

[Joachim Müller]

make sure you have uploaded all files from the cpg1.3.1 package to your server. Make sure you're not trying to use a cpg1.2.1 theme. Do you have include/config.inc.php on your server? Sounds like you deleted it.

Enable debug_mode, using a tool like phpMyAdmin to manipulate your database directly. Browse to the cpg_config table and turn on debug_mode by setting it to "1".

Post a link to your gallery as well.

GauGau

[tanfwc]

That error means that you deleted your config.inc.php, i got this error while helping someone yesterday. Here is the config.inc.php sample if you want.

Code Select Expand

<?php
// Coppermine configuration file

// MySQL configuration
$CONFIG['dbserver'] =  "localhost"; // Your databaseserver
$CONFIG['dbuser'] =  "root"; // Your mysql username
$CONFIG['dbpass'] =  ""; // Your mysql password
$CONFIG['dbname'] =  "coppermine11"; // Your mysql database name


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