[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!
Scam Warning
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 »

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'
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur
Contact:

Re: [RC] Support of SQLite 3.0+

Post by 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.
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've tried php 5.3.3 (it has own sqlite3!) -- my Forum doesn't work with it!!! :?
I'll debug...
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 »

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.
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur
Contact:

Re: [RC] Support of SQLite 3.0+

Post by 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? :(
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'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!
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 »

In process... Code will 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 »

I've returned from vacation. Need to continue.
jslick
Registered User
Posts: 21
Joined: Sun Jun 26, 2005 10:09 pm

Re: [RC] Support of SQLite 3.0+

Post by 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 :(
--Jason
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur
Contact:

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

jslick wrote: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?
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).
jslick
Registered User
Posts: 21
Joined: Sun Jun 26, 2005 10:09 pm

Re: [RC] Support of SQLite 3.0+

Post by jslick »

Sierron wrote:
jslick wrote: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.
--Jason
User avatar
Sierron
Registered User
Posts: 241
Joined: Fri Apr 30, 2010 10:22 am
Location: Germany
Name: Artur
Contact:

Re: [RC] Support of SQLite 3.0+

Post by Sierron »

jslick wrote: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.
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'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.
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'm debugging... This has more time then I expected.
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 hope in short time I'll publicate the changed MOD.
Locked

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