Super Mouse
代码如诗-人生如画

DiscuzX3.2错误(1054) Unknown Column ‘Conuintoken’ In ‘Field List’

站点用户报告无法使用QQ账号登录到Ruihucn.com提示错误:(1054) Unknown column ‘conuintoken’ in ‘field list’

查阅相关的技术支持文档:

1、修改config/config_global.php文件查找下面代码把0改为1,开启后台直接运行SQL
$_config['admincp']['runquery'] = '0';

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

alter table pre_common_member_connect add conuintoken char(32) not null;
alter table pre_common_connect_guest add conuintoken char(32) not null;

结果并无作用,查阅QQ互联http://wiki.connect.qq.com 并咨询一好友解决这问题了
开启QQ互联,绑定后,提示(1054) Unknown column ‘conuintoken’ in ‘field list’的解决方案如下:
用phpmyadmin执行sql
打开phpmyadmin,选择论坛的数据库, 点击 sql功能,输入以下句子运行:(其中的 pre_ 为你论坛数据库的表前缀,如果不是默认的,请注意修改)

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 '';

完整的错误提示:

Discuz! Database Error

(1054) Unknown column ‘conuintoken’ in ‘field list’

INSERT INTO common_member_connect SET uid=’1′ , conuin=” , conuintoken=’x’ , conopenid=’x’ , conispublishfeed=’0′ , conispublisht=’0′ , conisregister=’0′ , conisfeed=’1′ , conisqqshow=’0′

PHP Debug

No. File Line Code
1 connect.php 40 require_once(%s)
2 source/plugin/qqconnect/connect/connect_login.php 226 discuz_table->insert(Array)
3 source/class/discuz/discuz_table.php 81 discuz_database::insert(%s, Array, false, false, 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()
赞(0)
未经允许不得转载:Super Mouse » DiscuzX3.2错误(1054) Unknown Column ‘Conuintoken’ In ‘Field List’

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

我将孤身一人,高举火把,行于众人之前,探索黑暗,无所畏惧。