How To Install Quantity Controller?

[jesse9201]

Hello,

 

I'm a newbie wanting to install "Quantity Controller 5.0, patches, etc" on to OScommerce 2.2 latest Feb. 2003 snapshot.

 

I can figure out how to modify/update the files included in the contribution, but do not know how to update the database.

 

I deleted the "products table structure" and "products_attribute table structure" in the database to substitute with the ones' included in Lindas "Q.C." readme file, but get this error:

 

Error

 

SQL-query :

 

CREATE TABLE products(

 

products_id int( 11 ) No auto_increment,

products_quantity int( 4 ) No 0,

products_model varchar( 12 ) Yes NULL ,

products_image varchar( 64 ) Yes NULL ,

products_bimage varchar( 64 ) Yes NULL ,

products_subimage1 varchar( 64 ) Yes NULL ,

products_bsubimage1 varchar( 64 ) Yes NULL ,

products_subimage2 varchar( 64 ) Yes NULL ,

products_bsubimage2 varchar( 64 ) Yes NULL ,

products_subimage3 varchar( 64 ) Yes NULL ,

products_bsubimage3 varchar( 64 ) Yes NULL ,

products_subimage4 varchar( 64 ) Yes NULL ,

products_bsubimage4 varchar( 64 ) Yes NULL ,

products_subimage5 varchar( 64 ) Yes NULL ,

products_bsubimage5 varchar( 64 ) Yes NULL ,

products_subimage6 varchar( 64 ) Yes NULL ,

products_bsubimage6 varchar( 64 ) Yes NULL ,

products_price decimal( 15, 4 ) No 0.0000,

products_date_added datetime No 0000 - 00 - 0000 : 00 : 00,

products_last_modified datetimeYes NULL ,

products_date_available datetimeYes NULL ,

products_weight decimal( 5, 2 ) No 0.00,

products_status tinyint( 1 ) No 0,

products_tax_class_id int( 11 ) No 0,

manufacturers_id int( 11 ) Yes NULL ,

products_ordered int( 11 ) No 0,

products_quantity_order_min int( 8 ) No 1,

products_quantity_order_units int( 8 ) No 1,

products_price_list decimal( 15, 4 ) No 0.0000,

products_price_rebate decimal( 15, 4 ) No 0.0000,

products_discount1 int( 6 ) No 0,

products_discount2 int( 6 ) No 0,

products_discount3 int( 6 ) No 0,

products_discount4 int( 6 ) No 0,

products_discount1_qty int( 6 ) No 0,

products_discount2_qty int( 6 ) No 0,

products_discount3_qty int( 6 ) No 0,

products_discount4_qty int( 6 ) No 0,

products_discounts_id int( 11 ) No 0,

PRIMARY KEY ( products_id ) ,

KEY idx_products_date_added( products_date_added )

)

 

MySQL said:

 

 

You have an error in your SQL syntax near 'No auto_increment,

products_quantity int(4) No 0,

products_model var' at line 2

 

Obviously, I don't have a clue :) Could someone help? Thanks in advance.

[jesse9201]

... I was using an old Quantity Controller! I went to Linda's site, downloaded the latest version 5.1, reinstalled my backed-up database and used the "database changes" Linda suggested. Voila! It's poifect! :)

 

Thanks Linda

[Ajeh]

Gee ... maybe I can update that one after all to do the new tricks. :shock:

 

Thanks for letting me know you got it loaded successfully on to the lates February 2003 snapshot.

 

There is hope yet for a new update in the future after all ... :onfire: