Unable to access Plesk: Internal error: The site with UUID was not found.

Created:

2016-11-16 12:50:49 UTC

Modified:

2017-02-28 15:06:04 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access Plesk: Internal error: The site with UUID was not found.

Symptoms

The following error is displayed after logging into Plesk:

Internal error: The site with UUID "cfba53b8-6d0c-b203-b659-d88006a3ff6b" was not found.
Message The site with UUID "cfba53b8-6d0c-b203-b659-d88006a3ff6b" was not found.
File Site.php
Line 76
Type SB_Facade_Exception_NotFound

Cause

There are one or more records in the psa.dom_param table that refer to the sitebuilder5.site table, but sitebuilder5.site is empty. Alternatively, psa.dom_param.val refers to an incorrect sitebuilder5.site.uuid

Resolution

  1. Create a backup of your databases:

    # mkdir /root/mysql_backups/
    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /root/mysql_backups/psa.`date +%F_%H.%M`.sql
    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` sitebuilder5 > /root/mysql_backups/sitebuilder5.`date +%F_%H.%M`.sql
  2. Ensure the sitebuilder5 database is not empty. If the tables are empty, you will need to restore the database from a backup.

    mysql> select count(1) from sitebuilder5.site;
    +----------+
    | count(*) |
    +----------+
    | 54 |
    +----------+
    1 row in set (0.00 sec)

    mysql> select count(1) from sitebuilder5.site_publish_settings;
    +----------+
    | count(*) |
    +----------+
    | 52 |
    +----------+
    1 row in set (0.00 sec)
  3. Find the record(s):

    mysql> select dp.dom_id, d.name, dp.val from domains d, dom_param dp where d.id=dp.dom_id and dp.param='site_builder_site_id' and d.name like '%example.com%';

    +----+----------------------------------+--------------------------------------+
    | id | name | val |
    +----+----------------------------------+--------------------------------------+
    | 38 | example.com | cfba53b8-6d0c-b203-b659-d88006a3ff6b |
    +----+----------------------------------+--------------------------------------+

    mysql> select target_url from sitebuilder5.site_publish_settings where url like '%example.com%';
    +-------------------------------------------+
    | target_url |
    +-------------------------------------------+
    | pp://51981236-32d1-8aa8-b803-df6457f800c6 | < ==== this is required uuid
    +-------------------------------------------+
    1 row in set (0.00 sec)

    Note: Copy uuid without 'pp://' prefix

  4. Set the correct uuid in the psa.dom_param.val column for the missing Presence Builder site:

    mysql> BEGIN;    
    mysql> update dom_param set val='51981236-32d1-8aa8-b803-df6457f800c6' where dom_id=38 and param='site_builder_site_id';
    mysql> COMMIT;

Do not remove the records blindly if you are not sure that it is necessary. If Web Presence Builder is not used, remove the relevant records.

    mysql> BEGIN;
mysql> delete from dom_param where param='site_builder_site_id';
mysql> COMMIT;
mysql> REVERT; // to revert changes, if neccessary
Have more questions? Submit a request
Please sign in to leave a comment.