deportu Posted March 12, 2006 Share 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 Link to comment Share on other sites More sharing options...
deportu Posted March 12, 2006 Author Share Posted March 12, 2006 Anyone...? Quote Link to comment Share on other sites More sharing options...
patruskal Posted May 7, 2006 Share Posted May 7, 2006 I am having this problem as well and I need assistance ASAP. Quote Link to comment Share on other sites More sharing options...
4jrr Posted August 21, 2006 Share 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 Link to comment Share on other sites More sharing options...
wenonae Posted October 23, 2006 Share 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 Link to comment Share on other sites More sharing options...
dvale Posted May 28, 2011 Share 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 Link to comment Share on other sites More sharing options...
dvale Posted May 28, 2011 Share 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 Link to comment Share on other sites More sharing options...
♥toyicebear Posted May 29, 2011 Share 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] Link to comment Share on other sites More sharing options...
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.