Hello, the photo album was working very well, but today it suddently show a error message : Fatal error :
There was an error while processing a database query
What should i do?
Thanks.
If you can get t your config page, by browsing direct to your config.php, turn on debug mode (at the bottom), and then try again.
If you cant, use your database tool to go to the config table, and change the debug_mode row from '0' to '1'. Then revisit your gallery.
Post the info of the debug here.
I can go into the Config (function ) and set the Debug is On now. After that i run it again it shows the following :
While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 6 and cpg11d_pictures.aid NOT IN (51,50,45,46,47,48,52) " on 0
mySQL error: Can't open file: 'cpg11d_pictures.MYI'. (errno: 145)
Now what should i do?
possibly your mySQL database has been broken. Use the database repair tools (either from the command line if you have shell access) or with a tool like phpMyAdmin.
GauGau