Service node is unknown for sysuser with id=0

[steved13]

When I try and go into the website and domains tab I get

Service node is unknown for sysuser with id=0
SysUser.php
77
PleskUtilException

This was caused by changing the default domain name from www.mydomian.com to mydomain.com.
To compound matters going to the the website url now points to default/htdocs directory rather than mydomain.com/httpdocs.
mydomain.com/httpdocs does exist and if I run

select * from sys_users;
+----+---------------+------------+------------+-----------+---------------------------------------------+------------+-------+
| id | serviceNodeId | login | account_id | mapped_to | home | shell | quota |
+----+---------------+------------+------------+-----------+---------------------------------------------+------------+-------+
| 1 | 1 | xxx | 1 | NULL | /var/www/vhosts/mydomain.com | /bin/false | 0 |
+----+---------------+------------+------------+-----------+---------------------------------------------+------------+-------+

select * from ServiceNodes;
+----+---------+-----------+-----------------+-----------+------------+
| id | name | transport | remoteIpAddress | accessKey | externalId |
+----+---------+-----------+-----------------+-----------+------------+
| 1 | local | local | NULL | NULL | |


so to me it would seem half the move has been done. I have looked around on the net and not found anything that has really helped.
Any help would be greatly appreciated.

Thx

Steve

 

[IgorG]

Usually this issue related to missing record in hosting table for domain. As possible workaround you can set htype value for domains to 'none' in domains table. After that you will be able to reconfigure domain.

 

[steved13]

Usually this issue related to missing record in hosting table for domain. As possible workaround you can set htype value for domains to 'none' in domains table. After that you will be able to reconfigure domain.

Sorted !

Thx very much I cannot tell you how much I appreciated this.