Cannot open an existing website in Presence Builder: it creates a new one

Created:

2016-11-16 13:01:47 UTC

Modified:

2017-08-08 13:34:33 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot open an existing website in Presence Builder: it creates a new one

Applicable to:

  • Web Presence Builder for Windows
  • Plesk 12.5 for Windows

Symptoms

When attempting to open a website in Web Presence Builder (WPB), site creation wizard is shown instead of existing website.

Cause

Database inconsistency.

Resolution

  1. Create a new website

  2. Connect to sitebuilder database:

    "%plesk_dir%\\MySQL\\bin\\mysql" -usitebuilder -p -P3306 sitebuilder5
    • The username and password can be obtained from the file C:\\Program Files (x86)\\Parallels\\Plesk\\sb\\config
  3. Using the website name, find its id in the sitebuilder5 database:

        mysql> select * from site_publish_settings where url like "%example.com%"\\G;
    *************************** 1. row ***************************
    id: 1
    host_id: NULL
    uuid: de4d2f32-b1c8-9fc4-64ea-afe8b476c1de
    target_url: pp://d601b6eb-7d6a-2cbf-e753-d0654a99026e
    fallback_ip: NULL
    url: http://example.com/
    is_mysql_used: 0
    mysql_host: NULL
    mysql_port: NULL
    mysql_user: NULL
    mysql_password: NULL
    mysql_database: NULL
    http_user: NULL
    http_password: NULL
    ftp_mode: NULL
    1 row in set (0.00 sec)

    ERROR:
    No query specified
  4. Using the website id , find its site_id :

        mysql> select * from site where site_publish_settings_id=1\\G;
    *************************** 1. row ***************************
    id: 2
    dir_name: c6ad687990d372ef572bd56caaeb393d
    site_id: c6ad687990d372ef572bd56caaeb393d
    uuid: d601b6eb-7d6a-2cbf-e753-d0654a99026e
    alias: c6ad687990d372ef572bd56caaeb393d
    password_hash: NULL
    password_salt: NULL
    creation_date: 2016-01-01T14:59:54+00:00
    template_id: 2
    site_publish_settings_id: 1
    company_name: My website
    pages_use_name: 1
    description: Some description
    keywords: Few keywords
    logo_name: white
    logo_path: attachments/builtin/Logo/white.png
    custom_head:
    google_analytics_code:
    locale_code: en_US
    is_published: 0
    site_page_id: 67
    state: 2
    is_facebook_integration: 1
    plan_id: 2
    initial_site_template_id: 1
    site_owner_id: 4
    ecwid_id: NULL
    disqus_id: NULL
    1 row in set (0.00 sec)
  5. Copy the site_id

  6. Go to C:\\Inetpub\\vhosts\\example.com\\httpdocs\\data\\snapshots and rename the file <some_id>_list.xml - instead of <some_id> paste the recently copied site_id .

    In this case: c6ad687990d372ef572bd56caaeb393d_list.xml .

  7. Restore the latest snapshot in Presence Builder Editor.

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