Post by qwerty111 » Thu Aug 13, 2009 5:38 am

after entering a test discount for a product it should appear in Special Offers , right? ..... but instead i get this:

Error: Table 'test.xproduct_special' doesn't exist
Error No: 1146
SELECT *, pd.name AS name, p.price, ps.price AS special, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM xreview r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating FROM xproduct_special ps LEFT JOIN xproduct p ON (ps.product_id = p.product_id) LEFT JOIN xproduct_description pd ON (p.product_id = pd.product_id) LEFT JOIN xmanufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN xstock_status ss ON (p.stock_status_id = ss.stock_status_id) WHERE ps.date_start < NOW() AND ps.date_end > NOW() AND p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND ss.language_id = '1' ORDER BY pd.name ASC LIMIT 0,12

after checking the database i couldn't find the table "product_special".

any suggestions?

Newbie

Posts

Joined
Thu Aug 13, 2009 5:33 am

Post by Daniel » Thu Aug 13, 2009 6:36 am

this is a bug. i'm going to fix it now then do another upload.

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm
Who is online

Users browsing this forum: No registered users and 9 guests