[RC] Support of SQLite 3.0+

[Boris Berdichevski]

PDO Driver for SQLite 3.x enabled
SQLite Library 3.6.20

The MOD doesn't support PDO, sorry...
Only dirver php_sqlite3.dll of my compile...
Try add it from http://www.borisba.com/~borisba/phpBB3/sqlite3.dlls.zip
And add string 'extension=php_sqlite3.dll'

[Sierron]

From my php.ini

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
extension=php_bz2.dll
extension=php_mbstring.dll
extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
extension=php_imap.dll
extension=php_mcrypt.dll
extension=php_mysql_libmysql.dll
extension=php_mysqli_libmysql.dll
extension=php_pdo.dll
extension=php_pdo_mysql_libmysql.dll
extension=php_pdo_sqlite_external.dll
extension=php_sockets.dll
extension=php_sqlite.dll
extension=php_sqlite3.dll
extension=php_zip.dll

I already have that extension and that file is also over 1 mb big. I don't think that your version are compatible with my version, because your files are for php 5.2.*

edit:

Besides I can use SQLite 3 with oop programming style. So the normal ones should work to.

Let me check, if they work and then I'll write here again.

[Boris Berdichevski]

I've tried php 5.3.3 (it has own sqlite3!) -- my Forum doesn't work with it!!!
I'll debug...

[Boris Berdichevski]

What way can it work, when I call all sqlite-functions with prefix sqlite3_ (sqlite3_connect, sqlite3_query etc.), and driver (php_sqlite3.dll) haven't these functions! And my driver has them.

[Sierron]

Object based I can use them in my testsite i worked on like $db = new SQLite3 ('sumomo-data.sqlite3');. The other way is, that you use PDO for SQLite3. The direkt functions like sqlite3_* are not implemented that way.

It's a little bit unlucky way to not support all the direct functions instead of using object based programming or PDO to do so.

And so your dll are only useful for people who are having their own server or an environment, that allows to add that modul.

The question is now: Is it compatible to phpBB3?

[Boris Berdichevski]

I'll try add variant of my MOD for PDO. And I'll translate my php_sqlite.dll for php 5.3.x.

The question is now: Is it compatible to phpBB3?

It's compatible, only it now!

[Boris Berdichevski]

In process... Code will change...

[Boris Berdichevski]

I've returned from vacation. Need to continue.

[jslick]

Hi Boris,

I've made a version of phpBB-3.0.7-PL1 with AutoMOD and sqlite3. Here's the link:
http://dl.dropbox.com/u/5126323/phpBB-3 ... qlite3.zip (temporary link)

I got frustrated at the tedious manual editing, but I didn't know of a way to use AutoMOD on a fresh install. So, basically, I followed these steps:

1. Installed phpBB using MySQL.
2. Installed AutoMOD.
3. Restored original install/ directory.
4. Installed SQLite3.0 MOD with AutoMOD
5. Restored the original config.php

However, I haven't been able to get it to work. On the install page it says SQLite 3.0 is Unavailable. But I do have sqlite3 installed.

• OS: Ubuntu 10.10 64-bit
• PHP: 5.3.3
• SQLite: 3.7.2
• phpBB3: 3.0.7-PL1
• SQLite3.0_MOD: 1.0 RC

• OS: Fedora 13 64-bit
• PHP: 5.2.13
• SQLite: 3.6.22
• phpBB3: 3.0.7-PL1
• SQLite3.0_MOD: 1.0 RC

Is there a PHP extension I need to install? If so, I won't be able to use it on the Fedora machine I listed, which was the point

[Sierron]

OS: Fedora 13 64-bit
PHP: 5.2.13

SQLite 3 is within the package of php 5.3.0, but not in 5.2.*

How do you have sqlite3? Do you have the sqlite3 extension enabled in your php.ini? Or do you have them another way?

[jslick]

OS: Fedora 13 64-bit
PHP: 5.2.13

SQLite 3 is within the package of php 5.3.0, but not in 5.2.*

How do you have sqlite3? Do you have the sqlite3 extension enabled in your php.ini? Or do you have them another way?

Thanks Sierron. I installed php5-sqlite on ubuntu and both SQLite and SQLite 3.0 options became available. However, when I 'Process to next step' from the Database settings page, I get a blank page (fatal error of some sort I think).

Unfortunately, I don't have this package (php5-sqlite) on the fedora machine, which I don't have administrative access to. My intention was to use sqlite since I don't have a MySQL db on that machine. Without sqlite ability, I don't think this serves me much purpose anymore. (Unless I were to ask the admins to enabled php5-admin; in which case, I might as well ask for a MySQL db).

If someone can confirm that my re-packaged phpBB works with sqlite3, I will post it at a more permanent location.

[Sierron]

Thanks Sierron. I installed php5-sqlite on ubuntu and both SQLite and SQLite 3.0 options became available. However, when I 'Process to next step' from the Database settings page, I get a blank page (fatal error of some sort I think).

Yeah I get the same problem. It's because the mod the mod author wrote only works with his own sqlite3 build, but that php5.3.* comes with sqlite3 support, he doesn't knew. He is currently rewriting it.

[Boris Berdichevski]

I'm solving now bug into function sql_fetchrow, I hope, after the fix all will be Ok (it's actually for php 5.3.x).
I support driver php_sqlite3.dll for PHP 5.2.9 (for Windows only). I hope the driver is compatible for 5.2.13 too.

[Boris Berdichevski]

I'm debugging... This has more time then I expected.

[Boris Berdichevski]

I hope in short time I'll publicate the changed MOD.