7.2 开通QQ互联出现的问题MySQL Query Error

Discuz! info: MySQL Query Error

User: seeker908

Time: 2011-10-25 5:02pm
Script: /bbs/index.php

SQL: SELECT conisbind FROM [Table]members WHERE uid='1'
Error: Unknown column 'conisbind' in 'field list'
Errno.: 1054

Similar error report has been dispatched to administrator before.

怎么解决呢？

1. ALTER TABLE `cdb_members` ADD `conisbind` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX (`conisbind`);

复制代码

在数据库里执行下这个sql，把其中的cdb改为你的表前缀

ALTER TABLE `cdb_members` ADD `conisbind` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX (`conisbind`);

运行后出现
升级错误，MySQL 提示: Can't create table '#sql-1eaa_9342' (errno: 13) ，请返回。

seeker908 发表于 2011-10-25 17:34
ALTER TABLE `cdb_members` ADD `conisbind` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', ADD INDEX (`co ...

http://blog.csdn.net/solaris_navi/article/details/5854635
试试这个