Duplicate item problem...

[wwfc_barmy_army]

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

 

insert into products (products_quantity, products_model,/*changes indvship*/ products_ship_price,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('200', 'CD1234', 'CD1234.gif', '10.9900', now(), '', '0.00', '0', '0', '0')

 

[TEP STOP]

 

I know i shouldn't be working on Christmas Day but i need to :P Any idea why i am getting this when i try to duplicate an item?

 

Thanks.

 

Merry Christmas!

 

Pete.

[boxtel]

I know i shouldn't be working on Christmas Day but i need to :P Any idea why i am getting this when i try to duplicate an item?

 

Thanks.

 

Merry Christmas!

 

Pete.

<{POST_SNAPBACK}>

 

 

get this /*changes indvship*/ out of your query

[wwfc_barmy_army]

Where do i find it? Which page?

 

Cheers.

 

Pete.

[Guest]

you will need to look in your browser where you are getting the error and start from that program listed

 

what are you dong when u get this error?

[wwfc_barmy_army]

Thanks for the replies.

 

After a little bit of tinkering, i found that i had to take the '/*changes indvship*/ products_ship_price' bit out. This is part of the 'induvidual shipping' prices, and now when duplicating it doesn't transfer the induvidual shipping price which isn't really a bit deal.

 

Maybe someone could create a contribution to fix this ;)

 

Thanks.

 

Pete.