forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: SurfDude on October 22, 2003, 10:09:32 pm

Title: "There was an error while processing a database query&q
Post by: SurfDude on October 22, 2003, 10:09:32 pm

When I try to open my gallery, I get the error "There was an error while processing a database query". Before this, all worked just fine, and I don't think I have changed anything. What happened?

Title: "There was an error while processing a database query&q
Post by: jasendorf on October 22, 2003, 10:10:45 pm

we need a screen shot or some more information... can you turn debugging on (last option in config page)?

Title: "There was an error while processing a database query&q
Post by: SurfDude on October 22, 2003, 10:30:20 pm

Quote from: "jasendorf"

we need a screen shot or some more information... can you turn debugging on (last option in config page)?

Debugmode gives this error:

Quote

While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 4" on 0

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

File: c:\phpdev\www\fotosvoorerror\include\functions.inc.php - Line: 105

Title: "There was an error while processing a database query&q
Post by: jasendorf on October 22, 2003, 10:37:05 pm

Try repairing the table in MySQL  (perhaps through phpMyAdmin)

Title: "There was an error while processing a database query&q
Post by: SurfDude on October 22, 2003, 10:38:11 pm

Quote from: "jasendorf"

Try repairing the table in MySQL  (perhaps through phpMyAdmin)

How should I do that?  :?

Title: "There was an error while processing a database query&q
Post by: jasendorf on October 22, 2003, 10:39:29 pm

http://www.mysql.com/doc/en/Repair.html

Title: "There was an error while processing a database query&q
Post by: SurfDude on October 22, 2003, 11:30:46 pm

Quote from: "jasendorf"

http://www.mysql.com/doc/en/Repair.html

I'm running my server on Windows XP. I think I have to run "myisamchk", but how do I do that with windows XP?

Title: "There was an error while processing a database query&q
Post by: SurfDude on October 22, 2003, 11:42:13 pm

I've done a repair on that table with phpMyAdmin, and now it works all fine (again)!

Title: "There was an error while processing a database query&q
Post by: Zarsky on October 22, 2003, 11:46:36 pm

surfdude,

Congradulations on resolving your problem....primarily through your own diligence.


PS...  There is a lesson to the other grasshoppers on this board.  I think us devs are all willing to help anyone, but sometimes you have to learn to use the relevant resources widely available.

Title: "There was an error while processing a database query&q
Post by: jasendorf on October 23, 2003, 06:12:20 am

Quote from: "zarsky99"

PS...  There is a lesson to the other grasshoppers on this board.  I think us devs are all willing to help anyone, but sometimes you have to learn to use the relevant resources widely available.

Yeah, some devs give you fish (if they've got some spare), some teach you to fish... and then there's those like me who point at the lake and then run off for band rehearsal (http://www.theshrunkenheads.com)!