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

Created:

2016-11-16 12:52:46 UTC

Modified:

2017-04-24 12:08:51 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.5 for Linux
  • Web Presence Builder 11.0 for Linux
  • Plesk 10.4 for Linux
  • Web Presence Builder 11.1 for Linux
  • Web Presence Builder 12.0 for Linux
  • Web Presence Builder
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux
  • Web Presence Builder 11.5 for Linux
  • Plesk 12.5 for Windows

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

Have more questions? Submit a request
Please sign in to leave a comment.