站点用户报告无法使用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
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() |