[RC] Support of SQLite 3.0+

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Anti-Spam Guide
Locked
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

[RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

MOD Title: Support of SQLite 3.0+
MOD Description: Add DB manager of SQLite 3.0+ for phpBB 3.0.x

MOD Version: 1.1
Tested for phphBB version: 3.0.9
php version - from 5.3.x
Example of MOD using: My Forum (russian)

MOD Download: SQLite3.0_MOD_5.3.x_for_309.zip
MOD Download Size: 46,460 bytes
Date & Time: Thursday, December 29, 2011 22:47
History: 29-Dec-2011 fix of bug - queries fail because DB locked
Additional Download: SQLite 3.0 DLLs complete (for MS Windows only)
Update from 3.0.8 to 3.0.9: SQLite3.0_MOD_update_to_309.zip
Update from 3.0.9 to 3.0.10: SQLite3.0_MOD_update_to_310.zip
Update to 3.0.11: SQLite3.0_MOD_update_to_311.zip
Update to 3.0.12:
Use phpBB-3.0.11_to_3.0.12-SQLite3.zip instead phpBB-3.0.11_to_3.0.12.zip

Tested for versions:
OS: MS Windows
php version: 5.4.8

You don't use the MOD for convert "live" Forum from SQLite 2.0 to SQLite 3.0, only for first installation.
If you need convert DB, please install a new Forum with the MOD & convert DB using standard utilities.
If you use the MOD, and there's Upgrade patch for next phpBB version, you must to modify Upgrade patch before run it, see Update from 3.0.8 to 3.0.9.
Last edited by Boris Berdichevski on Fri Oct 04, 2013 12:22 pm, edited 34 times in total.
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

Upgrade to phpBB 3.0.2 :|
Last edited by Boris Berdichevski on Mon Aug 11, 2008 4:29 pm, edited 1 time in total.
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

I didn't find any problem. I change MOD's status to RC (release candidate).
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

About pbpBB 3.0.3
You cannot upgrade DB of this MOD using standard phpBB-3.0.2_to_3.0.3 patch cause database_update.php script doesn't know about sqlite 3.0+
Please use modified patch:
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

Upgrade:
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

You can simple replace sqlite DLL to new version. Download it from SQLite size and replace into
%WINDOWS%/System32. Don't forget restart Apache or your server.
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

You can upgrade version of PHP too. To use PHP 5.2.9 please replace php_sqlite3.dll from
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

php_sqlite3.dll for php 5.2.9 added to package. sqlite3.dll updated to v.3.6.11.
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

For phpBB 3.0.5:
  • Download standard Update Package (for exam. phpBB-3.0.4_to_3.0.5.zip )
  • Replace files install/database_update.php and docs/INSTALL.html from
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [RC] Support of SQLite 3.0+

Post by Boris Berdichevski »

Support phpBB 3.0.6:

Before upgrade replace files install/database_update.php and docs/INSTALL.html from


Full version 3.0.6 (english)


Sqlite3 DLLs (addition files for phpBB 3.0.6 sqlite3 full)
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [Final] Support of SQLite 3.0+

Post by Boris Berdichevski »

Support phpBB 3.0.7-PL1:

Before upgrade replace files install/database_update.php and docs/INSTALL.html from


Both from 3.0.6 to 3.0.7-PL1 or from 3.0.7 to 3.0.7-PL1
Last edited by Boris Berdichevski on Sat Mar 06, 2010 6:26 pm, edited 1 time in total.
Peter77sx
Registered User
Posts: 3260
Joined: Wed Nov 09, 2005 2:51 pm

Re: [Final] Support of SQLite 3.0+

Post by Peter77sx »

Hello, which one of those links is the main download? Will this be handled via my ACP?

thanks :)
User avatar
igorw
Former Team Member
Posts: 8024
Joined: Fri Dec 16, 2005 12:23 pm
Location: {postrow.POSTER_FROM}
Name: Igor Wiedler

Re: [Final] Support of SQLite 3.0+

Post by igorw »

Hey there! This is a nice MOD. I do wonder why you are distributing it as a whole phpBB3 package and not just the changed files (and a diff). That would save a ton of disk space.

Considering the MySQL native driver that was included with phpBB 3.0.7, you might actually want to give this a shot and submit it to the bug tracker. The dev team might want to include it in phpBB 3.0.8.

This may be my personal preference, but imo sqlite3 looks better than sqlite_3.
Igor Wiedler | area51 | GitHub | trashbin | Formerly known as evil less than three
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [Final] Support of SQLite 3.0+

Post by Boris Berdichevski »

Peter77sx wrote:Hello, which one of those links is the main download? Will this be handled via my ACP?

thanks :)
If you start to create your Forum, you must download my links Version phpBB 3.0.6 English (without sqlite3 DLLs) & Sqlite3 DLLs
After first install you should upgrade your Forum from 3.0.6 to 3.0.7-PL1 using standard upgrade package, but before upgrade to replace 2 files from my link Files to replace in standard upgrade: ... 3.0.7-PL1

If you have any Forum already using SQLite 2.0, you should convert DB to SQLite 3.0 format first. Sorry, but my mode haven't any merge script, you should merge files manually, using Araxis.
User avatar
Boris Berdichevski
Registered User
Posts: 74
Joined: Thu Jul 10, 2008 9:09 pm

Re: [Final] Support of SQLite 3.0+

Post by Boris Berdichevski »

eviL<3,
I didn't check if my MOD make degradation for users of SQLite 2.0...

SQLite 3.0+ for UNIX didn't checked too...
Locked

Return to “[3.0.x] MODs in Development”