Site page cannot be opened in Wizard: "Internal Sitebuilder error"

Created:

2016-11-16 12:46:10 UTC

Modified:

2017-04-24 11:17:52 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Site page cannot be opened in Wizard: "Internal Sitebuilder error"

Applicable to:

  • Plesk Sitebuilder 4.5 for Linux

Symptoms

The following error is shown when try to open site in Sitebuilder Wizard:

http://sitebuilder.hostname/Wizard/Edit/Html?currentPageId=yjaw9bu9px1

Internal Sitebuilder error.
File: /usr/local/sitebuilder/include/Base/GUI.php
Line: 101
Message: PHP Warning : DOMDocument::loadXML() [<a href='function.DOMDocument-loadXML'>function.DOMDocument-loadXML</a>]: internal errorExtra content at the end of the document in Entity, line: 659
Code: 2

Cause

In Sitebuilder 4.5 site's content is stored in Sitebuilder database.Every time you open site in Wizard the pages are compiled anew.

The problem is caused by records in DOS-style file name format or not-printable symbols in table where page content is stored. The page cannot be compiled and the error occurs.

To resolve the problem you need to remove the problem characters from Sitebuilder database.First verify that Sitebuilder database has UTF8 character set , then find and remove the problem records.

Resolution

Using instructions below you will dump table that contains content of page yjaw9bu9px1 , replace the problem records and restore the record.

  1. Backup Sitebuilder database before any reconfiguration in the tables.

    ~# mysqldump -u<USER> -p<PASSWD> sitebuilder3 > sitebuilder3.dump. date +%F.%s .sql

  2. Stop Apache web service to make Sitebuilder GUI not available. This to prevent site editing during you change site's content.

    ~# /etc/init.d/httpd stop

  3. Dump table site.page where content of all pages is stored:

    ~# mysqldump -u<USER> -p<PASSWD> --skip-extended-insert sitebuilder3 --tables site_page > site_page.dump. date +%F.%s .sql

    Where and are login and password for mysql administrative user.

  4. Open backup file site_page.dump. date +%F.%s .sql in file editor ( vi site_page.dump. date +%F.%s .sql ) and find record appropriate to page yjaw9bu9px1 :

    INSERT INTO `site_page` VALUES (305,8,307,1,'','Nous trouver','<p>&lt;p align="left"font size="1"� &lt;/font&gt;&lt;/em&gt;&lt;/p&gt;</p>',1,'Momoh, automobiles, location, achat, vente','Contact','contact','yjaw9bu9px1',0);

    You may see that the record contains not-printable symbol "�" that causes the problem during page compilation. The problem may be also caused by Windows symbols "^N" , etc..

  5. Replace symbol "�" in the query, delete the symbol and insert corrected record to the table.

    mysql> DELETE FROM site_page WHERE identity='yjaw9bu9px1';
    mysql> INSERT INTO `site_page` VALUES (305,8,307,1,'','Nous trouver','<p>&lt; p align="left"font size="1"&lt;/font&gt;&lt;/em&gt;&lt;/p&gt;</p>',1,'Momoh, automobiles, location, achat, vente','Contact','contact','yjaw9bu9px1',0);
  6. Start Apache web service to make Sitebuilder GUI available.

    ~# /etc/init.d/httpd start

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