Closed (fixed)
Project:
Inventory Management
Version:
4.7.x-1.1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Reporter:
Created:
12 Nov 2006 at 10:32 UTC
Updated:
28 Nov 2006 at 09:45 UTC
Hi
the above table does not install. Here the error code ...
SQL query:
CREATE TABLE {ec_product_item_sub_class}(
id int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
itemclassid int( 10 ) unsign NOT NULL ,
name varchar( 255 ) NOT NULL default '0',
PRIMARY KEY ( id )
) TYPE = MYISAM ;
MySQL said: Documentation
#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 '{ec_product_item_sub_class} (
id int(10) unsigned NOT NULL AUTO_INCREME' at line 1
Comments
Comment #1
schultzconsult commentedComment #2
schultzconsult commentedMissing default value for itemclassid in ec_product_item_sub_class table is corrected.
Comment #3
(not verified) commented