Forums / All Other Contributions/Addons / Stock by Attributes - use a prefix such as "zen_"

Stock by Attributes - use a prefix such as "zen_"

Locked

Started by imfsub12 on 9 Oct 2008, 7:07 PM · Views: 923

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
9 Oct 2008, 7:07 PM
#1
imfsub12 avatar

imfsub12

Zen Follower

Join Date:
Aug 2008
Location:
Halifax, NS
Posts:
274
Plugin Contributions:
0

Stock by Attributes - use a prefix such as "zen_"

Ok just trying to add this mod to my site..

Stock by Attributes v4.7a

And they are telling me if i have a prfix such as "zen_" i have to fix the .sql up.. HOW do i do this as this is my config file...

/ define our database connection
  define('DB_TYPE', 'mysql');
  define('DB_PREFIX', 'zen_');

and here is the stock_attribute.sql update file

CREATE TABLE products_with_attributes_stock (
        stock_id INT NOT NULL AUTO_INCREMENT ,
        products_id INT NOT NULL ,
        stock_attributes VARCHAR( 255 ) NOT NULL ,
        quantity FLOAT NOT NULL ,
        PRIMARY KEY ( `stock_id` )
        );

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, 
       configuration_description, configuration_group_id, sort_order, 
       last_modified, date_added, use_function, set_function) 
       VALUES ('Show available stock level in cart when less than order', 'STOCK_SHOW_LOW_IN_CART', 'false', 
               'When customer places more items in cart than are available, show the available amount on the shopping cart page:',
               '9',
               '6',
               NULL,
               now(),
               NULL,
               "zen_cfg_select_option(array('true', 'false'),"
       );

What do i DO???