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

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

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