Error: 1136 - Column count doesn't match value count at row 1

[woodde]

Hello

 

I want to duplicate a Product in the back-end of my shop (using v. 2.2 RC1). But i'm getting this error message:

 

-----------------------

 

1136 - Column count doesn't match value count at row 1

 

INSERT INTO products (products_quantity, products_model, vendors_prod_id, products_image, products_price, vendors_product_price, vendors_prod_comments, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, vendors_id, manufacturers_id, products_base_price, products_base_unit) VALUES ('300', 'TH-20180551', '20180551', 'th_zaun_fiano_1.jpg', '54.2017', '0.0000', '', now(), '', '71.00', '0', '1', '1', '1', '16', '1.000000', '')

 

[TEP STOP]

 

-----------------------

 

When i choose the linking option it works but i need that duplication function to prevent to do double work for similar products. Can someone please enlighten me what could be the reason for this error?

 

Thanks in advance

[satish]

there are 16 fileds in this query and 17 values.

 

You need to probably remove the last '' value from the list.

 

Satish

[woodde]

there are 16 fileds in this query and 17 values.

 

You need to probably remove the last '' value from the list.

 

Satish

 

Thanks very much for the help. After searching and trying i've realised that i had to remove this portion '0', from the query and it worked again. Wish i'd know more about PHP / MySQL programming .... :'(

[♥geoffreywalton]

For those with an enquiring mind

 

http://www.w3schools.com/php/default.asp

 

and for those that want to be scared

 

http://www.php.net/manual/en/