QQ互联出错解决办法:添加5个数据库表 (1.5-2.0升级后数据库没有QQ互联表)

今天我升级一个站点1.5到2.0最新时碰到个问题

.common_member_connect' doesn't exist
SELECT * FROM common_member_connect WHERE uid='1'

到数据库一看没有QQ互联的几个表 希望官方查下升级程序中是不是少了
经过一段收集 我把表都找齐全了
一样问题的朋友有救了 到后台一个个升级 吧
把pre改为你的表前缀。
然后在你数据库里检查是否存在以下的QQ互联的数据表（其中pre应该为你的表前缀）：
pre_common_member_connect、pre_connect_feedlog、pre_connect_memberbindlog、pre_connect_tlog、pre_common_uin_black

1. CREATE TABLE IF NOT EXISTS pre_common_member_connect (
   
2. `uid` mediumint(8) unsigned NOT NULL default '0',
   
3. `conuin` char(40) NOT NULL default '',
   
4. `conuinsecret` char(16) NOT NULL default '',
   
5. `conopenid` char(32) NOT NULL default '',
   
6. `conisfeed` tinyint(1) unsigned NOT NULL default '0',
   
7. `conispublishfeed` tinyint(1) unsigned NOT NULL default '0',
   
8. `conispublisht` tinyint(1) unsigned NOT NULL default '0',
   
9. `conisregister` tinyint(1) unsigned NOT NULL default '0',
   
10. `conisqzoneavatar` tinyint(1) unsigned NOT NULL default '0',
    
11. PRIMARY KEY (`uid`),
    
12. KEY `conuin` (`conuin`),
    
13. KEY `conopenid` (`conopenid`)
    
14. ) ENGINE=MyISAM;

复制代码

1. CREATE TABLE IF NOT EXISTS pre_connect_feedlog (
   
2. flid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   
3. tid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
4. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
5. publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
   
6. lastpublished int(10) unsigned NOT NULL DEFAULT '0',
   
7. dateline int(10) unsigned NOT NULL DEFAULT '0',
   
8. `status` tinyint(1) NOT NULL DEFAULT '1',
   
9. PRIMARY KEY (flid),
   
10. UNIQUE KEY tid (tid)
    
11. ) TYPE=MyISAM;

复制代码

1. CREATE TABLE IF NOT EXISTS pre_connect_tlog (
   
2. tlid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   
3. tid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
4. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
5. publishtimes mediumint(8) unsigned NOT NULL DEFAULT '0',
   
6. lastpublished int(10) unsigned NOT NULL DEFAULT '0',
   
7. dateline int(10) unsigned NOT NULL DEFAULT '0',
   
8. `status` tinyint(1) NOT NULL DEFAULT '1',
   
9. PRIMARY KEY (tlid),
   
10. UNIQUE KEY tid (tid)
    
11. ) TYPE=MyISAM;

复制代码

1. CREATE TABLE IF NOT EXISTS pre_connect_memberbindlog (
   
2. mblid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
   
3. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
4. uin char(40) NOT NULL,
   
5. `type` tinyint(1) NOT NULL DEFAULT '0',
   
6. dateline int(10) unsigned NOT NULL DEFAULT '0',
   
7. PRIMARY KEY (mblid),
   
8. KEY uid (uid),
   
9. KEY uin (uin),
   
10. KEY dateline (dateline)
    
11. ) TYPE=MyISAM;

复制代码

1. CREATE TABLE IF NOT EXISTS pre_common_uin_black (
   
2. uin char(40) NOT NULL,
   
3. uid mediumint(8) unsigned NOT NULL DEFAULT '0',
   
4. dateline int(10) unsigned NOT NULL DEFAULT '0',
   
5. PRIMARY KEY (uin),
   
6. UNIQUE KEY uid (uid)
   
7. ) TYPE=MyISAM;

复制代码

谢谢分享

升级X1.5到X2的教程是：
https://discuz.dismall.com/thread-2179010-1-1.html
如果你按照这个教程步骤升级的话，那些表在升级的过程中会建立的