Page 1 of 1

Export / Import - Export .xls file

Posted: Thu Aug 27, 2009 4:09 pm
by dakis
When I am exporting the file I am getting:

Error: Table 'stakiasg_opn01.opc_measurement_class' 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.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.sort_order, 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, pd.language_id, ua.keyword, pd.description, pd.meta_description, p.stock_status_id, mc.unit AS measurement_unit FROM `opc_product` p LEFT JOIN `opc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `opc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `opc_url_alias` ua ON p.product_id=SUBSTR( ua.query, 1, LENGTH( 'product_id=' ) ) = 'product_id=' AND p.product_id = SUBSTR( ua.query, LENGTH( 'product_id=' ) +1, LENGTH( ua.query ) - LENGTH( 'product_id=' ) ) LEFT JOIN `opc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `opc_weight_class` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `opc_measurement_class` mc ON mc.measurement_class_id=p.measurement_class_id AND mc.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

I am using the latest version of Open Cart & Export/Import module.

Is any solution to this error?

Re: Export / Import - Export .xls file

Posted: Tue Sep 29, 2009 9:27 pm
by champton
I have this error too. Anyone know why. I need to get this resolved so I can bulk upload my products from my sql db to the MySql