sys User Problems

[Jasper_Grimbo]

After a update from a subdomain i get a error.
and now i can't go to the Domain window.

The Plesk system is 8.1.0 with the newest updates.

The Mysql psa database show me that the sysuser row haven't a user for the system. But a manuel edit have no result.



what can i do ?
it this a bug ?

 	[I]ERROR: PleskFatalException [/I] 

Unable to create SysUser object: SysUser: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/class.DomainControlForm.php:174
    DomainControlForm->assign(object of type BsDomain)
1: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:147

Thanks Jasper

 

[Nataliya Zagr]

Hello, Jasper

To solve the issue, please, follow the steps:

1) The sys_users record for the domain is missing. You need to find the SysUser id:
mysql> select id from domains where name='domain.tld';

2) Find the sysuser id (sys_user_id) for the mentioned domain:
mysql> select * from hosting where dom_id=533

3) Add the record into accounts table with the next to latest id:
Find the latest id:
mysql> select * from accounts order by id desc limit 3;
Insert the record:
mysql> insert into accounts values (latest_id,'plain','password');

Note! you need to replace the latest_id with the id +1 you got at the previous query

4) Add the values to the sys_users table:

mysql> insert into sys_users values (v1,'login',v2,'/usr/local/psa/home/vhosts/domain.tld','/bin/false',0);

where v1 is the sys_user_id you found at the (2) step
v2 is the latest id you have inserted at the (3) step

This will recreate the missing user.
Please, note that it is highly recommended to backup the psa database befory and changes performed.