[RC] Support of SQLite 3.0+

[Boris Berdichevski]

Please try a new version, php must be 5.3.0 or higher (I've checked on 5.3.3)

[Sierron]

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?

[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.

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!

[Sierron]

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

[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;

[Boris Berdichevski]

I'll correct all 'rubbishes' in the MOD together with moving to phpBB 3.0.8.

[Sierron]

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

[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)...

[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.

[Boris Berdichevski]

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.

[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

[Boris Berdichevski]

I don't know if sqlite3 faster than sqlite(2), I used old sqlite(2) some years ago.
There are some minimal changed in MOD to use it for 3.0.8, I'll prepare them & change.

[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.

[Boris Berdichevski]

Finish.
There's actual correct version of MOD.

[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!

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.