wrequine Posted August 26, 2010 Posted August 26, 2010 I am getting this error when duplicating a product in the catalog: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', '', '', '064.jpg', 'a:0:{}', '41.6000', now(), null, '0.00', '0', '1', '11' at line 1 insert into products (products_quantity, availability_id_in_stock, availability_id_out_of_stock, products_model, products_image, products_image_array, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('0', , '', '', '', '064.jpg', 'a:0:{}', '41.6000', now(), null, '0.00', '0', '1', '11') [TEP STOP] I am not familiar enough with sql, and other than using phpmyadmin to run a new query I am at a loss. Can anyone offer help on finding the error and then give instructions on how to fix it?
wrequine Posted August 26, 2010 Author Posted August 26, 2010 Okay, stupid me...found the extra comma in an update I made in /admin/categories.
Guest Posted August 26, 2010 Posted August 26, 2010 Okay, stupid me...found the extra comma in an update I made in /admin/categories. how easy that is to do
Guest Posted June 6, 2011 Posted June 6, 2011 Okay, stupid me...found the extra comma in an update I made in /admin/categories. Thanks for posting your error Best regards from "stupid me II " :-)
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.