Post by fredsat » Sun Feb 16, 2014 5:37 pm

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

Newbie

Posts

Joined
Wed Feb 12, 2014 6:41 am

User avatar
Active Member

Posts

Joined
Sun May 22, 2011 12:54 pm

Post by fredsat » Sun Feb 16, 2014 8:28 pm

i did not upgrade it was a new install but i did try to run it to see if it would fix it but all i get is

"product_tag table not found. Perhaps you already ran this script"

Newbie

Posts

Joined
Wed Feb 12, 2014 6:41 am

Post by nvedia » Mon Feb 17, 2014 12:32 am

product_tag was used in the old version
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


User avatar
Active Member

Posts

Joined
Sun May 22, 2011 12:54 pm

Post by fredsat » Tue Feb 18, 2014 6:11 am

opencart-1-5-6-x-export-import-17.zip this is the one i loaded it said for 1.5.6

Newbie

Posts

Joined
Wed Feb 12, 2014 6:41 am
Who is online

Users browsing this forum: No registered users and 5 guests