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.FileLineCode
1connect.php40require_once(%s)
2source/plugin/qqconnect/connect/connect_login.php226discuz_table->insert(Array)
3source/class/discuz/discuz_table.php81discuz_database::insert(%s, Array, false, false, false)
4source/class/discuz/discuz_database.php60discuz_database::query(%s, %s, %s, true)
5source/class/discuz/discuz_database.php136db_driver_mysql->query(%s, %s, true)
6source/class/db/db_driver_mysql.php153db_driver_mysql->halt(%s, %d, %s)
7source/class/db/db_driver_mysql.php224break()
有用(0) 打赏

转载或引用请注明出处: Super Mouse

[标题:DiscuzX3.2错误(1054) Unknown Column ‘Conuintoken’ In ‘Field List’ 引用链接:https://blog.lsza.net/archives/361.html]

留下您的评论 抢沙发

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

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