vanthinh129
New Member
huhu,e làm bị lỗi admin ơiUh.......tks nào....
MySQL báo:
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 'USING BTREE, KEY `user_activity` (`userid`,`lastactivity`) USING BTREE ) TYP' at line 53
Lỗi trong Lệnh truy xuất (Query):
CREATE TABLE `session` ( `sessionhash` char(32) NOT NULL DEFAULT '', `userid` int(10) unsigned NOT NULL DEFAULT '0', `host` char(15) NOT NULL DEFAULT '', `idhash` char(32) NOT NULL DEFAULT '', `lastactivity` int(10) unsigned NOT NULL DEFAULT '0', `location` char(255) NOT NULL DEFAULT '', `useragent` char(100) NOT NULL DEFAULT '', `styleid` smallint(5) unsigned NOT NULL DEFAULT '0', `languageid` smallint(5) unsigned NOT NULL DEFAULT '0', `loggedin` smallint(5) unsigned NOT NULL DEFAULT '0', `inforum` smallint(5) unsigned NOT NULL DEFAULT '0', `inthread` int(10) unsigned NOT NULL DEFAULT '0', `incalendar` smallint(5) unsigned NOT NULL DEFAULT '0', `badlocation` smallint(5) unsigned NOT NULL DEFAULT '0', `bypass` tinyint(4) NOT NULL DEFAULT '0', `profileupdate` smallint(5) unsigned NOT NULL DEFAULT '0', `apiclientid` int(10) unsigned NOT NULL DEFAULT '0', `apiaccesstoken` varchar(32) NOT NULL DEFAULT '', `topxtab` varchar(25) NOT NULL DEFAULT '0', `topxmenu` varchar(20) NOT NULL DEFAULT '0', `topxresult` int(3) NOT NULL DEFAULT '0', `isbot` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`sessionhash`), KEY `guest_lookup` (`idhash`,`host`,`userid`), KEY `apiaccesstoken` (`apiaccesstoken`), KEY `last_activity` (`lastactivity`) USING BTREE, KEY `user_activity` (`userid`,`lastactivity`) USING BTREE ) ENGINE=MEMORY DEFAULT CHARSET=latin1;
Fatal error: Couldn't create table or view `session´
Hình minh họa,admin xem dùm e,huhu
Attachments
Last edited: