Have you created a database.sqlite file in the database folder?
QueryException in Connection.php while using sqlite
Hey guys,
This is my first time using Laravel and I'm trying to do a fairly simple tutorial to familiarize myself with it.
https://auth0.com/blog/creating-your-first-laravel-app-and-adding-authentication/
I've made a number of changes to get things to work with the latest version of laravel and with my local environment.
I'm using sqlite instead of mysql and seem to be having some trouble with the auth tables. I've updated my .env and config/database.php to reflect the change from mysql to sqlite as such:
line 16 in config/database.php is now 'default' => 'sqlite',
username/password/etc have been commented out of my .env:
DB_CONNECTION=sqlite #DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=./database/database.sqlite #DB_USERNAME=homestead #DB_PASSWORD=secret
php artisan migrate worked just fine and everything looked as if it was working until I tried to register a user. I was first presented with the error:
QueryException in Connection.php line 647: Database (homestead) does not exist. (SQL: select count(*) as aggregate from "users" where "email" = [email protected])
which didn't make a lot of sense since that wasn't the database name. I thought it might be a cache issue so I used php artisan config:cache but now I'm getting the following error message and nothing I've tried has been able to get it to go away.
QueryException in Connection.php line 647: Database (./database/database.sqlite) does not exist. (SQL: select count(*) as aggregate from "users" where "email" = [email protected])
Any help resolving this would be appreciated since I'm otherwise enjoying Laravel :)
Please or to participate in this conversation.