Article ID: 6426, created on Jun 16, 2009, last review on Aug 12, 2014

  • Applies to:
  • Plesk 9.2 for Linux/Unix
  • Plesk Sitebuilder 4.5 for Linux/Unix


The following error is shown when click button "Edit in Sitebuilder" on domain management page:

Domains -> <domain name> -> Edit in Sitebuilder
Site bc58af10483141447c6f202e7c235757 does not exist. Return to the Start page to create a new site.

For example here are steps how to reproduce the problem:

1. Register Parallels Plesk Sitebuilder in Parallels Plesk Panel.
2. Login to Parallels Plesk Panel as admin and create reseller. For that reseller activate Sitebuilder support and enable permission "Ability to use Sitebuilder". You may activate through Parallels Plesk Panel:

Reseller -> <reseller name> -> Permissions: Ability to use Sitebuilder 
 Reseller -> <reseller name> -> Interface Preferences: Create a corresponding user account in Sitebuilder

3. Login to Parallels Plesk Panel as reseller and create new client. Then create new domain owned by the client.
4. Activate Sitebuilder support for the client and its domain. You may do that through Parallels Plesk Panel:

Clients -> <client name> -> Interface Preferences: Create a corresponding user account in Sitebuilder
 Clients -> <client name> -> Domains -> <domain name> -> Web Hosting Settings: Create Web site using Sitebuilder

Try to open the domain in Sitebuilder Wizard:

  Clients -> <client name> -> Domains -> <domain name> -> Edit in Sitebuilder


When you enable Sitebuilder support for Plesk users new users are created in Parallels Plesk Sitebuilder. Currently all users are owned by Sitebuilder admin. Actually Sitebuilder user appropriate to Plesk client should be owned by Sitebuilder user appropriate to Plesk reseller.


The problem will be fixed in future update of Parallels Plesk Panel.

Currently it is recommended to forbid Plesk resellers from management of Parallels Plesk Sitebuilder. For that you may disable permission “Ability to use Sitebuilder” in reseller’s permission configuration page (Reseller -> <reseller name> -> Permissions: Ability to use Sitebuilder)

Here are instructions how to reconfigure the misconfiguration in Sitebuilder database.

Before reconfiguration please remember to backup databases of Parallels Plesk Panel and Parallels Plesk Sitebuilder. Use the following commands:

~# mysqldump –u<USER NAME> -p<PASSWORD> psa > psa.`date +%F.%s`.sql
~# mysqldump –u<USER NAME> -p<PASSWORD> sitebuilder3 > sitebuilder3.`date +%F.%s`.sql

Get identification of new Sitebuilder users that were created for Plesk reseller and Plesk client.

~# mysql –u<USER NAME> -p<PASSWORD> psa

mysql> select c.pname, sb.sb_client_login, sb.sb_reseller_id from psa.clients c, psa.SBResellers sb where;
| pname    | sb_client_login                  | sb_reseller_id                       |
| Reseller | @<reseller name> | 9555cc33-4d5e-6a3d-02c9-c44992474072 |
| Client   | @<client name>   | bd581bd5-fbb9-bf50-23ec-ff39445c72b3 |
2 rows in set (0.00 sec)


Get information about the users in Sitebuilder database:

~# mysql –u<USER NAME> -p<PASSWORD> sitebuilder3

mysql> select id, user_name, uuid, parent_id from sitebuilder3.user where uuid in ('9555cc33-4d5e-6a3d-02c9-c44992474072','bd581bd5-fbb9-bf50-23ec-ff39445c72b3');
| id | user_name                        | uuid                                 | parent_id |
| 12 | @<reseller name> | 9555cc33-4d5e-6a3d-02c9-c44992474072 |         1 |
| 14 | @<client name>   | bd581bd5-fbb9-bf50-23ec-ff39445c72b3 |         1 |
2 rows in set (0.00 sec)


The error is caused by the fact that Sitebuilder users "@<reseller name>" and "@<client name>" are owned by user with id "1", Sitebuilder administrator.
Using the following sql you may query change ownership of "@<client name>", it should belong to "@<reseller name>":

mysql> update user set parent_id=12 where user_name='@<client name>';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


Now the domain is opened normally through Domains -> <domain name> -> Edit in Sitebuilder.

NOTE: If Parallels Plesk Panel is installed on the server you may use the following command to connect to the databases:

~# mysql –uadmin –p`cat /etc/psa/.psa.shadow`

Additional information - How to enable Sitebuilder support for domains in Plesk 8 and Plesk 9?

f7f840260c1591440648a375a64b5b75 fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ea6a61e571a858aa6019ceb068ea403a 11a46d8a188d618564f4f0cead9a50f3 a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 6ef0db7f1685482449634a455d77d3f4 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF