• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Unable to load object of type SysUser with id=

musictus

Basic Pleskian
I'm unable to complete a migration between two PPP version 11.5

I'm getting this "warning" for all domains with physical hosting

WARNING: (domain object 'xxx.it') Internal server error: <cli><failure>Unable to load object of type SysUser with id=1: SysUser: unable to select: no such row in the table</failure></cli>

The result is that no hosted website was migrated, not just a waring...

I read
http://forum.parallels.com/showthre...d-3&highlight=Unable+load+object+type+SysUser

But in the Sys_Users table in the psa database, I already find the record for each domain, as for example

id ! login ! account_id ! home ! shell ! quota ! mapped_to ! serviceNodeId
102 ! xxxit ! 628 ! /var/www/vhosts/xxx.it ! /bin/false ! 0 ! NULL ! 1

How can I fix this?
 
Last edited:
I don't think this kb applies to this kind of problem.

As I wrote, the entry in the Sys_Users already exists. But, for example in this case, the error says SysUser with id=1, while the correct id is 102.

All next errors are
Unable to load object of type SysUser with id=2
Unable to load object of type SysUser with id=3
Unable to load object of type SysUser with id=4
and these ids are not related to domains
 
Trying the single domain migration, also all email users are failing

Execution of /usr/local/psa/admin/plib/api-cli/user.php --create [email protected] -owner admin -guid '' -cname [email protected] -passwd '' -passwd_type sym -status enabled -domain-admin false -email [email protected] -role Mail\ User -legacy-user false -subscription-name xxx.it -ignore-nonexistent-options failed with return code 1.
Stderr is
Error during user creation: Owner with id 1 has not subscription with id 1
 
I have just added from scratch a new domain and tried the migration. Same problem

Warning: domain "test2.it"
Internal server error: Unable to load object of type SysUser with id=80: SysUser: unable to select: no such row in the table

Warning: domain "test2.it"
Execution of /usr/local/psa/admin/plib/api-cli/domain_pref.php --update test2.it -default_server_mysql localhost:3306 -default_server_postgresql localhost:5432 -ignore-nonexistent-options failed with return code 1.
Stderr is
You can set the default database server parameter for subscriptions only.
 
Now I understood another thing... the problem is not on the source server but on the destination.

I added a domain and I got the same error

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

Infact sys_users table is completely empty on the new server! Why is that? How do I fix this?
 
Last edited:
Back
Top