Post by dzman7 » Wed Nov 19, 2014 2:00 am

When I attempt to add an option titled "First Expected Delivery" and the customer would input a date. It gives me the following error.

Fatal error: Uncaught exception 'ErrorException' with message 'Error: Unknown column 'option_value' in 'field list'<br />Error No: 1054<br />INSERT INTO product_option SET product_option_id = '0', product_id = '74', option_id = '12', option_value = '', required = '0'' in /home5/anothey5/public_html/manmail/system/database/mysqli.php:41 Stack trace: #0 /home5/anothey5/public_html/manmail/system/library/db.php(20): DBMySQLi->query('INSERT INTO pro...') #1 /home5/anothey5/public_html/manmail/admin/model/catalog/product.php(179): DB->query('INSERT INTO pro...') #2 /home5/anothey5/public_html/manmail/admin/controller/catalog/product.php(75): ModelCatalogProduct->editProduct('74', Array) #3 [internal function]: ControllerCatalogProduct->update() #4 /home5/anothey5/public_html/manmail/system/engine/front.php(42): call_user_func_array(Array, Array) #5 /home5/anothey5/public_html/manmail/system/engine/front.php(29): Front->execute(Object(Action)) #6 /home5/anothey5/public_html/manmail/admin/index.php(162): Front->dispatch(Object(A in /home5/anothey5/public_html/manmail/system/database/mysqli.php on line 41

I can add other options to a product but no options with the type as a date.

I have used this option on all previous products (30+ products) but just recently it started giving me this error. Can someone please let me know what I can do to solve this issue. I was previously looking through shipping, and product php files but did not change anything (or did not mean to change anything). I tried updating all the product.php files with originals from fresh download but it did not resolve the issue.

I am using Opencart version



Tue Nov 18, 2014 2:01 am
Who is online

Users browsing this forum: rgfuelcells and 10 guests