How to fix "Unable to load object of type PhDomain with id=1: Domain does not exist."

[DocF]

Hi,

I want to call.

/usr/local/psa/bin/server_pref -u -crontab-secure-shell "/bin/sh"

and get

Unable to load object of type PhDomain with id=1: Domain does not exist.

Ho can it get fixed? It's a Plesk 11.0.9 upgraded from Plesk 10.

Thx,
Christian

 

[IgorG]

It is database inconsistency. There is no record for domain ID 1 in 'domains' table but corresponding record exists in 'hosting' table. Try to remove this record from 'hosting' table if you are absolutely sure thad domain doesn't exist or contact Support Team if you are not familiar with SQL.

 

[DocF]

Thank you very much. "SUCCESS: Server preferences are successfully updated" after deleting the inconsistent record from hosting. To find such records try this:

SELECT
*
FROM
hosting h
WHERE
h.dom_id NOT IN (
SELECT
d.id
FROM
domains d
)