Critical Error When viewing Catergories

[kingspice]

"When trying to view the catergories There was an error while processing a database query"
Suddenly when i try and access the catergories on my site i get a critical error,
http://www.britneyzone.com/coppermine
http://www.christinazone.com/coppermine

Individual galleries work fine, just the main catergories are giving errors.

I put it in debug mode and get the following error:

"While executing query "SELECT c.pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, msg_id, author_id, msg_author, UNIX_TIMESTAMP(msg_date) as msg_date, msg_body, aid FROM copperfield_comments as c, copperfield_pictures as p WHERE approved = 'YES' AND c.pid = p.pid AND copperfield_pictures.aid IN (9,10,36,13,15,21,23,29,31,38,41,44,50,51,52,53,62,69,70,72,74,76,90,91,92,93,94,95,96,97,98,99,100,101,102,106,107,108,109,110,111,118,121,122,126,141,142,148,149,163,167,171,184,185,187,188,191,192,197,202,203,204,206,221,224,225,226,228,235,236,237,242,243,264,265,266,272,273,275,276,279,284,285,288,289,290,294,295,307,311,313,314,315,316,317,318,319,320,321,322,325,326,327,339,340,347,348,353,354,357,358,360,361,370,371,373,374,376,377,378,379,386,387,389,391,393,394,397,402,403,405,406,407,408,413,415,426,427,433,435,438,456,457,460,461,464,465,466,467,468,478,480,481,484,486,487,488,493,494,495,497,499,505,506,514,521,527,528,531,538,539,554,555,565,566,571,572,577,578,579,583,585,600,601,602,603)  ORDER by msg_id DESC  LIMIT 0 ,8" on 0

mySQL error: Unknown table 'copperfield_pictures' in where clause"

The database tables still seem to exist in phpmyadmin so no idea what problem is.

Thanks

[Casper]

This is happening on both sites.  Was there anything you added or changed to the sites recently, before which it all worked fine?

[kingspice]

I found out what problem is, when i try to display the latest albums, it works fine on the main page, but when i go to the particular catergory i get critical error :|