Unable to copy products

[PJ2006]

If I try to copy a product, I get the following error message:

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

 

insert into products (products_quantity, products_model,products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('0', 'RA-1', 'RA-1 Acoustic.jpg', 'RA-1 Acoustic.jpg', 'RA-1 Acoustic.jpg', 'RA-2 Acoustic cutaway.jpg', 'RC-2 Classical cutaway.jpg', '', '', '', '', '', '', '', '', '', '', '136.1617', now(), '', '1.00', '0', '1', '0')

 

[TEP STOP]

 

 

Does anyone have any idea what is wrong? I have ultrapics installed and wonder if this is the problem with the column count?

 

Thanks

[GemRock]

well, i think it is pretty obvious: you tried to insert several product images: 'RA-1 Acoustic.jpg', 'RA-1 Acoustic.jpg', 'RA-2 Acoustic cutaway.jpg', 'RC-2 Classical cutaway.jpg' but you only had ONE image field in the table. i guess you forgot to run or it failed to run correctly a mysql query that comes with an image contribution that would otherwise creates the extra image fields/columns.

 

Ken

[PJ2006]

well, i think it is pretty obvious: you tried to insert several product images: 'RA-1 Acoustic.jpg', 'RA-1 Acoustic.jpg', 'RA-2 Acoustic cutaway.jpg', 'RC-2 Classical cutaway.jpg' but you only had ONE image field in the table. i guess you forgot to run or it failed to run correctly a mysql query that comes with an image contribution that would otherwise creates the extra image fields/columns.

 

Ken

Hi

 

Yes I figured it was to do with this, I have ultrapics installed but I do have multiple image fields in the DB but I guess not enough. I did do the SQL update for the contribution though :blush:

[GemRock]

in that case you will need to modify the sql in question to reflect/add the new fields.

 

Ken