php artisan migrate not working when trying to set up sqlite database

Question

I have just cloned a laravel project I was working on, into a new machine. I have re-installed all the dependencies, including sqlite and re-configured the database details in the .env file. However, when I try to run php artisan migrate, I get the following error:

 Illuminate\Database\QueryException 

  could not find driver (SQL: PRAGMA foreign_keys = ON;)

  at C:\xampp\htdocs\Soko\vendor\laravel\framework\src\Illuminate\Database\Connection.php:759
    755▕         // If an exception occurs when attempting to run a query, we'll format the error
    756▕         // message to include the bindings with SQL, which will make this exception a
    757▕         // lot more helpful to the developer instead of just the database's errors.
    758▕         catch (Exception $e) {
  ➜ 759▕             throw new QueryException(
    760▕                 $query, $this->prepareBindings($bindings), $e
    761▕             );
    762▕         }
    763▕     }

  1   C:\xampp\htdocs\Soko\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70
      PDOException::("could not find driver")

  2   C:\xampp\htdocs\Soko\vendor\laravel\framework\src\Illuminate\Database\Connectors\Connector.php:70
      PDO::__construct()

What could be the problem?

Here is my .env file

LOG_CHANNEL=stack
LOG_DEPRECATIONS_CHANNEL=null
LOG_LEVEL=debug

DB_CONNECTION=sqlite

BROADCAST_DRIVER=log

I had already come across a similar question. And I have tried going to my php.ini file, there are two apparently, one for development and the other for production. I have edited them both, by removing the semicolon in (;extension=pdo_sqlite.dll) and (;extension=sqlite3). I have also tried to tab them out, but as per the comments, nothing has worked.

Does this answer your question? laravel and phpunit: could not find driver (SQL: PRAGMA foreign_keys = ON;) — aimme
– aimme, Commented Aug 28, 2022 at 1:42
I had already come across that solution. And I have tried going to my php.ini file, there are two apparently, one for development and the other for production. I have edited them both, by removing the semicolon in (;extension=pdo_sqlite.dll) and (;extension=sqlite3). I have also tried to tab them out, as per the comments, nothing has worked. — Felicity
– Felicity, Commented Aug 28, 2022 at 17:55
So there are actually three php.ini files. For windows that is. And that's what's confusing. There is one for development, another for production and now the main one. To be safe you need to change the main one, or all three. Thats what worked for me — Felicity
– Felicity, Commented Aug 28, 2022 at 22:01

Hosserin Ibrahim · Accepted Answer · 2022-08-28 06:27:15Z

1

check file .env exist and the same name.
check in .env file database name and configuration exist.
check database exist in SQLite.
check command php artisan return all Laravel commands, if doesn't work execute composer i.
then check the error: could not find driver (SQL: PRAGMA foreign_keys = ON;).

answered Aug 28, 2022 at 6:27

Hosserin Ibrahim

2541 silver badge11 bronze badges

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

2 Comments

Felicity Over a year ago

I have added my .env file. I had already set the database to SQLite. All PHP commands are running fine. As for number 5, how do I check that? I think the issue is that it's still pointing to the SQL server instead of the SQLite one, I don't know why

Hosserin Ibrahim Over a year ago

really I'm not using SQLite

Collectives™ on Stack Overflow

php artisan migrate not working when trying to set up sqlite database

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related