数据库1146错误，我在安装英文版uch2.0后，访问域名/space.php?do=pm出现如下错误

UCenter info: MySQL Query Error
SQL:SELECT count(*) FROM [Table]pms WHERE msgtoid='1' AND related='0' AND msgfromid>'0' AND folder='inbox'
Error:Table 'a0205205355.uc_pms' doesn't exist
Errno:1146

ok了，执行下面的语句就ok

1. DROP TABLE IF EXISTS uc_pms;
   
2. CREATE TABLE uc_pms (
   
3. pmid int(10) unsigned NOT NULL auto_increment,
   
4. msgfrom varchar(15) NOT NULL default '',
   
5. msgfromid mediumint(8) unsigned NOT NULL default '0',
   
6. msgtoid mediumint(8) unsigned NOT NULL default '0',
   
7. folder enum('inbox','outbox') NOT NULL default 'inbox',
   
8. new tinyint(1) NOT NULL default '0',
   
9. subject varchar(75) NOT NULL default '',
   
10. dateline int(10) unsigned NOT NULL default '0',
    
11. message text NOT NULL,
    
12. delstatus tinyint(1) unsigned NOT NULL default '0',
    
13. related int(10) unsigned NOT NULL default '0',
    
14. PRIMARY KEY(pmid),
    
15. KEY msgtoid(msgtoid,folder,dateline),
    
16. KEY msgfromid(msgfromid,folder,dateline),
    
17. KEY related (related),
    
18. KEY getnum (msgtoid,folder,delstatus)
    
19. ) TYPE=MyISAM;

复制代码

哥，太给力了。我的就是这个错误。根据你的方法，解决了 。  
        赞！！