What does this error mean

[DVBHardware]

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

 

insert into products (products_quantity, products_model, products_image, products_price, products_ship_price, products_ship_price_two, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('998', '', '', '7.9900', now(), '0.0000' , '0.0000' ,'', '0.00', '0', '0', '0')

 

[TEP STOP]

[boxtel]

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

 

insert into products (products_quantity, products_model, products_image, products_price, products_ship_price, products_ship_price_two, products_date_added, products_date_available, products_weight, products_length, products_width, products_height, products_ready_to_ship, products_status, products_tax_class_id, manufacturers_id) values ('998', '', '', '7.9900', now(), '0.0000' , '0.0000' ,'', '0.00', '0', '0', '0')

 

[TEP STOP]

<{POST_SNAPBACK}>

 

you list more table column than values to insert.

[DVBHardware]

you list more table column than values to insert.

<{POST_SNAPBACK}>

 

Ok how can I resolve it, its in my admin/catagories.php I'm not much of a coder, what can I look for.

 

Thanks, Jimmy

[boxtel]

Ok how can I resolve it, its in my admin/catagories.php  I'm not much of a coder, what can I look for.

 

Thanks, Jimmy

<{POST_SNAPBACK}>

 

well, you have obviously installed a contribution that changed the insert query.

So I would suggest you go over the instructions again.

[Guest]

it is most likely you used both sql queries for the 'individual ship' contribution, so you need to go over that completely. most likely you have code for using two prices yet one column.

[DVBHardware]

John & Amanda,

 

Somehow 10 contributions ago I made an error in admin/catagories.php when I installed

Attribute_Sorter_Copierv5(fixed_categories.php) and then I installed Individual ship 4 mods later which works flawlessly.

 

I must have overlooked testing the 'Copy To" in the admin product catalog.

 

I have narrowed it down to admin/catagories.php .

 

if anybody can take a look at the file it would be greatly appreciated, I have spent 18 hours so far on it and still cannot resolve it.

 

I know very little html but no php.

 

Jimmmy

 

www.dvbhardware.com