Critical error: There was an error while processing a database query

[Jamie Lee]

Hello. I keep getting the following error from my 1.2.1 gallery;

Critical 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/

[Nibbler]

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.

[Jamie Lee]

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.

[Joachim Müller]

you're probably looking at the structure of the config table, click on "browse" instead to see the actual content.

Joachim

[Jamie Lee]

Thank you.

Alright, I have the detailed error message now, but it's not making sense to me.

Here's the complete message:

While 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

[kegobeer]

Search the forums for the .myi message.  This is a MySQL issue, and I posted the fix for this.

[Jamie Lee]

That worked. Thank you all for your help!