|
I have purchased the Margin report from Tony. Everything works except that when ever I want to copy a products to another location (duplicate) I get an error.
1136 - Column count doesn't match value count at row 1
insert into products (products_quantity, products_model, products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, products_price, products_price1, products_price2, products_price3, products_price4, products_price5, products_price6, products_price7, products_price8, products_price9, products_price10, products_price11, products_price1_qty, products_price2_qty, products_price3_qty, products_price4_qty, products_price5_qty, products_price6_qty, products_price7_qty, products_price8_qty, products_price9_qty, products_price10_qty, products_price11_qty, products_qty_blocks, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('1', 'CD', 'hillsong-mighty-to-save.jpg', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.0000', now(), '16.9900', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0.0000', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', now(), '1969-12-31 19:00:00', '0.25', '0', '0', '165')
[TEP STOP]
Please help
|