[求助]You have an error in your SQL syntax; check the manual that corresponds to y 帝国cms

帝国论坛 → 帝国软件产品与服务 → 帝国备份王 → [求助]You have an error in your SQL syntax; check the manual that corresponds to y

【本版专题贴子】

平淡0304
用户头衔：书生

精华贴   ：0
发贴数   ：1
经验值   ：9
注册时间：2015-05-16

信息

搜索

好友

发送悄悄话

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

[求助]You have an error in your SQL syntax; check the manual that corresponds to y

数据还原的时候遇见这样的错误，球高手指点。错误如下，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 ''???' at line 39
CREATE TABLE `destoon_ad` ( `aid` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL DEFAULT '', `pid` int(10) unsigned NOT NULL DEFAULT '0', `typeid` tinyint(1) unsigned NOT NULL DEFAULT '0', `areaid` int(10) unsigned NOT NULL DEFAULT '0', `amount` float NOT NULL DEFAULT '0', `currency` varchar(20) NOT NULL DEFAULT '', `url` varchar(255) NOT NULL DEFAULT '', `introduce` varchar(255) NOT NULL DEFAULT '', `hits` int(10) unsigned NOT NULL DEFAULT '0', `username` varchar(30) NOT NULL DEFAULT '', `addtime` int(10) unsigned NOT NULL DEFAULT '0', `editor` varchar(30) NOT NULL DEFAULT '', `edittime` int(10) unsigned NOT NULL DEFAULT '0', `fromtime` int(10) unsigned NOT NULL DEFAULT '0', `totime` int(10) unsigned NOT NULL DEFAULT '0', `stat` tinyint(1) unsigned NOT NULL DEFAULT '0', `note` text NOT NULL, `code` text NOT NULL, `text_name` varchar(100) NOT NULL DEFAULT '', `text_url` varchar(255) NOT NULL DEFAULT '', `text_title` varchar(100) NOT NULL DEFAULT '', `text_style` varchar(50) NOT NULL DEFAULT '', `image_src` varchar(255) NOT NULL DEFAULT '', `image_url` varchar(255) NOT NULL DEFAULT '', `image_alt` varchar(100) NOT NULL DEFAULT '', `flash_src` varchar(255) NOT NULL DEFAULT '', `flash_url` varchar(255) NOT NULL DEFAULT '', `flash_loop` tinyint(1) unsigned NOT NULL DEFAULT '1', `key_moduleid` smallint(6) unsigned NOT NULL DEFAULT '0', `key_catid` smallint(6) unsigned NOT NULL DEFAULT '0', `key_word` varchar(100) NOT NULL DEFAULT '', `key_id` bigint(20) unsigned NOT NULL DEFAULT '0', `listorder` smallint(4) unsigned NOT NULL DEFAULT '0', `status` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`aid`), KEY `pid` (`pid`) ) ENGINE=MyISAM AUTO_INCREMENT=175 DEFAULT CHARSET=gbk COMMENT='???