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

[danielle_1_uk]

Hi All,

 

I have a working osCommerce store, which apparently seems to work fine, except for one slight anomaly. I cannot seem to duplicate products into other categories.

 

Admin --> Catalog --> Categories/Products --> Select Category --> Select Product --> select 'Copy To' button --> Select Category from drop-down --> select 'Duplicate Product' radio button --> select 'Copy' button

 

Results in the following error:

 

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 ('88', '', 'PR159a.jpg', '7.6000', now(), null, '0.15', '0', '1', '0' , '0')

[TEP STOP]

 

I'm using osCommerce 2.2-MS2, but I have no information regarding the initial installation or added modules as the shop came pre-installed.

 

Anyone know what's causing this error?

[♥geoffreywalton]

You have 10 field names and 11 values

 

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 (

'88',

'',

'PR159a.jpg',

'7.6000'

, now(),

null,

'0.15'

, '0',

'1',

'0'

, '0')

 

see if you can find the code

 

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

 

and work out what the "extra" field is.

[danielle_1_uk]

You have 10 field names and 11 values

 

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 (

'88',

'',

'PR159a.jpg',

'7.6000'

, now(),

null,

'0.15'

, '0',

'1',

'0'

, '0')

 

see if you can find the code

 

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

 

and work out what the "extra" field is.

 

I can't seem to find that code anywhere. I tried a grep search for 'insert into products' with no luck. Do you perhaps know where that code might be located.

 

After looking at other forum posts, I've looked in admin/categories.php and admin/product_attributes.php for the extra field, but no luck.