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 ...
Enable debug mode and post the mysql error message you receive.
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)
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?
http://forum.coppermine-gallery.net/index.php?topic=10409.0
Thanks! Problem solved!!