• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Question Wrong attributes for the column 'login' in the table 'sys_users'

Dukemaster

Regular Pleskian
Hi,
since long time I had no errors by running: # plesk repair all -n
After testing today I got the following error under section Checking the structure of the Plesk database
Code:
Wrong attributes for the column 'login' in the table 'sys_users': . [ERROR]
    - The attribute 'type' value mismatch: varchar(32) in the
      original schema and varchar(20) in the Plesk database.

Do you have an idea how to fix it?

(To prevent greater damage or getting no access to server/database)
Greets
 
Make sure that you have varchar(20) here:

Screenshot at Apr 19 09-58-55.png

You can correct it with

Code:
mysql> alter table sys_users modify login VARCHAR (32) NOT NULL;

but I thought that

Code:
# plesk repair db

should fix it too.
 
Back
Top