ryaniksentrik Posted May 13, 2008 Posted May 13, 2008 The add can be found here: http://addons.oscommerce.com/info/4085 I seem to be having problems on the actual items descriptions 1054 - Unknown column 'p.newsdesk_id' in 'on clause' select p.newsdesk_id, pd.language_id, pd.newsdesk_article_name, pd.newsdesk_article_description, pd.newsdesk_article_shorttext, pd.newsdesk_article_url, pd.newsdesk_article_url_name, p.newsdesk_image, p.newsdesk_date_added, p.newsdesk_last_modified, p.newsdesk_date_available, p.newsdesk_status from newsdesk p, newsdesk_description pd LEFT JOIN newsdesk_to_stores p2s ON p.newsdesk_id = p2s.newsdesk_id WHERE p2s.stores_id = "STORES_ID" and pd.newsdesk_id = p.newsdesk_id and pd.language_id = "1" and newsdesk_status = 1 ORDER BY newsdesk_date_added DESC LIMIT 5 this is now showing on all items descriptions down the left hand side of the web page See here for example http://www.iksentrik.co.uk/product_info.ph...roducts_id=2194 any ideas how I can fix this? Cheers Ryan
Recommended Posts
Archived
This topic is now archived and is closed to further replies.