SQLite Error [on install]

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Fallen Soul
Registered User
Posts: 7
Joined: Mon Apr 02, 2007 1:38 am

SQLite Error [on install]

Post by Fallen Soul »

Hi I'm trying to install phpBB3 with sqlite database. After installing phpBB3 I'm getting this 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.
Any ideas on how to fix this?

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29256
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: SQLite Error [on install]

Post by Marshalrusty »

Are you installing this on a local server or on a hosting server? What information are you entering for the connection details?
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

Fallen Soul
Registered User
Posts: 7
Joined: Mon Apr 02, 2007 1:38 am

Re: SQLite Error [on install]

Post by Fallen Soul »

I am using a Hosting Server.

For the DNS I am using XXX.mochahost.com

Left the port blank.

Used my database and username/password and used SQLite to setup, it continued like normal and when it was done it gave me that error.

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29256
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: SQLite Error [on install]

Post by Marshalrusty »

In that case, it can't be SQLite. Check if it's MySQL.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

Fallen Soul
Registered User
Posts: 7
Joined: Mon Apr 02, 2007 1:38 am

Re: SQLite Error [on install]

Post by Fallen Soul »

When I try to reinstall using Mysql it wont work and wont connect to the DB.

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29256
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: SQLite Error [on install]

Post by Marshalrusty »

Fallen Soul wrote:When I try to reinstall using Mysql it wont work and wont connect to the DB.
So wait, did you choose SQLite because MySQL didn't work? You need to figure out what those credentials are for and then install, not guess and choose random options. Your host can assist in figuring out why it doesn't connect.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

Fallen Soul
Registered User
Posts: 7
Joined: Mon Apr 02, 2007 1:38 am

Re: SQLite Error [on install]

Post by Fallen Soul »

Well im pretty positive that its supposed to be SQLite, but when I got the error I uninstalled and tried Mysql, it didn't connect, so I did SQLite again to see if it was just my mistake so I went through it again and got the same Error.

I seen some where else where they talked about setting the DSN to an absolute path or something. But I wasn't sure what they were talking about and the other problem was kinda similar to mine but he hosted his own site.

User avatar
Marshalrusty
Project Manager
Project Manager
Posts: 29256
Joined: Mon Nov 22, 2004 10:45 pm
Location: New York City
Name: Yuriy Rusko
Contact:

Re: SQLite Error [on install]

Post by Marshalrusty »

As I explained above, you need to contact your host and figure out what those credentials are for. They will be able to assist you in determining what information to enter.
Have comments/praise/complaints/suggestions? Please feel free to PM me.

Need private help? Hire me for all your phpBB and web development needs

Fallen Soul
Registered User
Posts: 7
Joined: Mon Apr 02, 2007 1:38 am

Re: SQLite Error [on install]

Post by Fallen Soul »

Alright, well I will contact them and see where it takes me.

Thanks for you time, ;)

starsinc
Registered User
Posts: 3
Joined: Fri Nov 14, 2008 4:48 am

Re: SQLite Error [on install]

Post by starsinc »

same thing happens to me and only option to install is with sqlite.

starsinc
Registered User
Posts: 3
Joined: Fri Nov 14, 2008 4:48 am

Re: SQLite Error [on install]

Post by starsinc »

This is mine at the moment.

DB type : MySQL
DB DSN: localhost
DB Name: example
DB User: example
DB pass: ***
DB Prefix tables: phpb3_


And it's still not working. Like I said and the guy before me, it's only working in SQLite.

User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote
Contact:

Re: SQLite Error [on install]

Post by D¡cky »

If you are unable to connect to the MySQL database, then you are entering the incorrect information to connect to it. If you created the database, you should know the database name and the username and password you assigned to it. When the database is created, you will usually get a message what to use for the DNS. If you are unsure what this information is, you will need to contact your host to get the correct information.
Have you hugged someone today?

Locked

Return to “[3.0.x] Support Forum”