数据库导入时出错You have an error in your SQL syntax; check the manual

yihan222

备份还是正常的，导入数据库时，出现严重错误，试过其他解决途径，用帝国也试过，均不行，还是同样的错误，如何解决啊，急求！！！之前一直正常，但最近升级过两次destoon内核，所以就出错了！
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 `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=17 DEFAULT CHARSET=gbk COMMENT='???

duoluozhe

''???'引号问题，不规则

yihan222

duoluozhe 发表于 2013-12-18 16:44

''???'引号问题，不规则
亲，没分析到点子上哦

yihan222

伙伴们，遇到过这种问题的帮忙分析分析！

yihan222

MySQL Query:CREATE TABLE `[pre]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=17 DEFAULT CHARSET=gbk COMMENT='???
MySQL Error: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 1 MySQL Errno:0
Message:MySQL Query Error

yihan222

哪位大神指导下！！！

Spacer

直接去备份的sql文件里面去 把这块修改下 备份的文件在file/backup/下 应该是1.sql

最后一句 COMMENT='???修改成COMMENT='广告';

然后再恢复试试

yihan222

Spacer 发表于 2013-12-24 08:57

直接去备份的sql文件里面去 把这块修改下 备份的文件在file/backup/下 应该是1.sql

最后一句 COMMENT='??? ...
依照君的指点，试了几遍，错误依旧
MySQL Query:CREATE TABLE `[pre]announce` ( `itemid` int(10) unsigned NOT NULL auto_increment, `typeid` int(10) unsigned NOT NULL default '0', `areaid` int(10) unsigned NOT NULL default '0', `level` tinyint(1) unsigned NOT NULL default '0', `title` varchar(100) NOT NULL default '', `style` varchar(50) NOT NULL default '', `content` text NOT NULL, `hits` int(10) unsigned NOT NULL default '0', `addtime` int(10) unsigned NOT NULL default '0', `fromtime` int(10) unsigned NOT NULL default '0', `totime` int(10) unsigned NOT NULL default '0', `editor` varchar(30) NOT NULL default '', `edittime` int(10) unsigned NOT NULL default '0', `islink` tinyint(1) unsigned NOT NULL default '0', `linkurl` varchar(255) NOT NULL default '', `listorder` smallint(4) unsigned NOT NULL default '0', `template` varchar(30) NOT NULL default '', PRIMARY KEY (`itemid`), KEY `addtime` (`addtime`)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk COMMENT='???
MySQL Error: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 1 MySQL Errno:0
Message:MySQL Query Error

Spacer

yihan222 发表于 2013-12-24 15:59

依照君的指点，试了几遍，错误依旧
MySQL Query:CREATE TABLE `announce` ( `itemid` int(10) unsigned N ...

COMMENT='ad';试试 这个是创建一个表的时候 给表加的注释，  你修改你想要恢复的备份文件里面的1.sql里的这句
然后恢复这个。

yihan222

Spacer 发表于 2013-12-24 17:22

COMMENT='ad';试试 这个是创建一个表的时候 给表加的注释，  你修改你想要恢复的备份文件里面的1.sql里的 ...
非常感谢君的热心分析，理解君表达的意思，这种修改方法我上午已经尝试过，依然出现同样的错误，现在的问题大致是：备份数据库后，就无法恢复了，一恢复就显示此类错误。（destoon自带的备份工具、mysql直接操作、已经通过第三方的帝国备份等工具，全部都是同样的错误）