Error installing phpBB3 with SQLITE

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Oconnor81
Registered User
Posts: 8
Joined: Sat Sep 13, 2008 3:48 pm

Error installing phpBB3 with SQLITE

Post by Oconnor81 »

Hi I'm trying to install phpBB3 with sqlite database. My Server does not support other database as sqlite. After installing phpBB3 I'm getting following error:
General Error
SQL ERROR [ sqlite ]

SQL logic error or missing database [1]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
So what can I do to solve my problem?

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69618
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Error installing phpBB3 with SQLITE

Post by KevC »

Try deleting the files and the database and starting again.

I've seen this two or three times and redoing everything fixed it.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Oconnor81
Registered User
Posts: 8
Joined: Sat Sep 13, 2008 3:48 pm

Re: Error installing phpBB3 with SQLITE

Post by Oconnor81 »

What files do I have do delete? Thanks for helping. Where is the database file saved?

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69618
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Error installing phpBB3 with SQLITE

Post by KevC »

Are you using a host cpanel wizard version or the files from here?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Oconnor81
Registered User
Posts: 8
Joined: Sat Sep 13, 2008 3:48 pm

Re: Error installing phpBB3 with SQLITE

Post by Oconnor81 »

I downloaded the files from here.

nanoluxx
Registered User
Posts: 1
Joined: Sat Sep 13, 2008 6:57 pm

Re: Error installing phpBB3 with SQLITE

Post by nanoluxx »

I have the same issue. Everything installs correctly, then on the last page when it asks you to login so you can begin modding :

SQL ERROR [ sqlite ]

SQL logic error or missing database [1]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


jayson-

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69618
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Error installing phpBB3 with SQLITE

Post by KevC »

Oconnor81 wrote:I downloaded the files from here.
Those are the files I mean.
Delete them all and reupload new ones.

In your site cpanel where you made the database before you started (you did make a database didn't you?) you need to delete it and remake it.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Oconnor81
Registered User
Posts: 8
Joined: Sat Sep 13, 2008 3:48 pm

Re: Error installing phpBB3 with SQLITE

Post by Oconnor81 »

No I did not made a database. How do I do that? I thought the software is doing it for me. Isn't the sqlite database just a file? So what do I have to do? Just create a file?

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69618
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Error installing phpBB3 with SQLITE

Post by KevC »

You have to make a database first.

Usually your site cpanel will have a database manager. However, not all hosts do it the same way, so your hosts are the best people to ask on how to make it.

When you have made it you'll have a name, username and password for it. That information can then be added to the installation page.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Oconnor81
Registered User
Posts: 8
Joined: Sat Sep 13, 2008 3:48 pm

Re: Error installing phpBB3 with SQLITE

Post by Oconnor81 »

Sorry I'm my own host. The Forum runs at a router Asus wl-500gP with
openwrt Kamikaze as firmware
Linux Kernel 2.6.23.16,
php 5.2.3,
pdo_sqlite 3.3.17
and sqlite 2.8.17.

So I dont have a database manager installed. What do I have to do to create a database?
Last edited by Oconnor81 on Mon Sep 15, 2008 4:56 pm, edited 1 time in total.

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69618
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Error installing phpBB3 with SQLITE

Post by KevC »

That's probably something you should ask on an sqlite support site.

Alternatively, you could use xampp or easyphp1.8 which have MySQL and everything else you need to install a php forum in a 1 click installer.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

peter.bb
Registered User
Posts: 1
Joined: Sun Sep 14, 2008 9:01 pm

Re: Error installing phpBB3 with SQLITE

Post by peter.bb »

Oconnor81: Hi im doing exactly the same with the same router and have the same problem... Ill welcome any help..

User avatar
Lumpy Burgertushie
Registered User
Posts: 67227
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Error installing phpBB3 with SQLITE

Post by Lumpy Burgertushie »

bottom line here people is that you have to have a database created before you can install phpbb.

if you do not know how to do this, you have to learn that wherever you learned host to setup your home server.

phpbb.com is really not for support on how to setup a web server.

my advice is to not do this at all.
rather, do it the way it was designed , get a web hosting account and install there. It does you no good installed on your computer at home.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.3 Styles by PlanetStyles.net

If nobody is in the forest, does a tree really fall?

Oconnor81
Registered User
Posts: 8
Joined: Sat Sep 13, 2008 3:48 pm

Re: Error installing phpBB3 with SQLITE

Post by Oconnor81 »

peter.bb wrote:Oconnor81: Hi im doing exactly the same with the same router and have the same problem... Ill welcome any help..
Nice that another one is trying the same stupid :D think. I can tell you that a punBB forum is runing ok at this router, but phpBB loks a lot better than punBB. I will look for an easy php script that is creating a database for us. It shouldn't be that hard

ToonArmy
Former Team Member
Posts: 4608
Joined: Sat Mar 06, 2004 5:29 pm
Location: Worcestershire, UK
Name: Chris Smith
Contact:

Re: Error installing phpBB3 with SQLITE

Post by ToonArmy »

Specify an absolute path in the database hostname field for the location of your SQLite DB, it will be created automatically. Ensure that it is on a writeable location and writeable by the web server.
Chris SmithGitHub

Locked

Return to “[3.0.x] Support Forum”