Hello. I keep getting the following error from my 1.2.1 gallery;
QuoteCritical error
There was an error while processing a database query
I had put in an extra text field in the picture info. Then, I went to edit one of my separate galleries. I set the amount of shown pictures to 100, then began to fill in the new field on each picture, also deciding to remove the search engine words. When I hit the submit button to save these changes, I started receiving this error. It occurs on all album pages, last uploads, most viewed, top rated, last uploads, users and my profile. I have no idea what could have happened or what I could do to fix this problem, as even my admin controls are giving me this error.
The URL for my gallery is: http://www.shatteredmoonlight.com/artgallery/
Find your coppermine config table in your coppermine database using a database admin tool such as phpmyadmin and switch the 'debug mode' field to '1'. Then you should get a more detailed error message. If you cannot solve it with this new knowledge, post the mysql error message here.
I'm looking in my phpmyadmin, but I have no idea what I'm looking for or what I'm doing. My website service automatically installed the gallery system for me, so I've never worked with a SQL database before.
I assume though that what I'm looking for is "cpg11d_config"? I clicked it but I see no "debug mode" field.
you're probably looking at the structure of the config table, click on "browse" instead to see the actual content.
Joachim
Thank you.
Alright, I have the detailed error message now, but it's not making sense to me.
Here's the complete message:
QuoteWhile executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000" on 0
mySQL error: Can't open file: 'cpg11d_pictures.MYI'. (errno: 145)
File: /home/s8164534/public_html/artgallery/include/functions.inc.php - Line: 105
Search the forums for the .myi message. This is a MySQL issue, and I posted the fix for this.
That worked. Thank you all for your help!