Sqlite support?
Created 7 years ago by robm

I'm running v3 locally just for testing, and I can't seem to get it working with Sqlite for the DB.

My .env file has the following: DB_CONNECTION=sqlite DB_DRIVER=sqlite DB_HOST=localhost DB_DATABASE=pyrocms.sqlite

but when I try to run the installer, I just get the following error: [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 17 database schema has changed (SQL: select * from sqlite_master where type = 'table' and name = applications)

This is on Win10 running PHP7.1 with all the necessary extensions.

Any ideas??

ryanthompson  —  7 years ago

You know.. we've always had issues with SQLite (and through research many others on other projects of size do as well).

At the moment - I think I need to remove support for it for the time being. It seems there are way too many quirks that pop up. One of Pyro's main purposes is to automat schema management through Laravel's schema utilities. We don't do anything outside of Laravel's services so I assume this stems into deeper issues with compatibility / capability :-/

Sorry this isn't much help - but if you could, please try using a "real" database for now.

robm  —  7 years ago

That's weird, because I've had no problems with Laravel itself or other CMS's based on Laravel.

For the size of the site I'm doing, and for testing purposes, using a "real" database is overkill and unnecessary.

Thanks anyway!