deportu Posted March 12, 2006 Posted March 12, 2006 (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 March 12, 2006 by deportu Quote
patruskal Posted May 7, 2006 Posted May 7, 2006 I am having this problem as well and I need assistance ASAP. Quote
4jrr Posted August 21, 2006 Posted August 21, 2006 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. Quote
wenonae Posted October 23, 2006 Posted October 23, 2006 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 1 Quote
dvale Posted May 28, 2011 Posted May 28, 2011 (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 May 28, 2011 by dvale Quote
dvale Posted May 28, 2011 Posted May 28, 2011 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 Quote
♥toyicebear Posted May 29, 2011 Posted May 29, 2011 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. Quote Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here]
Recommended Posts
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.