"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
This is happening on both sites. Was there anything you added or changed to the sites recently, before which it all worked fine?
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 :|