[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!
Get Involved
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 »

Please try a new version, php must be 5.3.0 or higher (I've checked on 5.3.3)
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

Boris Berdichevski wrote:Please try a new version, php must be 5.3.0 or higher (I've checked on 5.3.3)
Is this an update package for your old mod version or do I need to make all the changes again?
Multilanguage TimeSplitters Site

If you need support, I suggest you to use the Support Request Template for your questions on this board. If you have some serious problems, the Support Toolkit can fix it (depends on the problem).
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 »

Take phpBB 3.0.7-PL1 (full installation) & process MOD changes. Then, create a new forum.
I'll check the MOD for phpBB 3.0.8 in a short time.
Sierron wrote:Is this an update package for your old mod version or do I need to make all the changes again?
If you process already the changes with the old MOD, you can replace file includes/db/sqlite_3.php only!
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

Boris Berdichevski wrote:If you process already the changes with the old MOD, you can replace file includes/db/sqlite_3.php only!
I replaced the file and hit the install button and after I hit the next button at the database page I got:
Fatal error: Call to undefined function sqlite3_libversion() in D:\www\www\phpBB3\includes\functions_install.php on line 412
Multilanguage TimeSplitters Site

If you need support, I suggest you to use the Support Request Template for your questions on this board. If you have some serious problems, the Support Toolkit can fix it (depends on the problem).
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 »

U-u-ps!
Please add change
includes/functions_install.php (Not needed for actual version of the MOD)

Code: Select all

Find:
			case 'sqlite':
				if (version_compare(sqlite_libversion(), '2.8.2', '<'))
				{
					$error[] = $lang['INST_ERR_DB_NO_SQLITE'];
				}
			break;

Add after:
			case 'sqlite_3':
				if (version_compare($db->sql_server_info(true), '3.0.0', '<'))
				{
					$error[] = $lang['INST_ERR_DB_NO_SQLITE'];
				}
			break;
Remove after:
			case 'sqlite_3':
				if (version_compare(sqlite3_libversion(), '3.0.0', '<'))
				{
					$error[] = $lang['INST_ERR_DB_NO_SQLITE'];
				}
			break;
Last edited by Boris Berdichevski on Mon Dec 27, 2010 9:33 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'll correct all 'rubbishes' in the MOD together with moving to phpBB 3.0.8.
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

Yep, now it works fine. The install is compatible with 3.0.8.
Multilanguage TimeSplitters Site

If you need support, I suggest you to use the Support Request Template for your questions on this board. If you have some serious problems, the Support Toolkit can fix it (depends on the problem).
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 »

Ok, I'll check it for 3.0.8 short time after.
I remember too that you (and other user with SQLite-3.0 forum) cannot use any package moving to next phpBB version (i.e. moving to next 3.0.9) -- without changing it before run. I'll support these changes. Until my MOD will be add to registered phpBB version (planning add to 3.1.x)...
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

I did an update of my phpBB3.0.7-PL1 to phpBB3.0.8 while having the sqlite3 mod installed. it worked fine. I think.
Multilanguage TimeSplitters Site

If you need support, I suggest you to use the Support Request Template for your questions on this board. If you have some serious problems, the Support Toolkit can fix it (depends on the problem).
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 »

Sierron wrote:I did an update of my phpBB3.0.7-PL1 to phpBB3.0.8 while having the sqlite3 mod installed. it worked fine. I think.
You didn't understand. If you have DB with SQLite 3.0 you use in previous version, then you use upgrade package to convert DB to next version. But without pre-run changing of upgrade package you cannot do the convert! Because upgrade package doesn't know about 'sqlite_3'!
Need change install/database_update.php before run update.
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

Oh yeah, sorry I forgot, that I made a reinstall, because of the different versions of sqlite. Sorry.

The thing is: Is SQLite3 faster for you than SQLite(2)? Because I'm not sure right now if it is really faster or slower than sqlite. The install took longer than with sqlite(2), but the database is smaller because of the better file format smaller.

SQLite(2) database file: 758 kb
SQLite3 database file: around 280 - 380 kb
Multilanguage TimeSplitters Site

If you need support, I suggest you to use the Support Request Template for your questions on this board. If you have some serious problems, the Support Toolkit can fix it (depends on the problem).
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 don't know if sqlite3 faster than sqlite(2), I used old sqlite(2) some years ago. :mrgreen:
There are some minimal changed in MOD to use it for 3.0.8, I'll prepare them & change.
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 »

There is known bug -- Backup (ACP) doesn't work. I've fixed this, please wait when I'll change MOD to actual version.
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 »

Finish. :D
There's actual correct version of MOD.
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 »

Please DO not upgrade to 3.0.9 before I'll publich corrected file database_update.php, you cannot upgrade with standard the file! :roll:

Done, please use SQLite3.0_MOD_update_to_309.zip
Please re-test also all changes using a new version of MOD for 3.0.9.

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