Symptoms

When attempting to open the domain DOMAIN.TLD in Parallels Web Presence Builder (WPB), it does not edit the existing site, but attempts to create a new one.

Cause

site.site_page_id is missing in the preferences of the site associated with the domain in the WPB database (sitebuilder5):

~# mysql -u<MYSQL_USER> -p<MYSQL_PASSWORD> -h<MYSQL_HOST> sitebuilder5

mysql> select sps.url, s.uuid, s.site_page_id from site s, site_publish_settings sps where s.site_publish_settings_id=sps.id and sps.url like '%DOMAIN.TLD%'\\G
*************************** 1. row ***************************
         url: http://DOMAIN.TLD/
        uuid: b6310b5e-6805-c147-f4ad-e8567edf988c
site_page_id: NULL                                          <== !!
1 row in set (0.00 sec)

This issue may occur if the site owner removed the site by clicking on the " Start over " button. In this case, a new site is created without any pages and overwrite existing one.

In the log, you can see the dates a site was created or started over. Retrieve these records using the site's UUID:

~# cat /PATH/TO/PPB/sitebuilder.log | grep 'b6310b5e-6805-c147-f4ad-e8567edf988c'
--->8---
2012-02-29T16:59:16+04:00 [INFO] [System] /sitebuilder/JsonApi/ ...create site 9ab43904-7bcf-5dd2-ed22-ad070cf96e72 ::ffff:123.123.123.123
...
2012-03-02T17:38:29+04:00 [INFO] [System] /sitebuilder/JsonApi/ Starting over site with uuid "9ab43904-7bcf-5dd2-ed22-ad070cf96e72" ::ffff:123.123.123.129
---8<---

Resolution

Restore the site from a snapshot. For more help, see:

[HOW TO] How to back up and restore Web Presence Builder site through GUI

[HOW TO] How to restore Web Presence Builder site from snapshot located in a domain