Jump to content
Sign in to follow this  
deportu

Problems with "Quantity for Product Attributes Mod"

Recommended Posts

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 by deportu

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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 by dvale

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×