Article ID: 6973, created on Dec 5, 2009, last review on May 5, 2014

  • Applies to:
  • Plesk Sitebuilder 4.5 for Linux/Unix

Symptoms

The following error is showed in Wizards when try publishing a site:

Internal Sitebuilder error.
File: /usr/local/sitebuilder/include/SB/ORM/SitePublication.php; Line: 34
Message: PHP Notice : Trying to get property of non-object; Code: 8

Cause

A site's page module instance does not have publishing history record.

The problem has been fixed in Parallels Sitebuilder since version 4.5: during publishing modules get publishing instances correctly. The problem may exists in Parallels Sitebuilder versions 3.x, 4.0, 4.1, 4.2 or if Parallels Sitebuilder was upgraded to 4.5 and the problem was not fixed before. Upgrading would not resolve the misconfiguration.

Resolution

To fix the problem it is recommended to find the misconfiguration in database of Parallels Sitebuilder and correct it. Using steps below you may fix the misconfiguration in Parallels Sitebuilder versions 4.2 and 4.5.

1. Backup database of Parallels Sitebuilder:

~# mysqldump -u<user> -p<password> --skip-extended-insert sitebuilder3 > sitebuilder3.dump.`date +%F.%s`.sql

Where <user>/<password> are user and password for mysql administrator.

2. Find id of site that experiences the problem:

mysql> select id, alias, site_publish_settings_id, site_page_id from site where alias='SITE NAME';
+------+-----------+--------------------------+--------------+
| id   | alias     | site_publish_settings_id | site_page_id |
+------+-----------+--------------------------+--------------+
| 4220 | SITE NAME |                       11 |           48 |
+------+-----------+--------------------------+--------------+
1 row in set (0.00 sec)

mysql>


4220 is id of site 'SITE NAME'.

3. Select instances for all page modules in the site:

mysql> select * from module_instance where site_id=4220;
+-------+-------------+---------+-----------+-------------+-------------+
| id    | instance_id | site_id | module_id | time_create | time_remove |
+-------+-------------+---------+-----------+-------------+-------------+
| 15855 | 2b4h2qxgkmd |    4220 |         5 |  1192718497 |        NULL |
| 15361 |
4606yem2714 |    4220 |         5 |  1205400670 |        NULL |
| 18513 | u9plgl9tsf2 |    4220 |        13 |  1214325030 |        NULL |
+-------+-------------+---------+-----------+-------------+-------------+
3 rows in set (0.00 sec)

mysql>


4. Test all instances 15855,15361,18513 and find one with missing publication record. For example publishing record is missing for instance 15361:

mysql> select id, module_instance_id, published_instance_id, version, required_api_version, site_publication_id from module_instance_publication where module_instance_id=15361;
+------+--------------------+-----------------------+---------+----------------------+---------------------+
| id   | module_instance_id | published_instance_id | version | required_api_version | site_publication_id |
+------+--------------------+-----------------------+---------+----------------------+---------------------+
| 9328 |              15361 | 4606yem2714           | 4.1.0   | 4.1.0                |                4901 |
+------+--------------------+-----------------------+---------+----------------------+---------------------+
1 row in set (0.00 sec)

mysql> select * from site_publication where id=4901;
Empty set (0.01 sec)

mysql>


5. Delete the problem instance:

mysql> delete from module_instance where site_id=4220 and id=15361;
Query OK, 1 row affected (0.02 sec)

mysql>

f7f840260c1591440648a375a64b5b75 fad6dc0c8e983c17ae70a51ac7952cd0 d055be4fdc562a8ecb8e6d0bf419f946 ea6a61e571a858aa6019ceb068ea403a 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF