Print

[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]

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?

[Nibbler]

http://forum.coppermine-gallery.net/index.php?topic=10409.0

[GuusQu]

Thanks! Problem solved!!