還原錯誤

今天使用2007/07/10備份檔還原Discuz5.5+Xpace3.02,出現下面錯誤

1. 
   
2. Error at the line 2546: ) TYPE=MyISAM;
   
3. 
   
4. Query: -- -- DROP TABLE IF EXISTS `supe__'`; CREATE TABLE supe__' ( cachekey varchar(16) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', cachename varchar(20) NOT NULL default '', value mediumtext NOT NULL, updatetime int(10) unsigned NOT NULL default '0', PRIMARY KEY (cachekey) ) TYPE=MyISAM;
   
5. 
   
6. MySQL: 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 '; CREATE TABLE supe__' ( cachekey varchar(16) NOT NULL defaul
   
7. 
   
8. Stopped on error
   

复制代码

打開2007/06/15備份檔(Disucz5.5+Xpace2)來還原沒有錯誤。

這期間，我只有升級Xpace，判斷Xpace3匯出有錯誤

1. supe__'

复制代码

要改成

1. supe__

复制代码

如果換資料庫名稱也會錯誤

要打開cdb_settings資料表，自己將內容修改成新資料庫名稱

换资料库也会错误啥意思？

您可以将ss地址、管理员帐号
phpmyadmin地址、登录帐号pm我检查下

搬主機，換資料庫名稱/網址，都會出現錯誤。

Error at the line 2546: ) TYPE=MyISAM;

Query: -- -- DROP TABLE IF EXISTS `supe__'`; CREATE TABLE supe__' ( cachekey varchar(16) NOT NULL default '', uid mediumint(8) unsigned NOT NULL default '0', cachename varchar(20) NOT NULL default '', value mediumtext NOT NULL, updatetime int(10) unsigned NOT NULL default '0', PRIMARY KEY (cachekey) ) TYPE=MyISAM;
MySQL: 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 '; CREATE TABLE supe__' ( cachekey varchar(16) NOT NULL defaul

Stopped on error

修復動作

1. supe__'

复制代码

改成

1. supe__

复制代码

資料表cdb_settings
variable

1. supe_tablepre

复制代码

value

1. dbname.supe_

复制代码

variable

1. supe

复制代码

value

1. 
   
2. a:13:{s:6:"dbmode";s:1:"0";s:6:"dbhost";s:0:"";s:6:"dbuser";s:0:"";s:4:"dbpw";s:0:"";s:6:"dbname";s:0:"";s:6:"status";s:1:"1";s:8:"tablepre";s:21:"dbname.supe_";s:7:"siteurl";s:25:"http://domain/space";s:8:"sitename";s:19:"X-Space入口";s:14:"maxupdateusers";i:0;s:5:"items";a:1:{s:6:"status";i:0;}s:12:"circlestatus";s:1:"1";s:9:"attachurl";s:37:"http://domain/space/attachments";}
   

复制代码

domain=我替換過，不想暴露真正網址

如沒修改資料表cdb_settings，會有下面錯誤

index.php Error

1. 
   
2. Discuz! info: MySQL Query Error
   
3. 
   
4. User: Porsche
   
5. Time: 2007-7-13 2:23am
   
6. Script: /D55/index.php
   
7. 
   
8. SQL: SELECT gid, uid, username, groupname, logo, usernum, lastpost FROM dbname.supe_groups WHERE catid>0 AND flag=1 ORDER BY lastpost DESC LIMIT 8
   
9. Error: Table 'dbname.supe_groups' doesn't exist
   
10. [color=Red]数据表缺失,请恢复备份数据[/color]
    
11. 
    

复制代码

这样，将您的ss地址、管理员帐号
ftp地址、登录帐号
phpmyadmin地址、登录帐号pm我

请在pm中说明您的具体的操作和出错现象，我们检查下