SymptomsThe site cannot be published through Parallels Plesk Sitebuilder Wizard correctly:
The site has been published with errors.
Cannot update modules data.
And the following error is shown in Sitebuilder logs at Sitebuilder -> System -> Logs:
System 7/10/2009 5:06:57 AM admin xxx.xxx.xxx.xxx The site 'domain.tld' has been published, but with errors....
System 7/10/2009 5:06:55 AM admin xxx.xxx.xxx.xxx Cannot update modules data....
Modules 7/10/2009 5:06:55 AM admin xxx.xxx.xxx.xxx Invalid server response: http/1.0 500 internal server error ...
Empty page is shown when try to open published site via http://domain.tld. The following error is shown in Apache error log:
[Fri Jul 10 05:06:55 2009] [error] [client xxx.xxx.xxx.xxx] PHP Fatal error: Allowed memory size of 100663296 bytes exhausted (tried to allocate 142401972731904 bytes) in /PATH/TO/domain.tld/httpdocs/include/SB/Modules/Storage/Db/Adapter/Sqlite.php on line 764
CauseDuring publishing Parallels Plesk Sitebuilder tries to allocate 142401972731904 bytes* (129T) of memory. This huge value of PHP memory is requested by PHP module SQLite 2.8.14.
To verify version of SQLite module it is recommended to login to the publishing server** and run the following command:
~# php -i | grep 'SQLite Library'
SQLite Library => 3.3.6
SQLite Library => 2.8.14 <=== this version of SQLite module
ResolutionIt is recommended to upgrade SQLite to version 2.8.17 or above.
For details about compilation procedure please refer to this article: http://kb.sp.parallels.com/en/5460
Additional information*Value of required PHP memory may be other then 142401972731904.
**Publishing host is server with FTP and HTTP where Sitebuilder site is published to. It may be one of several physical servers. During site publishing files are uploaded via FTP, Parallels Plesk Sitebuilder queries published site via HTTP requests.
If publishing host consists of several servers, SQLite should be upgraded on server where HTTP runs.