Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted (edited)

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
  • 1 month later...
  • 3 months later...
Posted

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.

  • 2 months later...
Posted
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.

  • 4 years later...
Posted (edited)

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
Posted

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

Posted

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...