Need some Help with database error!! Need some Help with database error!!
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

Need some Help with database error!!

Started by GuusQu, March 03, 2006, 05:58:28 PM

Previous topic - Next topic

0 Members and 2 Guests are viewing this topic.

GuusQu

There is some problem with my database. When someone is trying to look at my pictures the following message appeared:
"There was an error while processing a database query " This appeared for every user and when I am not logged in!
Only when I log in with an administrator account everything is OK.

What did I wrong. Nothing has changed. I only uploaded some pictures today. When I checked it, I had this error.
My version of coppermine is 1.4.4,
my database is at: fotobase.quaedvlieg.net

Please help ...

Nibbler

Enable debug mode and post the mysql error message you receive.

GuusQu

This is the message:

While executing query "INSERT INTO cpg11d_hit_stats
                          SET
                            pid = 1402,
                            search_phrase = '',
                            Ip   = '80.126.120.61',
                            sdate = '1141409020',
                            referer='http://fotobase.quaedvlieg.net/index.php',
                            browser = 'Microsoft Internet Explorer 6.0',
                            os = 'Windows XP'" on 0

mySQL error: Can't open file: 'cpg11d_hit_stats.MYD'. (errno: 145)

GuusQu

Quote from: GuusQu on March 03, 2006, 07:04:39 PM
This is the message:

While executing query "INSERT INTO cpg11d_hit_stats
                          SET
                            pid = 1402,
                            search_phrase = '',
                            Ip   = '80.126.120.61',
                            sdate = '1141409020',
                            referer='http://fotobase.quaedvlieg.net/index.php',
                            browser = 'Microsoft Internet Explorer 6.0',
                            os = 'Windows XP'" on 0

mySQL error: Can't open file: 'cpg11d_hit_stats.MYD'. (errno: 145)


When I look in the database it says: "file in use". How can I unlock it?



GuusQu