1.5升级2.0后 求各位高手帮帮我！！！！

我等了一晚上 还没动静我以为应该是处理完了  我现在要怎么办啊   我以前的数据可以不要 要我现在创建么？

怎么没人帮我啊

哇 这个我没遇到过 估计不经常见得问题  俺要在这里好好学习了

网站解决了   我建了2个表

1. 
   
2. 第一个：
   
3. DROP TABLE IF EXISTS uc_pm_members;
   
4. CREATE TABLE uc_pm_members (
   
5.   plid mediumint(8) unsigned NOT NULL default '0',
   
6.   uid mediumint(8) unsigned NOT NULL default '0',
   
7.   isnew tinyint(1) unsigned NOT NULL default '0',
   
8.   pmnum int(10) unsigned NOT NULL default '0',
   
9.   lastupdate int(10) unsigned NOT NULL default '0',
   
10.   lastdateline int(10) unsigned NOT NULL default '0',
    
11.   PRIMARY KEY  (plid,uid),
    
12.   KEY isnew (isnew),
    
13.   KEY lastdateline (uid,lastdateline),
    
14.   KEY lastupdate (uid,lastupdate)
    
15. ) TYPE=MyISAM;
    
16. 
    
17. 
    
18. 
    
19. 第二个：
    
20. DROP TABLE IF EXISTS uc_pm_lists;
    
21. CREATE TABLE uc_pm_lists (
    
22.   plid mediumint(8) unsigned NOT NULL auto_increment,
    
23.   authorid mediumint(8) unsigned NOT NULL default '0',
    
24.   pmtype tinyint(1) unsigned NOT NULL default '0',
    
25.   subject varchar(80) NOT NULL,
    
26.   members smallint(5) unsigned NOT NULL default '0',
    
27.   min_max varchar(17) NOT NULL,
    
28.   dateline int(10) unsigned NOT NULL default '0',
    
29.   lastmessage text NOT NULL,
    
30.   PRIMARY KEY  (plid),
    
31.   KEY pmtype (pmtype),
    
32.   KEY min_max (min_max),
    
33.   KEY authorid (authorid,dateline)
    
34. ) TYPE=MyISAM;

复制代码

还有我要多谢哪位朋友指导了我  谢谢老大 呵呵！！！！

在依次建设这 10个数据表

1. DROP TABLE IF EXISTS uc_pm_messages_0;
   
2. CREATE TABLE uc_pm_messages_0 (
   
3.   pmid mediumint(8) unsigned NOT NULL default '0',
   
4.   plid mediumint(8) unsigned NOT NULL default '0',
   
5.   authorid mediumint(8) unsigned NOT NULL default '0',
   
6.   message text NOT NULL,
   
7.   delstatus tinyint(1) unsigned NOT NULL default '0',
   
8.   dateline int(10) unsigned NOT NULL default '0',
   
9.   PRIMARY KEY  (pmid),
   
10.   KEY plid (plid,delstatus,dateline),
    
11.   KEY dateline (plid,dateline)
    
12. ) TYPE=MyISAM;
    
13. 
    
14. DROP TABLE IF EXISTS uc_pm_messages_1;
    
15. CREATE TABLE uc_pm_messages_1 (
    
16.   pmid mediumint(8) unsigned NOT NULL default '0',
    
17.   plid mediumint(8) unsigned NOT NULL default '0',
    
18.   authorid mediumint(8) unsigned NOT NULL default '0',
    
19.   message text NOT NULL,
    
20.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
21.   dateline int(10) unsigned NOT NULL default '0',
    
22.   PRIMARY KEY  (pmid),
    
23.   KEY plid (plid,delstatus,dateline),
    
24.   KEY dateline (plid,dateline)
    
25. ) TYPE=MyISAM;
    
26. 
    
27. DROP TABLE IF EXISTS uc_pm_messages_2;
    
28. CREATE TABLE uc_pm_messages_2 (
    
29.   pmid mediumint(8) unsigned NOT NULL default '0',
    
30.   plid mediumint(8) unsigned NOT NULL default '0',
    
31.   authorid mediumint(8) unsigned NOT NULL default '0',
    
32.   message text NOT NULL,
    
33.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
34.   dateline int(10) unsigned NOT NULL default '0',
    
35.   PRIMARY KEY  (pmid),
    
36.   KEY plid (plid,delstatus,dateline),
    
37.   KEY dateline (plid,dateline)
    
38. ) TYPE=MyISAM;
    
39. 
    
40. DROP TABLE IF EXISTS uc_pm_messages_3;
    
41. CREATE TABLE uc_pm_messages_3 (
    
42.   pmid mediumint(8) unsigned NOT NULL default '0',
    
43.   plid mediumint(8) unsigned NOT NULL default '0',
    
44.   authorid mediumint(8) unsigned NOT NULL default '0',
    
45.   message text NOT NULL,
    
46.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
47.   dateline int(10) unsigned NOT NULL default '0',
    
48.   PRIMARY KEY  (pmid),
    
49.   KEY plid (plid,delstatus,dateline),
    
50.   KEY dateline (plid,dateline)
    
51. ) TYPE=MyISAM;
    
