coppermine 1.4.8 fatal error

[elogica]

I'm sorry, but I don't speak english very well.

Hi, I've upgrated from Coppermine 1.4.7 to 1.4.8 and now I've a fatal error. You can see all here : www.new-image.it/public/

I see the FAQ but never talk about this.

thank you!

[Tranz]

Judging from update.php, it seems like a mysql error. Enable debug mode with info from here: http://coppermine-gallery.net/tutorial/ Then post the error message here.

[Paver]

TranzNDance is correct.  Before that though, I would check your include/config.inc.php and make sure the MySQL database settings are correct.  Maybe TranzNDance already knows that this would give a different error, so excuse me if I am mistaken, but it doesn't hurt to check.   

[elogica]

I have followed the instruction of the tutorial, but I've this error :

query SQL:

UPDATE `cpg11d_config` SET `value` = '1' WHERE `name` = 'debug_mode' LIMIT 1

Messaggio di MySQL: 

#1044 - Access denied for user: 'Sql71536@%' to database 'Sql71536_1'

can I have any problem with a database? Is this the cause of fatal error?

thanks

[Sami]

- did you use phpmyadmin?(I think you are using remote Mysql client)
- are you sure the database name and username is true?
- did you provide password ?(I think you missed that part)

[elogica]

yes, because with coppermine 1.4.7 the photogallery worked. with coppermine 1.4.8 I haven't upload include/config.inc.php file. the database parameters are the same

[Paver]

I have followed the instruction of the tutorial, but I've this error :
query SQL:
UPDATE `cpg11d_config` SET `value` = '1' WHERE `name` = 'debug_mode' LIMIT 1
Messaggio di MySQL: 
#1044 - Access denied for user: 'Sql71536@%' to database 'Sql71536_1'
can I have any problem with a database? Is this the cause of fatal error?

If this was done in phpMyAdmin, then my guess is that the permissions for your user account have changed to not allow updates.  This would explain the error message above and the error in Coppermine (since Coppermine updates certain tables).  With most webhosts, you cannot change the permissions yourself.   As noted in the Coppermine documentation:

The MySQL user needs permissions to perform CREATE, ALTER, SELECT, UPDATE, DELETE, INSERT data from the database.

My guess is something changed with your MySQL privileges.  It does seem strange that it was coincidental with the 1.4.8 upgrade, but your error listed above is not through Coppermine and Coppermine does not (and cannot) change MySQL privileges, so that's my best guess.

So you'll have to check with your webhost to see if the MySQL privileges have changed and if they can put them back.

[Ssurgul]

Also, so folks might be aware, I ran into the same error.  And following the threads here, I couldn't figure out what on earth was wrong because the system's permissions were right, as were the filesystem permissions.

On checking the log, I found this:

060627 10:00:38 [ERROR] /usr/sbin/mysqld: Can't open file: 'cpg11d_sessions.MYI' (errno: 145)

On checking the MySQL site, this is a corrupted table error.  Running the repair table through phpMyAdmin solved the same symptom quite nicely.