The latest PHP v.5.3.3 doesn’t work good with PDO Sqlite3. I am using a VPS (Virtual Private Server) with Centos 5 and WHM/Cpanel 11.26.8. Everything goes fine except there is an error message “undefined symbol: sqlite3_libversion” in all users error_log.
I did compile my server with this configuration:
Apache v2.2
PHP 5.3.3
PDO and PDO_MySQL enabled
The compile process run without problem and success. But if you notice that, in error_log will show an error message like this:
“/usr/local/bin/php: symbol lookup error: /usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_sqlite.so: undefined symbol: sqlite3_libversion”
I check my pdo with this command:
/usr/local/bin/php --ri pdo_sqlite
and the result is:
“Extension ‘pdo_sqlite’ not present.”
Even i installed it from the EasyApache from WHM, the pdo and pdo_sqlite doesn’t installed on my system. And when i looked into php.ini configuration, pdo_sqlite extension is enabled. So i tried to install pdo with this command below:
pecl install pdo
i got this error message:
“make: *** [pdo_dbh.lo] Error 1
ERROR: `make’ failed”
After i Googled, i found that it’s not only me that have the same problem. See the links below:
http://forums.cpanel.net/f5/undefined-symbol-sqlite3_libversion-148993.html
http://bugs.php.net/bug.php?id=48614
So the solution for now, i turned off or remove the pdo extension from php.ini and restart the apache. Because i don’t use pdo extension for now. But i wish this bugs will be solved soon.
PS: to clean all the error_logs from the pdo_sqlite error message you can use this command:
find /home/ -iname 'error_log' -exec sed -i '/no-debug-non-zts-20090626/d' {} +
I have same problem pdo driver on ubuntu lucid , using php5.3
when working with zend-framework tutorial I executed the command
php load.sqlite.php
I was given message that pdo driver is not found
I'm having the same problem on a VPS with cPanel/CentOS and unfortunately I want PDO enabled so that I can use PHProjekt.
downgrade to Php 2.5.8
Probably means PHP 5.2.8