Post by jld » Sun Jan 25, 2015 9:08 am

I installed the Import Export tool opencart-1-5-6-x-export-import-1-18.zip
I am running Opencart version Version 1.5.6.3


this is the error I get when trying to export

Error: Unknown column 'po.option_value' in 'field list'
Error No: 1054
SELECT po.product_id, po.option_id, po.option_value AS default_value, po.required, pov.option_value_id, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix, ovd.name AS option_value, ov.image, ov.sort_order, od.name AS option_name, o.type FROM `oc_product_option` po LEFT JOIN `oc_option` o ON o.option_id=po.option_id LEFT JOIN `oc_product_option_value` pov ON pov.product_option_id = po.product_option_id LEFT JOIN `oc_option_value` ov ON ov.option_value_id=pov.option_value_id LEFT JOIN `oc_option_value_description` ovd ON ovd.option_value_id=ov.option_value_id AND ovd.language_id=1 LEFT JOIN `oc_option_description` od ON od.option_id=o.option_id AND od.language_id=1 ORDER BY po.product_id, po.option_id, pov.option_value_id;
See also 'System > Error Logs' for more details.

jld
Newbie

Posts

Joined
Thu Aug 08, 2013 5:47 pm

Post by jld » Tue Jan 27, 2015 1:25 pm

Please cant someone help me with this

jld
Newbie

Posts

Joined
Thu Aug 08, 2013 5:47 pm

Post by beroni » Sun Feb 08, 2015 6:22 pm

I had a similar issue in the past, where I was using an SEO extension which was adding additional fields in the admin panel / database. Because the Import/Export spreadsheet covers the default fields, I followed the instructions here: http://forum.opencart.com/viewtopic.php?t=81305#p344783

In your case, I think this po.option_value suggests there is an extension/vQmod that bugs the import/export similarly, so this field must be added manually to the spreadsheet as described in the link.

Newbie

Posts

Joined
Sun Feb 08, 2015 6:16 pm
Who is online

Users browsing this forum: No registered users and 10 guests