Level 88
You only need to change the DB_CONNECTION variables to sqlite. Also don't forget to create the database.sqlite file in the storage directory!
Nov 8, 2015
8
Level 5
SQLite Database Config not working for Artisan
I try to use Lumen with SQLite.
If I have this setup in my .env
DB_CONNECTION=sqlite DB_DATABASE='../storage/database.sqlite'
then, this is working: $results = User::all();
but, when I try to migrate via Artisan, I'll get:
"Database (../storage/database.sqlite) does not exists.
When I change my .env to:
DB_CONNECTION=sqlite DB_DATABASE='storage/database.sqlite'
then Artisan is working, but $results = User::all() give this error: Database (storage/database.sqlite) does not exist.
It seems that Artisan is looking for that SQLite Database from another folder?
Level 5
@bobbybouwmann if I do only that, I'll get this error in Artisan AND when I try to use Eloquent also:
Database (C:\xampp\htdocs\cvstefan/database/database.sqlite) does not exist.
My database is in storage folder and named database.sqlite
Level 88
I guess they changed the location then. You can find this in the source code of lumen-framework
'sqlite' => [
'driver' => 'sqlite',
'database' => env('DB_DATABASE', database_path('database.sqlite')),
'prefix' => env('DB_PREFIX', ''),
],
So you need to place the database.sqlite file in the database directory ;) That should fix it!
Lumen-framework: https://github.com/laravel/lumen-framework/blob/5.1/config/database.php#L54
Level 5
@bobbybouwmann after replacing to database folder all is working perfectly. Thanks for your help
Level 3
Had the same issue. This is how you sove it:
DB_DATABASE=../database/database.sqlite
You need the ../ because laravel loads from public/index.php. I hope it helps.
1 like
Level 22
@banago that works indeed but it fails when using the artisan CLI :(.
I had to change it to #DB_DATABASE= so it works both in browser and the commandline.
I've raised an issue on Github for this problem.
Level 3
@Juukie I ran into that too. It's great you reported it. Thanks.
Level 3
This is the solution to fix sqlite connection error on localhost(windows) https://www.youtube.com/watch?v=aoi_oLF9V8o
Please or to participate in this conversation.