Post by lasa » Fri Jul 26, 2013 7:32 pm

Hi,
My employer has been using the extension for some time now...and we are revamping our site. They have not used the extension in some time (since original upload awhile ago I assume)... I went to EXPORT and its giving all kinds of cryptic errors... we plan on using the extension on our new site because it did what it needed to do originally, but really need access to the original imported info. (original product excel file is not available)... is there some folder in Opencart we could find the original uploaded excel info? That would help tremendously!

I've attached the spooky error we receive upon trying to Export:
Any help would be appreciated,
Lasa2
------------
Error: Unknown column 'p.ean' in 'field list'
Error No: 1054
SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.ean, p.jan, p.isbn, p.mpn, 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, pd.tag, 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 FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;
See also 'System > Error Logs' for more details.

Active Member

Posts

Joined
Tue Apr 16, 2013 9:11 am
Who is online

Users browsing this forum: No registered users and 5 guests