52. 
    
53. DROP TABLE IF EXISTS uc_pm_messages_4;
    
54. CREATE TABLE uc_pm_messages_4 (
    
55.   pmid mediumint(8) unsigned NOT NULL default '0',
    
56.   plid mediumint(8) unsigned NOT NULL default '0',
    
57.   authorid mediumint(8) unsigned NOT NULL default '0',
    
58.   message text NOT NULL,
    
59.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
60.   dateline int(10) unsigned NOT NULL default '0',
    
61.   PRIMARY KEY  (pmid),
    
62.   KEY plid (plid,delstatus,dateline),
    
63.   KEY dateline (plid,dateline)
    
64. ) TYPE=MyISAM;
    
65. 
    
66. DROP TABLE IF EXISTS uc_pm_messages_5;
    
67. CREATE TABLE uc_pm_messages_5 (
    
68.   pmid mediumint(8) unsigned NOT NULL default '0',
    
69.   plid mediumint(8) unsigned NOT NULL default '0',
    
70.   authorid mediumint(8) unsigned NOT NULL default '0',
    
71.   message text NOT NULL,
    
72.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
73.   dateline int(10) unsigned NOT NULL default '0',
    
74.   PRIMARY KEY  (pmid),
    
75.   KEY plid (plid,delstatus,dateline),
    
76.   KEY dateline (plid,dateline)
    
77. ) TYPE=MyISAM;
    
78. 
    
79. DROP TABLE IF EXISTS uc_pm_messages_6;
    
80. CREATE TABLE uc_pm_messages_6 (
    
81.   pmid mediumint(8) unsigned NOT NULL default '0',
    
82.   plid mediumint(8) unsigned NOT NULL default '0',
    
83.   authorid mediumint(8) unsigned NOT NULL default '0',
    
84.   message text NOT NULL,
    
85.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
86.   dateline int(10) unsigned NOT NULL default '0',
    
87.   PRIMARY KEY  (pmid),
    
88.   KEY plid (plid,delstatus,dateline),
    
89.   KEY dateline (plid,dateline)
    
90. ) TYPE=MyISAM;
    
91. 
    
92. DROP TABLE IF EXISTS uc_pm_messages_7;
    
93. CREATE TABLE uc_pm_messages_7 (
    
94.   pmid mediumint(8) unsigned NOT NULL default '0',
    
95.   plid mediumint(8) unsigned NOT NULL default '0',
    
96.   authorid mediumint(8) unsigned NOT NULL default '0',
    
97.   message text NOT NULL,
    
98.   delstatus tinyint(1) unsigned NOT NULL default '0',
    
99.   dateline int(10) unsigned NOT NULL default '0',
    
100.   PRIMARY KEY  (pmid),
     
101.   KEY plid (plid,delstatus,dateline),
     
102.   KEY dateline (plid,dateline)
     
103. ) TYPE=MyISAM;
     
104. 
     
105. DROP TABLE IF EXISTS uc_pm_messages_8;
     
106. CREATE TABLE uc_pm_messages_8 (
     
107.   pmid mediumint(8) unsigned NOT NULL default '0',
     
108.   plid mediumint(8) unsigned NOT NULL default '0',
     
109.   authorid mediumint(8) unsigned NOT NULL default '0',
     
110.   message text NOT NULL,
     
111.   delstatus tinyint(1) unsigned NOT NULL default '0',
     
112.   dateline int(10) unsigned NOT NULL default '0',
     
113.   PRIMARY KEY  (pmid),
     
114.   KEY plid (plid,delstatus,dateline),
     
115.   KEY dateline (plid,dateline)
     
116. ) TYPE=MyISAM;
     
117. 
     
118. DROP TABLE IF EXISTS uc_pm_messages_9;
     
119. CREATE TABLE uc_pm_messages_9 (
     
120.   pmid mediumint(8) unsigned NOT NULL default '0',
     
121.   plid mediumint(8) unsigned NOT NULL default '0',
     
122.   authorid mediumint(8) unsigned NOT NULL default '0',
     
123.   message text NOT NULL,
     
124.   delstatus tinyint(1) unsigned NOT NULL default '0',
     
125.   dateline int(10) unsigned NOT NULL default '0',
     
126.   PRIMARY KEY  (pmid),
     
127.   KEY plid (plid,delstatus,dateline),
     
128.   KEY dateline (plid,dateline)
     
129. ) TYPE=MyISAM;

复制代码

提示你缺哪个表你创建哪个表的时候 要将它设为你数据库的名的！！！  

表名前缀要和您的 UCenter 数据库的表名前缀一致，比如你的 UCenter 数据库表名前缀是 xxxuc，那么一定要把 SQL 语句中的 uc_pms 修改为 xxxuc_pms 再执行。

zzhijcy 发表于 2011-11-19 02:36
如果需要可以联系我

谢谢你 现在解决了，以后再有什么问题会找你的 ！！！！