I recently installed a DokuWiki on Ubuntu 12.04 Server Edition. But after adding BlogTNG I only get an Error 500
PHP Fatal error: Call to undefined function sqlite_open() in /lib/plugins/blogtng/helper/sqlite.php on line 44
After some searching I find out that:
“The plugin creates a blogtng.sqlite file which is currently a SQLite2 database and will not work with sqlite3 installed”1)
but it seems Ubuntu 12.04 no longer has sqlite2.
ii libaprutil1-dbd-sqlite3 1.3.12+dfsg-3 Apache Portable Runtime Utility Library - SQLite3 Driver ii libsqlite0 2.8.17-7fakesync1build1 SQLite shared library ii libsqlite3-0 3.7.9-2ubuntu1.1 SQLite 3 shared library ii php5-sqlite 5.3.10-1ubuntu3.5 SQLite module for php5 ii sqlite3 3.7.9-2ubuntu1.1 Command line interface for SQLite 3
These are the package versions. No v2!
Here I found a solution. A little bit dirty but working. The documentation mostly worked for me only the path for the .so file I had to ajust. Here my documentation perhaps if someone else have the Problem the solution will be found faster.
We are manipulating libraries I think you know: This changes have to be done as root user (or with sudo). And pleas be careful don't damage your installation
You have to get an older sqlite package from a prior Ubuntu.
x64
wget http://security.ubuntu.com/ubuntu/pool/main/p/php5/php5-sqlite_5.3.5-1ubuntu7.11_amd64.deb
x32
wget http://security.ubuntu.com/ubuntu/pool/main/p/php5/php5-sqlite_5.3.5-1ubuntu7.11_i386.deb
After this extract it
cd /tmp mkdir sqlite dpkg -x php5-sqlite_5.3.5-1ubuntu7.11_i386.deb sqlite
And copy the library to the others
cp -iv sqlite/usr/lib/php5/20090626+lfs/sqlite.so /usr/lib/php5/20090626+lfs
Now you have to create an ini file witch activates the new module
; configuration for php SQLite module extension=sqlite.so
And finaly restart your apache
service apache2 restart
Now BlogTNG should work.