Solution to Discuz X3.1 QQ Connect login error

After installing X3.1, QQ互联 login shows (1054) Unknown column 'conuintoken' in 'field list', the specific screenshot is as follows:

The reason is that when logging in with QQ, your account information is written into the data table common_member_connect, and this statement contains conuintoken

this field, but the data table common_member_connect does not have it, so an error is reported.

Solution:

1. Log in to FTP, modify the config/config_global.php file

Add the following code under the CONFIG ADMINCP item (if this line of code already exists, change '0' to 1):

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

2. Log in to the discuz backend——Webmaster——Database——Upgrade, paste the following code and submit:

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

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

Note: If the data table prefix is not the default pre, please change pre in the above code to the corresponding table prefix

3. Log out of the administrator account, and log in again with QQ互联 to test.

If step 2 above cannot be executed or there are other errors, please try to execute it in phpmyadmin:

In the hosting control panel, click the database button on the left, then click Manage mysql Online

After opening phpmyadmin management, select your own database, click SQL, enter the command in it, then click the execute button to execute.