Sitebuilder SQLite extension is not found / PHP

[unco]

Hi -

A couple of days ago, without even considering that something might go wrong, I began to utilize the Atomic Rocket Turtle repos for yum updates. Immediately after, Sitebuilder croaked, giving me ion cube loader errors. I fixed that, and then it said SQLite wasn't found. I now have sqlite3, which isn't supported by Sitebuilder. I've read all the threads on that and even opened a ticket, which hasn't helped at all. I always had great luck with tech support, but this time is different. Over the last several hours, I've just been told to read KB articles and downgrade PHP, but no instructions accompanying that advice.

This is the last thing I was given to try:

"You will need to download required php version(5.2.0) packages and install it on top of the previous ones with "--force" key, also you will have to uninstall your current sqlite3 package and replace it with sqlite2."

Where do I download these for Plesk?

Thanks,
Beth

 

[unco]

So sorry. I should have included some stuff:

Plesk info:
-----------
Plesk Control Panel version psa v8.6.0_build86080910.19 os_CentOS 5
Operating system Linux 2.6.18-92.1.10.el5

Sitebuilder:
-------------
Product name
Parallels Plesk Sitebuilder for Linux/Unix
Product version
4.5.0 (2008090214)

PHP:
-------
php -v
PHP Warning: PHP Startup: SQLite: Unable to initialize module
Module compiled with module API=20050922, debug=0, thread-safety=0
PHP compiled with module API=20060613, debug=0, thread-safety=0
These options need to match
in Unknown on line 0
PHP 5.2.6 (cli) (built: May 2 2008 16:06:40)
Copyright (c) 1997-2008 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
with the ionCube PHP Loader v3.1.29, Copyright (c) 2002-2007, by ionCube Ltd.

 

[unco]

I got it worked out for anyone who would like to know. I needed to downgrade the PHP. What I did was get all the files I needed and NOT install them automatically. I excluded php-devel because that was going to install sqlite3, which started the whole mess for me in the first place.

yum --exclude=php-devel install php* -y --downloadonly

Then

cd /var/cache/yum/base/packages/

Then (I used nodeps because it said, "Failed dependencies:
libsqlite3.so.0 is needed by php-pdo-5.1.6-20.el5.i386" and I knew it was there!

rpm -Uvh --nodeps --oldpackage php*.rpm

Then I restarted httpd (service httpd restart) and got that ioncubeloader error, so I went into /etc/php.d/ioncube-loader.ini and made sure this line was there:

zend_extension=/usr/lib/php/modules/php_ioncube_loader_lin_5.1.so

Then I restarted httpd again and all was well. I am not going to try to update PHP again as long as I have Sitebuilder running unless I've researched all the potential problems extensively. Thanks to bartje3 for pointing me in the right direction.

 

[magga]

For anyone else who faces this problem, you can actually get around this without downgrading php by installing an older version of sqlite on top, this article explains it all:

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

I followed the instructions in this and now sitebuilder is working ok again!