Laravel: SQLite database cannot be found

Question

I always got an error saying as:

Database (/Users/yonamineakio/Desktop/laravel_portfolio/database/database.sqlite) does not exist. (SQL: PRAGMA foreign_keys = ON;)

I think I'm setting some values correctly but the error as mentioned above always occurred. Here is some files:

database.php

?php

use Illuminate\Support\Str;

return [
    'default' => env('DB_CONNECTION', 'sqlite'),
    'connections' => [
        'sqlite' => [
            'driver' => 'sqlite',
            'url' => env('DATABASE_URL'),
            'database' => env('DB_DATABASE', database_path('database.sqlite')),
            'prefix' => '',
            'foreign_key_constraints' => env('DB_FOREIGN_KEYS', true),
        ]
    ]
]

.env

DB_CONNECTION=sqlite
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=/database/database.sqlite
DB_USERNAME=root
DB_PASSWORD=

Person.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use llluminate\Database\Eloquent\Builder;

class Person extends Model
{
    protected $guarded = array('id');
    public static $rules = array(
        'name'=> 'required',
        'mail'=> 'email',
        'age'=> 'integer'
    );
}

PersonController.php

<?php

namespace App\Http\Controllers;
use App\Person;
use Illuminate\Http\Request;

class PersonController extends Controller
{
    public function index(Request $request) {
        $items = Person::all();
        $user = Auth::user();
        $params = ['user'=>$user, 'items'=>$items];
        return view('person.index', $params);
    }

    public function create(Request $request) {
        return view('person.create');
    }

    public function store(Requst $request) {
        $this->validate($request, Person::$rules);
        $person = new Person;
        $form = $request->all();
        unset($form['_token']);
        $person->fill($form)->save();
        return view('perosns');
    }

    public function show(Request $request) {
        $id = $request->id;
        $person = Person::find($id);
        return view('persons.show', ['person'=> $person]);
    }

    public function edit(Request $request) {
        $id = $requset->id;
        $person = Person::find($id);
        return view('persons', ['person' => $person]);
    }

    public function update(Reqeust $reqeuest){
        $this->validate($reqeuest, Person::$rules);
        $id = $request->id;
        $person = Person::find($id);
        $form = $request->all();
        $person->fill($form)->save();
        return redirect('/persons');
    }

    public function remove(Request $request){
        Person::find($request->id)->delete();
        return redirect('/person');
    }
}

I completely have no idea what to do for solving the above problem. Anyone who know what to do about it please help me. If you want more information, please let me know.

Thank you.

just give DB_CONNECTION name in .env file comment rest of DB variable with # it will find sqlite file from default path it self. also create database.sqlite file under your database directory too. — umefarooq
– umefarooq, Commented Feb 5, 2020 at 5:41

LobsterBaz · Accepted Answer · 2020-02-05 07:47:59Z

1

Just like user @umefarooq commented, the problem is in your .env file.

Here's a configuration using only the relevant environment variable for SQLite:

DB_CONNECTION=sqlite
#DB_HOST=127.0.0.1 ## Not required for SQLite
#DB_PORT=3306 ## Not required for SQLite
DB_DATABASE=/database/database.sqlite
#DB_USERNAME=root ## Not required for SQLite
#DB_PASSWORD= ## Not required for SQLite
DB_FOREIGN_KEYS=true

Make sure you run your migrations with php artisan migrate and check that your database file exists in: /Users/yonamineakio/Desktop/laravel_portfolio/database/database.sqlite.

See Laravel documentation for SQLite:

https://laravel.com/docs/6.x/database#configuration

answered Feb 5, 2020 at 7:47

LobsterBaz

2,09313 silver badges21 bronze badges

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

1 Comment

A Y Over a year ago

Thank you for your comment. I solved this issue by referencing absolute path on my .env file. changed value of DB_DATABASE to "/Users/yonamineakio/Desktop/laravel_portfolio/database/database.sqlite" in .env file

Collectives™ on Stack Overflow

Laravel: SQLite database cannot be found

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related