开启QQ互联后出现connect_memberbindlog' doesn't exist 错误

Discuz! Database Error

The database has encountered a problem. Need Help?

Error messages:

[Type] 查询语句错误 [1146] Table 'bbs3.connect_memberbindlog' doesn't exist [Query] SELECT COUNT(DISTINCT uid) FROM connect_memberbindlog WHERE uin='f6f0706aa8bb6bc20e420b5430896a04' AND type='1'

Program messages:

[Line: 0014]connect.php(require_once) [Line: 0037]member.php(require) [Line: 0052]source\module\member\member_connect.php(DB::result_first)

我刚测试了下， 用QQ号绑定老用户，没问题，
但是新QQ号注册，进行互联，就会出现这个问题。
谢谢了。

登录你数据库，手动运行sql语句添加表：

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;

复制代码

好的。非常感谢。 我试试

搞定。谢谢