You are not logged in.
- Topics: Active | Unanswered
#1 2013-09-14 20:45:58
- Franz
- Lead developer
- From: Germany
- Registered: 2008-05-13
- Posts: 6,744
- Website
Offline
#2 2013-09-14 23:04:22
- CRLin
- Member
- From: Taiwan
- Registered: 2011-02-17
- Posts: 65
- Website
Re: SQLite3 support
Great!
Offline
#3 2013-09-15 01:20:23
- kierownik
- Member
- From: Tilburg, Netherlands
- Registered: 2008-05-10
- Posts: 339
Offline
#4 2013-09-15 11:48:19
- Studio384
- Former Developer
- From: Belgium
- Registered: 2012-04-11
- Posts: 681
- Website
Re: SQLite3 support
Yes, why not. Actualy, it's about time.
Last edited by Studio384 (2013-09-15 11:48:30)
Get Luna - With build-in upgrade from FluxBB
Profile Plus: A new FluxBB profile interface
Offline
#5 2013-09-15 15:50:11
- Franz
- Lead developer
- From: Germany
- Registered: 2008-05-13
- Posts: 6,744
- Website
Offline
#6 2013-09-15 17:23:51
- kierownik
- Member
- From: Tilburg, Netherlands
- Registered: 2008-05-10
- Posts: 339
Offline
#7 2013-09-16 13:06:18
- Nowasky
- Member
- From: Brazil
- Registered: 2011-08-22
- Posts: 14
Re: SQLite3 support
It would be great
Offline
#8 2013-10-01 13:07:27
- korui
- Member
- From: Guangdong,China
- Registered: 2010-02-01
- Posts: 16
Offline
#9 2013-10-02 15:50:01
- Franz
- Lead developer
- From: Germany
- Registered: 2008-05-13
- Posts: 6,744
- Website
Re: SQLite3 support
Here you go then: https://fluxbb.org/development/core/tickets/906/.
Offline
#10 2013-12-18 21:47:09
- isok
- New member
- Registered: 2013-12-18
- Posts: 2
Re: SQLite3 support
Hey guys, I've just registered to get some news about Sqlite 3 support in FluxBB. Any progress? If you ask me, I was pretty happy with version 2 (it was almost ideal for small projects), but as soon as PHP decided to drop it and move to Sqlite 3, I'd like to move on as well.
Last edited by isok (2013-12-18 21:47:49)
Offline
#11 2013-12-18 22:04:53
- Franz
- Lead developer
- From: Germany
- Registered: 2008-05-13
- Posts: 6,744
- Website
Re: SQLite3 support
Hey there.
The problem is that SQLite3 does not support a num_rows()-like method. That's how we do tons of things in the source code, though.
We have a workaround in place, they will need some tests, though. If we get it working, SQLite3 support will be in the next update.
Offline
#12 2013-12-19 04:05:57
- isok
- New member
- Registered: 2013-12-18
- Posts: 2
Re: SQLite3 support
If we get it working, SQLite3 support will be in the next update.
Great news. Thanks and good luck with this!
Have you already seen this discussion?
webdeveloper.com/forum/showthread.php?244098-RESOLVED-mysql_num_rows-equivalent-for-sqlite3/page2&s=7725dac43565ac8971d1e607431c37ed
... SQLite and SQLite3 have different APIs. SQLite3 doesn't implement buffered results so the total number of results isn't available. This is down to the fact that libsqlite really doesn't implement it either and its emulated by the old SQLite extension.
Last edited by isok (2013-12-19 04:06:09)
Offline
#13 2013-12-19 09:45:48
- Franz
- Lead developer
- From: Germany
- Registered: 2008-05-13
- Posts: 6,744
- Website
Re: SQLite3 support
Yeah, that is pretty much how we implemented it.
Offline
#14 2014-04-23 11:09:16
- Alberto5
- New member
- Registered: 2014-04-23
- Posts: 1
Re: SQLite3 support
Hello!
I have only sqlite3 available on my host and use at the moment punbb, but I want to switch to fluxbb.
What must I do to be able to run FluxBB with sqlite3 support on my host?
Will the next stable release of FluxBB run with sqlite3?
Last edited by Alberto5 (2014-04-23 11:09:54)
Offline
#16 2014-08-10 10:18:49
- w8diz
- Member
- Registered: 2014-08-10
- Posts: 7
Re: SQLite3 support
Hello All,
I've been running FluxBB 1.2.20 for many years. Now I'm moving to a new server PHP5.4.31 and do not find an upgrade path.
Is there any positive news about an SQLite3 driver? I would be happy to keep the old version 1.2 as long as I have php sqlite3 support.
If the answer is no, does anyone have a suggestion for moving fluxbb version 1.2 to another BB or is my current BB destined for the graveyard?
Sorry for the negativity but I've searched all over the web and find no solutions.
And I would be happy to test any work done on an sqlite3 driver.
Offline
#17 2014-08-10 10:31:32
- Studio384
- Former Developer
- From: Belgium
- Registered: 2012-04-11
- Posts: 681
- Website
Re: SQLite3 support
FluxBB 1.2 doesn't support SQLite 3, unless you added that yourself. If so, adding those changes to the current FluxBB 1.5.6 core should work most of the times. Anyway, I would suggest you to update to at least FluxBB 1.2.24 if you are going to stay in the 1.2 branch. Otherwise, Franz is currently working on SQLite 3 support for FluxBB 1.5.7, so stay tuned on that.
Get Luna - With build-in upgrade from FluxBB
Profile Plus: A new FluxBB profile interface
Offline
#18 2014-08-10 12:57:20
- w8diz
- Member
- Registered: 2014-08-10
- Posts: 7
Re: SQLite3 support
FluxBB 1.2 doesn't support SQLite 3, unless you added that yourself. If so, adding those changes to the current FluxBB 1.5.6 core should work most of the times. Anyway, I would suggest you to update to at least FluxBB 1.2.24 if you are going to stay in the 1.2 branch. Otherwise, Franz is currently working on SQLite 3 support for FluxBB 1.5.7, so stay tuned on that.
Hi Studio384,
You misunderstood my post...My new server does not support SQlite2 and without it my fluxbb is dead in the water.
Thanks for the reply - Diz, W8DIZ
Offline
#19 2014-08-10 14:50:32
- w8diz
- Member
- Registered: 2014-08-10
- Posts: 7
Re: SQLite3 support
OK...I'll bite...I will attempt to create an SQlite3 version of the DB interface for FluxBB.
Anyone that has done any roadwork and is willing to help me, the more the better.
-Diz, W8DIZ
Offline
#20 2014-08-10 16:15:19
- adaur
- Developer
- From: France
- Registered: 2010-01-07
- Posts: 843
- Website
Re: SQLite3 support
Hello,
If you own the server, why don't you install the latest MariaDB? It provides excellent performances and is fully compatible with FluxBB.
Otherwise, you can try thoses changes:
https://github.com/fluxbb/fluxbb/commit … afde859aa8
https://github.com/fluxbb/fluxbb/commit … 8fd5774ba4
https://github.com/fluxbb/fluxbb/commit … 4524a90959
Plus this if it doesn't work
https://github.com/Koos10/fluxbb/blob/m … qlite3.php
Last edited by adaur (2014-08-10 16:17:02)
FeatherBB - A simple and lightweight new generation forum system
Based on FluxBB, written in PHP, using Slim Framework for a proper OOP-MVC architecture.
Offline
#21 2014-08-10 18:04:26
- w8diz
- Member
- Registered: 2014-08-10
- Posts: 7
Re: SQLite3 support
Hello Adaur,
Thank you for the reply.
I am a very big fan of the single file sqlite database concept; very easy to manage.
I will review the links you gave me above and see what happens, and will report back my results, right here.
Thanks, Diz, W8DIZ (and excuse my poor English, I'm an American)
Offline
#22 2014-08-12 19:11:57
- GWR
- Member
- From: Germany
- Registered: 2010-08-06
- Posts: 214
Re: SQLite3 support
The move from SQLite2 to SQLite3 mostly means moving to PDO as some hosts do not install the necessary modules for an "Sqlite3"-based access.
This means you will have to replace all queries, as they now run over the PDO-oo-interface, or just use the non-oo-wrapper functions.
Another Option is to replace all queries with custom wrappers (you wrote) ... so then just prefix the commands with yours (such as "mynick_mysql_query") which then routes everything to the appropriate database. Take care of replacing everything. Things like "mysql_affected_rows" might not be valid with sqlite (eg. only on changed rows, not on "tried to change" rows).
bye
Ron
Offline
#23 2014-08-12 19:37:58
- w8diz
- Member
- Registered: 2014-08-10
- Posts: 7
Re: SQLite3 support
I give up
I've been running FluxBB 1.2.20 with SQlite2 nad my new server only has SQlite3 (SQlite2 not available anymore)
Looks like I need to use a different database like mySQL
Will I be able to convert my SQlite FluxBB1.2.20 to the latest 1.5.x FluxBB using mySQL?
Is there a 2 step solution to upgrade and then switch databases or vice versa?
I know this is traitor talk but I'm looking at myBB as a possible solution.
-Diz, W8DIZ
Offline
#24 2014-08-12 19:57:38
- adaur
- Developer
- From: France
- Registered: 2010-01-07
- Posts: 843
- Website
Re: SQLite3 support
Test the files I've sent to you with the latest FluxBB!
To update from 1.2 to 1.5 branch, simply paste the new files over the old ones and go to your forum.
FeatherBB - A simple and lightweight new generation forum system
Based on FluxBB, written in PHP, using Slim Framework for a proper OOP-MVC architecture.
Offline
#25 2014-08-13 17:50:06
- w8diz
- Member
- Registered: 2014-08-10
- Posts: 7
Re: SQLite3 support
Test the files I've sent to you with the latest FluxBB!
To update from 1.2 to 1.5 branch, simply paste the new files over the old ones and go to your forum.
OK...made all changes...getting this error and warning: missing file ==> fluxbb/include/utf8/utf8.php
fixed that...my error ...file permission error; now fluxBB is running sqlite.php and not sqlite3.php
error --> "This PHP environment doesn't have SQLite support built in."
looking for that...
OK, I overwrite version 1.2.20 with 1.5.6, then made all the edits per instructions.
Also converted my fluxbb.sqlite2 file to fluxbb.sqlite3
So why is the program still looking at fluxbb.sqlite2?
The common.php script has the $db_name as fluxbb.sqlite3
maybe I need a bigger shotgun to fix this - Diz, W8DIZ
Last edited by w8diz (2014-08-14 00:04:53)
Offline