Discuz! Database Error (1054) Unknown column

2015-7-18 15:46| 发布者: 鬼王潮| 查看: 1826| 评论: 1

摘要: （1054) Unknown column 'conuintoken' in 'field list' REPLACE INTO common_connect_guest SET `conuintoken`='EEEEBB43231140FD85706BB31A76E9B8' , `conopenid`='733832A0B789AC6BD1BFB60E734CA12B' , `conqqni ...

Discuz!x3.2 全新安装后QQ互联无法登录，出现如下错误：

Discuz! Database Error

(1054) Unknown column 'conuintoken' in 'field list'

REPLACE INTO common_connect_guest SET `conuintoken`='EEEEBB43231140FD85706BB31A76E9B8' , `conopenid`='733832A0B789AC6BD1BFB60E734CA12B' , `conqqnick`='Jun'

PHP Debug

No.	File	Line	Code
1	connect.php	40	require_once(%s)
2	source/plugin/qqconnect/connect/connect_login.php	353	discuz_table->insert(Array, false, true)
3	source/class/discuz/discuz_table.php	81	discuz_database::insert(%s, Array, false, true, false)
4	source/class/discuz/discuz_database.php	60	discuz_database::query(%s, %s, %s, true)
5	source/class/discuz/discuz_database.php	136	db_driver_mysql->query(%s, %s, true)
6	source/class/db/db_driver_mysql.php	153	db_driver_mysql->halt(%s, %d, %s)
7	source/class/db/db_driver_mysql.php	224	break()

数据表common_member_connect少了一个字段conuintoken。添加好就行，字段约束为char（32）。

简单的修复方法为：

1、修改config/config_global.php文件查找下面代码把0改为1，开启后台直接运行SQL

$_config['admincp']['runquery'] = '0';

　2、在后台后台——站长——数据库——升级，粘贴以下代码提交：

ALTER TABLE `pre_common_member_connect` ADD COLUMN conuintoken char(32) NOT NULL DEFAULT '';
ALTER TABLE `pre_common_connect_guest` ADD COLUMN conuintoken char(32) NOT NULL DEFAULT '';

注意：如果你的数据表前缀不是默认的pre，请改为相应的表前缀