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
---
How to resolve the problem?
Cause
In Parallels Plesk Sitebuilder version 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 Parallels Plesk Sitebuilder GUI not available. This to prevent site editing during you change site's content.
~# /etc/init.d/httpd stop
Stopping httpd: [ OK ]
~#
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 <USER> and <PASSWD> are login and password for mysql administrative user.
4. Open backup file site_page.dump.`date +%F.%s`.sql in file editor and find record appropriate to page yjaw9bu9px1:
~# vi site_page.dump.`date +%F.%s`.sql
--->8---
INSERT INTO `site_page` VALUES (305,8,307,1,'','Nous trouver','<p><p align="left"font size="1" </font></em></p></p>',1,'Momoh, automobiles, location, achat, vente','Contact',
'contact','yjaw9bu9px1',0);
---8<---
You may see that the record contains not-printable symbol "" that causes the problem during page compilation.
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>< p align="left"font size="1"</font></em></p></p>',1,'Momoh, automobiles, location, achat, vente','Contact',
'contact','yjaw9bu9px1',0);
6. Start Apache web service to make Parallels Plesk Sitebuilder GUI available.
~# /etc/init.d/httpd start
Starting httpd: [ OK ]
~#