Hi,
i have installed all the files as per instructions (i hope), i then ran the script file (from 4.7 multiadd) to create the table, but i get the following error. the tables also do not seem to be created.
Code:
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; INSERT INTO configuration (configuration_title, configuration_key, configur' at line 7
in:
[CREATE TABLE zen_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')," );]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
any help would be appreciated.
thanks
shoulders
Bookmarks