"There was an error while processing a database query&q

[SurfDude]

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?

[jasendorf]

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

[SurfDude]

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

Debugmode gives this error:

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

[jasendorf]

Try repairing the table in MySQL  (perhaps through phpMyAdmin)

[SurfDude]

Try repairing the table in MySQL  (perhaps through phpMyAdmin)

How should I do that?  :?

[jasendorf]

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

[SurfDude]

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?

[SurfDude]

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

[Zarsky]

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.

[jasendorf]

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!