Quote
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 'TYPE=MyISAM' at line 9
Quote
$inf_newtable[1] = ".YOUR_DB_NAME." (
config_id VARCHAR(64) NOT NULL,
project_id INTEGER NOT NULL DEFAULT 0,
user_id INTEGER NOT NULL DEFAULT 0,
access_reqd INTEGER DEFAULT 0,
type INTEGER DEFAULT 90,
value LONGTEXT NOT NULL,
PRIMARY KEY (config_id, project_id, user_id)
) TYPE=MyISAM;
Quote
$inf_newtable[1] = ".YOUR_DB_NAME." (
config_id VARCHAR(64) NOT NULL,
project_id INTEGER NOT NULL DEFAULT 0,
user_id INTEGER NOT NULL DEFAULT 0,
access_reqd INTEGER DEFAULT 0,
type INTEGER DEFAULT 90,
value LONGTEXT NOT NULL,
PRIMARY KEY (config_id, project_id, user_id)
) ENGINE=MyISAM;
Quote
TYPE keyword is depreciated (since 5.0) and not supported in MySQL5.5
Category Forum
Panels and InfusionsLabels
None yet
Statistics
1 participant
Notifications
You are not receiving notifications from this thread.
Related Questions