Using Opencart 1.5.6
After installing this tool is works but when i open the Excel file all i see is one line
<b>Notice</b>: Error: Table 'mirworld_ope1.qrw_product_tag' doesn't exist<br />Error No: 1146<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `qrw_product` p LEFT JOIN `qrw_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `qrw_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `qrw_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `qrw_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `qrw_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `qrw_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `qrw_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `qrw_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id; in <b>/home2/mirworld/public_html/comptest/system/database/mysql.php</b> on line <b>50</b>
Any ideas as to what this may be please or what i have done wrong
Thanks for any help
product_tag was used in the old version
Why your code is referring to it? Did you get the correct version of the tool?
Why your code is referring to it? Did you get the correct version of the tool?
Donate here to show support if you think I have helped you today!
Opencart Documentation
Who is online
Users browsing this forum: No registered users and 5 guests