On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at MyPlesk.com/Plesk360/Platform360 please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Articles in this section

See more

Unable to create website configuration in Plesk with the error: Unable to load object of type SysUser with id

Avatar
Leonid Gukhman
Updated
Follow
Plesk for Linux kb: technical ABT: Group A

Applicable to:

  • Plesk for Linux

Symptoms

  • The following error message is shown on the home page of Plesk:

    PLESK_ERROR: New configuration files for the Apache web server were not created due to the errors in configuration templates: Template processing failed: file = /opt/psa/admin/conf/templates/default/domainVhostIpDefault.php, error = Template_Exception: Unable to load object of type SysUser with id=26: SysUser: unable to select: no such row in the table file: /opt/psa/admin/plib/Template/Processor.php line: 28 code: 0 Previous error: Template_Exception: Unable to load object of type SysUser with id=26: SysUser: unable to select: no such row in the table file: /opt/psa/admin/plib/Template/Processor.php line: 28 code: 0 Previous error: PleskDBException: Unable to load object of type SysUser with id=26: SysUser: unable to select: no such row in the table file: /opt/psa/admin/plib/functions.php line: 1627 code: 0. Detailed error descriptions were sent to you by email.

  • The following error is found in migration log /usr/local/psa/var/modules/panel-migrator/sessions/<datetime>/debug.log:

    CONFIG_TEXT: =|2021-05-20_17:28:55,208|D|ST1|core.runners.base|example.com||stderr: Unable to load object of type SysUser with id=2: SysUser: unable to select: No such row in the table
    ...
    =|...|D|ST1|core.safe|example.com||MultipleAttemptsMigrationError: Migration tools tried to perform operation in 3 attempts: 'username'
    +|...|E|ST1|core.safe|example.com||Failed to perform an action on subscription 'example.com': Failed to deploy subscription 'example.com'
    =|...|E|ST1|core.safe|example.com||Migration for that subscription is considered completely failed. No further actions are performed for it. Exception message: Migration tools tried to perform operation in 3 attempts: 'username'

  • On the Subscriptions list, one subscription is marked as broken.

  • The utility plesk repair web returns an error:

    # plesk repair web example.com
    Unable to load object of type SysUser with id=26: SysUser: unable to select: no such row in the table

Cause

Database inconsistency: there is an orphaned record in the table sys_users .

Resolution

  1. Connect to the server via SSH.

  2. Create a backup of psa database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > /root/psa_backup.sql

  3. Run plesk repair db to fix the database inconsistency:

    # plesk repair db -y

    OR
    Proceed with the

below steps

  1. List all web users from the table web_users that are under the domain example.com :

    MYSQL_LIN: select w.id, w.dom_id, w.sys_user_id from web_users as w join domains as d where d.id=w.dom_id and d.name='example.com';
    +----+--------+-------------+
    | id | dom_id | sys_user_id |
    +----+--------+-------------+
    | 1 | 5 | 26 |
    | 2 | 5 | 30 |
    | 3 | 5 | 31 |
    +----+--------+-------------+

  2. List all web users from the table sys_users that are under the domain example.com :

    MYSQL_LIN: mysql> select id, login from sys_users where id in (select w.sys_user_id from web_users as w join domains as d where d.id=w.dom_id and d.name='example.com');
    +----+-----------+
    | id | login |
    +----+-----------+
    | 30 | web_user1 |
    | 31 | web_user2 |
    +----+-----------+
    2 rows in set (0.00 sec)

  3. Check current web users in Plesk at Domains > example.com > Web Users - there are only two of them: web_user1 and web_user2.

  4. Remove the invalid record:

    MYSQL_LIN: delete from web_users where id=1;

  1. Repair the website example.com :

    # plesk repair web example.com
    Repairing web server configuration
    Repairing web server configuration for the domain example.com ........................................... [OK]
    Error messages: 0; Warnings: 0; Errors resolved: 0

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles