Site creation wizard is shown when trying to edit an existing website in WPB

Symptoms

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

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

  # plesk db
  mysql> use 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 '%example.com%'\G
  *************************** 1. row ***************************
  url: http://example.com/
  uuid: b6310b5e-6805-c147-f4ad-e8567edf988c
  site_page_id: NULL 1 row in set (0.00 sec)

• In the log, dates when a site was created or started over can be seen. Retrieve these records using the site's UUID:

  # cat /usr/local/psa/admin/logs/sitebuilder.log | grep 'b6310b5e-6805-c147-f4ad-e8567edf988c'
  2012-02-29T16:59:16+04:00 [INFO] [System] /sitebuilder/JsonApi/ ...create site 9ab43904-7bcf-5dd2-ed22-ad070cf96e72 ::ffff:203.0.113.2...
  2012-03-02T17:38:29+04:00 [INFO] [System] /sitebuilder/JsonApi/ Starting over site with uuid "9ab43904-7bcf-5dd2-ed22-ad070cf96e72" ::ffff:203.0.113.2

Cause

This issue may occur if the site owner removed the site by clicking on the "Start over" button, or when a content of Web Presence Builder website was restored on a new domain.
In this case, a new site is created without any pages and overwrites the existing one.

Resolution

Restore the site from a snapshot.

Refer to the following links for more information regarding snapshot restoration:

• How to back up and restore Web Presence Builder site through GUI?
• How to restore Web Presence Builder site from snapshot located in a domain?