View Single Post
Old August 3rd, 2012, 07:26 AM   #1 (permalink)
Wulf
Member
Verified Customer
 
Join Date: Nov 2010
Location: NW Michigan (USA)
Posts: 117
Category add/edit errors

I want to change and a dd a few categories and am getting these errors.

When editing an existing category:

Quote:
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT c.id,c.catname,c.description,c.catorder,c.parent,c.thumbs,c.header,c.footer,c.password,c.theme,c.catdepth,c.headtags,c. private,c.ugnoview,c.ugnoupload,c.ugnopost,c.ugnovote,c.ugnoanno,c.watermark,c.sortorder,c.thumbtype,c.extra1,c.extra2,c.extra3,c.extra4, c.extra5,c.extra6,c.thumbnail,c.canzip,c.maximages,c.frames,c.intro,c.introtitle,c.introcopy,c.numextra,c.ratingtype,c.ismember,p.bigimage,p.width,p.height,p.userid,p.cat FROM pc_categories c LEFT JOIN pc_photos p ON p.id=c.thumbnail WHERE c.id='10' LIMIT 1

Result: Table 'saabworl_main.pc_photos' doesn't exist

Database handle: Resource id #86
Adding a new (sub) category:

Quote:
We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT catorder FROM pc_categories WHERE parent=10 AND cattype='c' ORDER BY catorder DESC LIMIT 1

Result: Unknown column 'cattype' in 'where clause'

Database handle: Resource id #86
Everything else seems to be working fine. Not sure why some tables and fields are suddenly missing in the database.
Wulf is offline   Reply With Quote