Can not publish website in WPB. Error: Site has incorrect version. Can not Publish

Created:

2016-11-16 12:54:42 UTC

Modified:

2017-08-08 13:32:45 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Can not publish website in WPB. Error: Site has incorrect version. Can not Publish

Applicable to:

  • Plesk for Linux

Symptoms

Can not publish website in Web Presence Builder 12.0.7 , the following error appears in Editor:

Site has incorrect version. Can not Publish

Cause

Database inconsistency.

Resolution

  1. Create a backup of sitebuilder5 database:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` sitebuilder5 > sitebuilder5_back.sql
  2. Log in to sitebuilder5 database:

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow ` sitebuilder5
  3. Check version of Web Presence Builder in database:

    mysql> select id, name, value from config_param where name = 'version';
    +----+---------+--------+
    | id | name | value |
    +----+---------+--------+
    | 1 | version | 12.5.0 |
    +----+---------+--------+

    As you can see the version value is incorrect, correct value should be 12.0.7

  4. Change this value:

        mysql> update config_param set value='12.0.7' where id=1;
    Query OK, 1 row affected (0.00 sec)
  5. Find issued domain in database:

    mysql> select id, url from site_publish_settings where url like "%example.com%";
    +----+---------------------------+
    | id | url |
    +----+---------------------------+
    | 7 | http://example.com/ |
    +----+---------------------------+

    Use recieved id in next query for site_publish_settings_id :

    mysql> select id from site where site_publish_settings_id = 7;
    +----+
    | id |
    +----+
    | 8 |
    +----+

    Replace example.com with name of your website in both queries.

  6. Check version for website in site_version table using id from site table:

    MariaDB [sitebuilder5]> select * from site_version where site_id = 8;
    +----+---------+---------+---------------+-------+---------------------+
    | id | site_id | version | chunk_version | chunk | finish_date |
    +----+---------+---------+---------------+-------+---------------------+
    | 8 | 8 | 120500 | NULL | NULL | 2015-04-15 17:31:16 |
    +----+---------+---------+---------------+-------+---------------------+

    Version for this website is equals to '120500', correct value is '120007'.

  7. Update site_version with correct value:

    mysql> update site_version set version = '120007' where id = 8;
    Query OK, 1 row affected (0.00 sec)
  8. Publish website in Web Presence Builder Editor.

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