mat123slade Posted April 25, 2004 Posted April 25, 2004 (edited) Hi, Just a simple question, I'm currently installing Quantity Controller v5.0. In the installation instructions, I have to update the products table structure as well as the products_attributes table structure. It is explained as follows : Database Changes: products table structure: 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-00 00:00:00? products_last_modified? datetime? Yes? NULL? products_date_available? datetime? Yes? 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? ? products_attributes table structure: products_attributes_id? int(11)? No? ? auto_increment products_id? int(11)? No? 0 options_id? int(11)? No? 0 options_values_id? int(11)? No? 0 options_values_price? decimal(15,4)? No? 0.0000 price_prefix? char(1)? No products_options_sort_order? int(11)? No? 0? ? Is there an easy way of updating it all at once ? or do I have to alter each info one after the other ? I've never seen this way of doing it before, it usually all comes as an sql file to import ! Thanx for the help. Edited April 25, 2004 by mat123slade Quote
Guest Posted April 25, 2004 Posted April 25, 2004 look for a file with the extension of sql and that is the one with all the statements to run to update the database Quote
mat123slade Posted April 25, 2004 Author Posted April 25, 2004 There is another problem I have come across with this contribution, once installed, I get the following error message on the catalog index : Fatal error: Call to undefined function: tep_not_null() in c:\program files\easyphp\www\bidon\includes\classes\language.php on line 74 I get the follwing error message in the admin when connecting to categories.php Fatal error: Call to undefined function: tep_array_merge() in c:\program files\easyphp\www\bidon\admin\categories.php on line 1058 Any idea ? Thanx. Quote
helply Posted July 27, 2004 Posted July 27, 2004 ever get any help on this. I dont want to waste my time trying to install this contrib if it isnt even working out of the box. thanks Quote
New 
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.