The only problem I have is that I cannot generate products. I get an error message;
Error: Unknown column 'po.option_value' in 'field list'
Error No: 1054
SELECT p.product_id, po.option_id, po.option_value, po.required, od.name AS `option` FROM ( SELECT product_id FROM `open_product` WHERE product_id BETWEEN 28 AND 53 ORDER BY product_id ASC ) AS p INNER JOIN `open_product_option` po ON po.product_id=p.product_id INNER JOIN `open_option_description` od ON od.option_id=po.option_id AND od.language_id='1' ORDER BY p.product_id ASC, po.option_id ASC
Further to the above problems I am now getting these error messages on the product page header;
Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505
You are not using any of the Opencart 1.5.1.x to 1.5.6.x databases, with the corresponding OpenCart versions, because for all these versions there is a 'product_option.option_value'. Looks like you are not telling us the whole story here.adb34 wrote:Error: Unknown column 'po.option_value' in 'field list'
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
A have no idea what you are trying to say here, sorry. Are you talking about the database that is being used by my opencart, which is MySQL v5 or what?You are not using any of the Opencart 1.5.1.x to 1.5.6.x databases, with the corresponding OpenCart versions, because for all these versions there is a 'product_option.option_value'. Looks like you are not telling us the whole story here.
No, I am talking about a specific DB table, namely the product_option. That one clearly has a field named option_value. Hence your error indicates that your are not using a standard OpenCart 1.5.x database.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
Can someone else help him please? Yours is not a standard OpenCart database, you may use MySQL which is fine, but with different DB tables.
Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig
No need for the help. I have installed OpenCart V2 and Import/Export for that versionJNeuhoff wrote:Can someone else help him please? Yours is not a standard OpenCart database, you may use MySQL which is fine, but with different DB tables.
Who is online
Users browsing this forum: No registered users and 116 guests