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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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 1 Guest 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