Can't enter to FTP access tab: Unable to load object of type SysUser with id

Created:

2016-11-16 12:49:36 UTC

Modified:

2017-04-24 12:10:33 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Can't enter to FTP access tab: Unable to load object of type SysUser with id

Applicable to:

  • Plesk 11.5 for Linux

Symptoms

Can not enter to FTP access tab for domain 'example.com', the following error is shown:

Unable to load object of type SysUser with id=399: SysUser: unable to select: no such row in the table

Cause

Database inconsistency

Resolution

  1. Backup psa database

  2. Find affected record in ftp_users table, 'example.com' should be substituted with affected domain name.

    mysql> select * from ftp_users f, domains d where f.dom_id=d.id and d.name='example.com';+----+--------+-------------+------------+| id | dom_id | sys_user_id | permission |+----+--------+-------------+------------+| 52 | 160 | 399 | 0 |+----+--------+-------------+------------+1 row in set (0.00 sec)

  3. Remove invalid record from the database;

    mysql> begin;mysql> delete from ftp_users where id=52;mysql> commit;

Have more questions? Submit a request
Please sign in to leave a comment.