capsulas Posted March 31, 2003 Share Posted March 31, 2003 Hello from Mexico ! I have 2 little troubles, I added the FAQDesk contribution, and the admin area show up.... Anybody can help me, thank, thank... Trouble 1 ----------------------------------------------------------------------- 1054 - Unknown column 'c.last_modified' in 'field list' select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.catagory_status from faqdesk_categories c, faqdesk_categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '3' order by c.sort_order, cd.categories_name ---------------------------------------------------------------------------------- The second trouble in the web user area: Trouble 2 ---------------------------------------------------------------------- 1054 - Unknown column 'p.faqdesk_image' in 'field list' select p.faqdesk_id, pd.language_id, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short, pd.faqdesk_extra_url, p.faqdesk_image, p.faqdesk_date_added, p.faqdesk_last_modified, p.faqdesk_date_available, p.faqdesk_status from faqdesk p, faqdesk_description pd WHERE pd.faqdesk_id = p.faqdesk_id and pd.language_id = "3" and faqdesk_status = 1 ORDER BY faqdesk_date_added DESC LIMIT 5 [TEP STOP] Quote Link to comment Share on other sites More sharing options...
capsulas Posted March 31, 2003 Author Share Posted March 31, 2003 Hello !! Sorry, the trouble 1, is 1054 - Unknown column 'p.faqdesk_image' in 'field list' select p.faqdesk_id, pd.faqdesk_question, p.faqdesk_image, p.faqdesk_image_two, p.faqdesk_image_three, p.faqdesk_date_added, p.faqdesk_last_modified, p.faqdesk_date_available, p.faqdesk_status, p.faqdesk_sticky from faqdesk p, faqdesk_description pd, faqdesk_to_categories p2c where p.faqdesk_id = pd.faqdesk_id and pd.language_id = '3' and p.faqdesk_id = p2c.faqdesk_id and p2c.categories_id = '0' order by pd.faqdesk_question Hello from Mexico ! I have 2 little troubles, I added the FAQDesk contribution, and the admin area show up.... Anybody can help me, thank, thank... Trouble 1 ----------------------------------------------------------------------- 1054 - Unknown column 'c.last_modified' in 'field list' select c.categories_id, cd.categories_name, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.catagory_status from faqdesk_categories c, faqdesk_categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '3' order by c.sort_order, cd.categories_name ---------------------------------------------------------------------------------- The second trouble in the web user area: Trouble 2 ---------------------------------------------------------------------- 1054 - Unknown column 'p.faqdesk_image' in 'field list' select p.faqdesk_id, pd.language_id, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short, pd.faqdesk_extra_url, p.faqdesk_image, p.faqdesk_date_added, p.faqdesk_last_modified, p.faqdesk_date_available, p.faqdesk_status from faqdesk p, faqdesk_description pd WHERE pd.faqdesk_id = p.faqdesk_id and pd.language_id = "3" and faqdesk_status = 1 ORDER BY faqdesk_date_added DESC LIMIT 5 [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2003 Share Posted March 31, 2003 please dont cross post message or ask them more than once - please :D Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.