Discuz!X3.1 Unknown column ‘conuintoken’ in ‘field list’错误的解决办法

2023-10-18 19:03:29 浏览数 (2)

DZ X3.1默认生成的数据库结构少2个字段,导致使用QQ登录论坛时提示以下错误:

Discuz! Database Error

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

REPLACE INTO common_connect_guest SET `conuintoken`=’094CBF68DFF643E75B8587DF2D8CC79F’ , `conopenid`=’DA2F64588087C12B89A2F358802CE241′ , `conqqnick`=’红红我最爱’

解决办法:执行以下两条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 '';

0 人点赞