Page 5 of 7

Re: [RC] Support of SQLite 3.0+

Posted: Sat Dec 11, 2010 10:21 pm
by Boris Berdichevski
Please try a new version, php must be 5.3.0 or higher (I've checked on 5.3.3)

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 12:18 am
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?

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 8:48 am
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!

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 2:26 pm
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

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 3:37 pm
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;

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 3:54 pm
by Boris Berdichevski
I'll correct all 'rubbishes' in the MOD together with moving to phpBB 3.0.8.

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 3:59 pm
by Sierron
Yep, now it works fine. The install is compatible with 3.0.8.

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 4:45 pm
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)...

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 5:57 pm
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.

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 6:18 pm
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.

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 6:37 pm
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

Re: [RC] Support of SQLite 3.0+

Posted: Sun Dec 12, 2010 11:41 pm
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.

Re: [RC] Support of SQLite 3.0+

Posted: Tue Dec 14, 2010 12:26 pm
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.

Re: [RC] Support of SQLite 3.0+

Posted: Tue Dec 14, 2010 11:19 pm
by Boris Berdichevski
Finish. :D
There's actual correct version of MOD.

Re: [RC] Support of SQLite 3.0+

Posted: Tue Jul 12, 2011 8:07 am
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.