• 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
  • Inviting everyone to the UX test of a new security feature in the WP Toolkit
    For WordPress site owners, threats posed by hackers are ever-present. Because of this, we are developing a new security feature for the WP Toolkit. If the topic of WordPress website security is relevant to you, we would be grateful if you could share your experience and help us test the usability of this feature. We invite you to join us for a 1-hour online session via Google Meet. Select a convenient meeting time with our friendly UX staff here.

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