New Zenner
- Join Date:
- Jul 2008
- Posts:
- 18
- Plugin Contributions:
- 0
1292 Error while trying to duplicate product
Hello,
When I try to copy a product and duplicate it I receive this error:
1292 Incorrect datetime value: '' for column 'products_date_available' at row 1
in:
[insert into products (products_type, products_quantity, products_model, products_image, products_price, products_virtual, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_price_sorter, master_categories_id ) values ('1', '0', 'DDF974B', 'TimbrenFrontPicture.gif', '196.1455', '0', now(), '', '3', '0', '1', '20', '1', '1', '0', '0', '0', '1', '1', '1', '0', '1', '196.1455', '1229')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
However, when I just want to link the products the problem does not occur.
I am assuming the problem is stemming from the 'now()' that is inserted into the date_available field but I do not want to mess with my database with out getting some verification. I am not sure if it is one of the files that needs to be rendered or if is the database itself that needs to be adjusted.
Any help would be greatly appreciated, and thanks for reading.
:smile:
PS. When I adjust the date available to a future date the problem does not occur as well.
