5.0备份,恢复出现1064错误

我是从4.1升级到5.0
然后在5.0下备份数据,然后进行恢复就出现了这种错误.

1. 
   
2. Discuz! info: MySQL Query Error
   
3. 
   
4. User: admin
   
5. Time: 2006-10-19 1:42am
   
6. Script: /bbs/admincp.php
   
7. 
   
8. SQL: INSERT INTO cdb_posts VALUES ('2710','11','712','1','Onepiecefan','889','新人求助','1154542898','我對這些什麼SQL技術程式是一竅不通的,\r\n註冊發帖就是因為遇上了一個問題 =.=\r\n從7月25號左右吧\r\n我在另一個論壇 (風之動漫論壇) 就不能發圖了 (不能使用 [img] 代碼)\r\n以前都可以的\r\n要發圖會出現這個畫面:\r\n\r\n\r\n\r\nDiscuz! info: MySQL Query Error\r\n\r\nUser: ONEPIECEFAN\r\nTime: 2006-8-1 12:36pm\r\nScript: /post.php\r\n\r\nSQL: INSERT INTO cdb_threads (fid, readperm, price, iconid, typeid, author, authorid, subject, dateline, lastpost, lastposter, displayorder, digest, blog, poll, attachment, subscribed, moderated)\r\nVALUES (\'21\', \'0\', \'0\', \'0\', \'7\', \'ONEPIECEFAN\', \'90049\', \'咱的海賊\\\\', \'1154406983\', \'1154406983\', \'ONEPIECEFAN\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\')\r\nError: 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 \'1154406983\', \'1154406983\', \'ONEPIECEFAN\', \'0\', \'0\', \'0\', \'0\', \'\r\nErrno.: 1064\r\n\r\nAn error report has been dispatched to our administrator.\r\n\r\n\r\n\r\n\r\n看不懂...希望各位能夠幫助我','154.20.159.165','0','0','0','0','-1','-1','0','0','0','0')
   
9. 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 '\'1154406983\', \'1154406983\', \'ONEPIECEFAN\', \'0\', \'0\',
   
10. Errno.: 1064
    
11. 
    
12. Similar error report has beed dispatched to administrator before
    

复制代码

有什么解决办法啊?

问题应该就出在这儿'咱的海賊\\\\'，将它改成'咱的海賊\'试试

今天建一个表的时候,也出现这个错误,然后强制设置字符集为gbk就解决了

我的也差不多，从4.1升级到5.0后备份文件，在恢复的时候出现错误

Discuz! info: MySQL Query Error

User: admin
Time: 2006-10-20 1:17pm
Script: /dz/admincp.php

SQL: CREATE TABLE `cdb_access` ( `uid` mediumint(8) unsigned NOT NULL default '0', `fid` smallint(6) unsigned NOT NULL default '0', `allowview` tinyint(1) NOT NULL default '0', `allowpost` tinyint(1) NOT NULL default '0', `allowreply` tinyint(1) NOT NULL default '0', `allowgetattach` tinyint(1) NOT NULL default '0', `allowpostattach` tinyint(1) NOT NULL default '0', PRIMARY KEY (`uid`,`fid`)) ENGINE=MyISAM DEFAULT CHARSET=gbk
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 'DEFAULT CHARSET=gbk' at line 1
Errno.: 1064