v.1.3.1 product discount error
Posted: 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?
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?