再从5.0到4.0时出现这个错误！求救a !!! 帝国cms

帝国论坛 → 帝国软件产品与服务 → 帝国备份王 → 再从5.0到4.0时出现这个错误！求救a !!!

【本版专题贴子】

wowlion
用户头衔：书生

精华贴   ：0
发贴数   ：43
经验值   ：140
注册时间：2007-12-15

信息

搜索

好友

发送悄悄话

【精益求精－帝国网站管理系统7.5正式版开源发布】 [第 1 楼]

再从5.0到4.0时出现这个错误！求救a !!!

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 'collate gbk_bin NOT NULL default '', `ip1` tinyint(3) unsigne
CREATE TABLE `cdb_sessions` ( `sid` char(6) character set gbk collate gbk_bin NOT NULL default '', `ip1` tinyint(3) unsigned NOT NULL default '0', `ip2` tinyint(3) unsigned NOT NULL default '0', `ip3` tinyint(3) unsigned NOT NULL default '0', `ip4` tinyint(3) unsigned NOT NULL default '0', `uid` mediumint(8) unsigned NOT NULL default '0', `username` char(15) NOT NULL default '', `groupid` smallint(6) unsigned NOT NULL default '0', `styleid` smallint(6) unsigned NOT NULL default '0', `invisible` tinyint(1) NOT NULL default '0', `action` tinyint(1) unsigned NOT NULL default '0', `lastactivity` int(10) unsigned NOT NULL default '0', `lastolupdate` int(10) unsigned NOT NULL default '0', `pageviews` smallint(6) unsigned NOT NULL default '0', `seccode` mediumint(6) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `tid` mediumint(8) unsigned NOT NULL default '0', `bloguid` mediumint(8) unsigned NOT NULL default '0', UNIQUE KEY `sid` (`sid`), KEY `uid` (`uid`), KEY `bloguid` (`bloguid`) ) TYPE=MEMORY