Page 1 of 1

Problem with php 5.2 and sitebuilder

Posted: Fri Jan 08, 2010 8:50 am
by jnarvaez
Hi I'm getting some problems after installing sitebuilder on my centos 5 x64 with php 5.2.11 upgraded from atomic repo.

When a publish a website from sitebuilder I get an "internal server error" and the following in the error_log file:

PHP Fatal error: Allowed memory size of 50331648 bytes exhausted (tried to allocate 142401972731904 bytes) in /var/www/vhosts/testing.com/httpdocs/include/SB/Modules/Storage/Db/Adapter/Sqlite.php on line 764

i tried updating php-sqlite but it says it is updated. This is what i have:

-bash-3.2# rpm -qa | grep sqlite
php-sqlite2-5.2.11-1.el5.art
sqlite-3.3.6-5
cyrus-sasl-sqlite3-1.0.0-0.277763
python-sqlite-1.1.7-1.2.1
php-sqlite2-5.2.11-1.el5.art
sqlite-devel-3.3.6-5
sqlite2-2.8.17-1.el5.art
sqlite-3.3.6-5

any idea?

Best regards

Re: Problem with php 5.2 and sitebuilder

Posted: Fri Jan 08, 2010 9:36 am
by Highland
Yeah, allocating 142,000+ GB of RAM is a bad thing. Have you tried looking for similar issues over at the Plesk Knowledge Base? I seriously doubt this is an issue with either sqlite or ART repo files.

Re: Problem with php 5.2 and sitebuilder

Posted: Fri Jan 08, 2010 10:59 am
by jnarvaez
Yes, I found this KB:

http://kb.parallels.com/en/5460

I tried to update sqlite2 and php-sqlite but it says no updates are available.

I tried to follow the KB compiling my own sqlite2 but still not working.

Re: Problem with php 5.2 and sitebuilder

Posted: Sun Jan 10, 2010 12:11 pm
by jnarvaez
any idea?

Re: Problem with php 5.2 and sitebuilder

Posted: Mon Jan 11, 2010 10:36 am
by Highland
The KB doesn't match your initial problem. I poked around and found one on point (it does link to the one you mentioned)
http://kb.parallels.com/en/6894

The confusing part is this line
It is recommended to upgrade SQLite to version more than 2.8.17
That is the version availabe in the ART repo. I can't even find the source so maybe Scott can help you out on this. I would strongly advise against compiling your own library, especially using Plesk instructions.

Re: Problem with php 5.2 and sitebuilder

Posted: Mon Jan 11, 2010 11:03 am
by jnarvaez
Thanks for your help Highland.

I tried to build my own library following the KB instructions, i built it sucessfully and replaced with the one installed in /usr/lib/php/modules, new file is bigger:

1164 -rwxr-xr-x 1 root root 1185063 jan 8 13:41 sqlite.so
336 -rwxr-xr-x 1 root root 336444 jan 8 13:41 sqlite.so.old

restarted httpd but not no effect:

-bash-3.2# php -i | grep "SQLite Library"
SQLite Library => 3.3.6
SQLite Library => 2.8.14

any idea?
best regards

Re: Problem with php 5.2 and sitebuilder

Posted: Thu Feb 11, 2010 8:49 am
by jnarvaez
Solved the problem with this thread:

http://forum.parallels.com/showthread.php?t=83029

thank you!