Database (database/database.sqlite) does not exist. Database works from artisan tinker

Question

I created my database.sqlite file in the database folder. My .env file contents are :

DB_CONNECTION=sqlite
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=absolute\path\to\database\database.sqlite
DB_USERNAME=admin
DB_PASSWORD=

When I run php artisan tinker and DB::table('users')->get(); I get the info from the database.

My DatabaseController is:

class DatabaseController extends Controller
{
    public function main()
    {
        $users = DB::table('users')->get();

        return view('database',compact($users));
    }
}

Yet when I request /database path I get the error:

QueryException in Connection.php line 647: Database (database/database.sqlite) does not exist. (SQL: select * from "users")

UPDATE: A temporary fix is to change the database.php from the config folder:

  'connections' => [

    'sqlite' => [
        'driver' => 'sqlite',
        'database' => 'absolute\path\database\database.sqlite', 
        'prefix' => '',
    ],

Instead of using env('DB_DATABASE', database_path('database.sqlite')), which returns database/database.sqlite not my absolute path.

how do your run your server? php artisan serve or apache/nginx? — dparoli
– dparoli, Commented Mar 31, 2017 at 12:43
heh, solution for me was to remove the DB_DATABASE entry from my .env altogether. That way it defaulted to using the database_path() function that correctly allowed my app to interact with the database. — Chris
– Chris, Commented Aug 4, 2017 at 18:34

Alexey Mezenin · Accepted Answer · 2017-03-31 12:56:19Z

66

You need to use full path, something like:

DB_DATABASE=/home/laravel-project/database/database.sqlite

answered Mar 31, 2017 at 12:56

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

wafi Over a year ago

simpler way is to use "../database/database.sqlite"

TuGordoBello Over a year ago

thats for mac and linux, but windows?

DevonDahon Over a year ago

@wafi With Laravel 7.3, writing "../database/database.sqlite" works for the migration, but when trying to login/register, the database is not found. It's found if reverting to database/database.sqlite, but then php artisan migrate doesn't find it anymore, so the solution with full path the good one.

Sanuja Ariyapperuma Over a year ago

@TuGordoBello for windows use full path replacing single backslash double backslash \\. Eg : DB_DATABASE=C:\\Project_Folder\\database\\database.sqlite

El Sordo Over a year ago

If you are using Ubuntu WSL in Windows the absolute path must include /mnt/c/absolutepath Stop php artisan serve, config:cache, config:clear, serve This is what worked for me.

|

gdfgdfg · Accepted Answer · 2017-05-29 15:15:30Z

22

If you remove DB_DATABASE=... from your .env file and use the path in the config/database.php:

'database' => env('DB_DATABASE', database_path('database.sqlite')),...

(if your database.sqlite file is in database/ folder), it will work, too.

answered May 29, 2017 at 15:15

gdfgdfg

3,5868 gold badges46 silver badges85 bronze badges

Comments

Alexandru Antochi · Accepted Answer · 2018-06-30 15:11:26Z

12

I ran the following commands:

php artisan config:cache

php artisan config:clear

php artisan serve - restarted the server

edited Jun 30, 2018 at 15:11

answered Apr 1, 2017 at 11:19

Alexandru Antochi

1,4653 gold badges21 silver badges44 bronze badges

Comments

Anastasios Selmani · Accepted Answer · 2018-12-13 12:55:57Z

8

In config/database.php file:

'sqlite' => [
              'driver' => 'sqlite',
              'database' => dirname(__DIR__).'/database/database.sqlite',
            ],

Then run following command:

php artisan config:cache
php artisan config:clear

edited Dec 13, 2018 at 12:55

Anastasios Selmani

3,7093 gold badges37 silver badges49 bronze badges

answered Dec 13, 2018 at 11:22

Sarwar Sikder

911 silver badge4 bronze badges

Comments

davychhouk · Accepted Answer · 2019-03-04 02:48:49Z

8

For those who still face this issue: https://laracasts.com/discuss/channels/general-discussion/database-databasedatabasesqlite-does-not-exist-error-on-running?page=1

Since sqlite only require DB_CONNECTION=sqlite in .env file so you just remove the other:

DB_HOST
DB_PORT
DB_DATABASE
DB_USERNAME
DB_PASSWORD

then save and run migration again. This was how I solved the problem. Cheers!

answered Mar 4, 2019 at 2:48

davychhouk

1,6132 gold badges19 silver badges21 bronze badges

Comments

Hassan Mahdian Manesh · Accepted Answer · 2021-02-01 10:05:38Z

7

As Chris said in the comments, the main solution is to completely delete DB_DATABASE from the .env file (in fact, only the first line of the following code is needed).

DB_CONNECTION=sqlite
DB_HOST=127.0.0.1
DB_PORT=3306
DB_USERNAME=admin
DB_PASSWORD=

answered Feb 1, 2021 at 10:05

Hassan Mahdian Manesh

1992 silver badges7 bronze badges

Comments

Joseph Ajibodu · Accepted Answer · 2023-02-21 19:57:19Z

4

✅ When using sqlite as your db, remove other DB env variables and it should work fine.

I faced the same problem and this solved it perfectly.

DB_DATABASE=sqlite

Remove the others.

answered Feb 21, 2023 at 19:57

Joseph Ajibodu

1,74615 silver badges18 bronze badges

Comments

Gpak · Accepted Answer · 2021-03-16 08:11:56Z

3

For Windows, you need to set up your path like this

DB_DATABASE="C:\\xampp\\htdocs\\project\\data\\database.db"

answered Mar 16, 2021 at 8:11

Gpak

3,3902 gold badges23 silver badges20 bronze badges

Comments

Hamza Sehouli · Accepted Answer · 2024-09-07 21:47:39Z

3

Just use this one:

DB_DATABASE=../database/database.sqlite

It worked for me.

answered Sep 7, 2024 at 21:47

Hamza Sehouli

2031 silver badge6 bronze badges

Comments

Gurpreet Gumber · Accepted Answer · 2024-02-15 04:57:55Z

2

In your .env file replace DB_DATABASE = database.sqlite to DB_DATABASE = directory_path/project_name/database/database.sqlite

For example: directory_path: C:/xampp/htdocs/project_name/database/database.sqlite

It works fine for me.

answered Feb 15, 2024 at 4:57

Gurpreet Gumber

313 bronze badges

Comments

Sergio Tskhovrebov · Accepted Answer · 2019-01-21 21:43:13Z

1

I think, that the problem here was because of Homestead. Absolute path to the database.sqlite file on local machine is not the same as the virtual machine one has.

In my case a had to set:

DB_DATABASE=/home/vagrant/code/database/database.sqlite

Or, you can just comment out this line and you are ready to go.

#DB_DATABASE=

edited Jan 21, 2019 at 21:43

answered Jan 7, 2019 at 0:29

Sergio Tskhovrebov

794 bronze badges

Comments

Limon Islam · Accepted Answer · 2024-01-05 16:30:31Z

1

Firstly Run this commands:

  php artisan config:cache
  php artisan config:clear
  php artisan serve

Then, You need to use full path, something like:

DB_DATABASE=/home/laravel-project/database/database.sqlite

Configur In config/database.php file:

'sqlite' => [
              'driver' => 'sqlite',
              'database' => dirname(__DIR__).'/database/database.sqlite',
            ],

Make Sure

DB_DATABASE=sqlite

edited Jan 5, 2024 at 16:30

answered Jan 5, 2024 at 16:22

Limon Islam

1312 silver badges4 bronze badges

Comments

Trevis Wamuthenya · Accepted Answer · 2021-01-11 20:20:38Z

0

go to the PHP folder from your C: directory and open the file php.ini. From there find extension=pdo_sqlite and remove ;

answered Jan 11, 2021 at 20:20

Trevis Wamuthenya

12 bronze badges

Comments

snaveware · Accepted Answer · 2022-08-28 10:48:54Z

0

Faced the same problem. Just had to create the database.sqlite file in the database directory and run my migrations

edited Aug 28, 2022 at 10:48

answered Aug 28, 2022 at 10:48

snaveware

112 bronze badges

Comments

Denise Ignatova · Accepted Answer · 2023-06-28 12:22:27Z

0

Hello this has helped me. I hope it could help someone else too.

DB_DATABASE=storage/database.sqlite

this is in the .env file of course before that just create the file with

touch storage/database.sqlite

answered Jun 28, 2023 at 12:22

Denise Ignatova

5435 silver badges7 bronze badges

Comments

André Pereira · Accepted Answer · 2023-11-20 11:32:07Z

0

The solution is easier than it seems. Just install:

sudo apt install php-sqlite3

Okay, now you can run the command:

php artisan migrate

The only configuration required in .env is:

DB_CONNECTION=sqlite

edited Nov 20, 2023 at 11:32

answered Oct 23, 2023 at 21:24

André Pereira

11 bronze badge

1 Comment

Diego Borba Over a year ago

Stack Overflow is an English-only site, but you can use the portuguese version of it: Stack Overflow em Português.

Collectives™ on Stack Overflow

Database (database/database.sqlite) does not exist. Database works from artisan tinker

16 Answers 16

6 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

16 Answers 16

6 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related