Problems with "Quantity for Product Attributes Mod"

[deportu 0]

Contribution link: http://www.oscommerce.com/community/contributions,3302/

 

After installing this mod I get this error in several of the items that already have attributes:

1054 - Unknown column 'pa.options_quantity' in 'field list'

 

select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.options_quantity from products_attributes pa, products_options_values pov where pa.products_id = '1' and pa.options_id = '4' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1'

 

[TEP STOP]

And this error every time I try to add an attribute, with a quantity or not:

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

 

insert into products_attributes values ('', '8', '1', '3', '12', '+', '2')

 

[TEP STOP]

 

I've installed the contribution correctly, methinks. Is anyone else having this problem?

Edited March 12, 2006 by deportu

[deportu 0]

Anyone...?

[patruskal 0]

I am having this problem as well and I need assistance ASAP.

[4jrr 0]

You seem to have forgotten to run the SQL code on your database that adds the options_quantity field to the table, products_attributes. Since it is not there, you can't put data into it.

[wenonae 1]

You seem to have forgotten to run the SQL code on your database that adds the options_quantity field to the table, products_attributes. Since it is not there, you can't put data into it.

 

Thanks..this info was perfect.

[dvale 4]

Thanks..this info was perfect.

 

Hello Clair. It will be great if you tell me how did you RUN the SQL code in your database. That's all I need to make this work. Thank you

Edited May 28, 2011 by dvale

[dvale 4]

Hello Clair. It will be great if you tell me how did you RUN the SQL code in your database. That's all I need to make this work. Thank you

[♥toyicebear 206]

To run sql files, go to your hosting control-panel and navigate to your db info and there choose phpmyadmin, that is where you can add those to your shops db.