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 Quote
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.