Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

bulgaria_mitko's avatar

php artisan migrate gives me an error could not find driver

im using Ubuntu 16.04 and from my php.ini i have enabled: extension=php_pdo_mysql.dll and extension=php_pdo_sqlite.dll

my .env file is:

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

and when i write: php artisan migrate

i get this error:

[Illuminate\Database\QueryException] could not find driver (SQL: select * from sqlite_master where type = 'table ' and name = migrations)

[Doctrine\DBAL\Driver\PDOException] could not find driver

[PDOException] could not find driver

0 likes
19 replies
ejdelmonico's avatar

Did you create the empty database.sqlite file?

1 like
bulgaria_mitko's avatar

nothing is working :( i tried: composer install again composer require doctrine/dbal composer update apt-get install php-doctrine-dbal i deleted database.sqlite and create again touch /database/database.sqlite php artisan migrate:refresh getting the same error:

[Illuminate\Database\QueryException] could not find driver (SQL: select * from sqlite_master where type = 'table ' and name = migrations)

[Doctrine\DBAL\Driver\PDOException] could not find driver

[PDOException] could not find driver

bulgaria_mitko's avatar

im fighting with this problem for 2 days now :( still no luck :(

bulgaria_mitko's avatar

i want to update my progress i removed the composer doctrine/dbal package by running this command composer remove doctrine/dbal and then i run php artisan migrate -vvv and then i got those lovely errors :) [Illuminate\Database\QueryException] could not find driver (SQL: select * from sqlite_master where type = 'table ' and name = migrations)

Exception trace: () at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:770 Illuminate\Database\Connection->runQueryCallback() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:726 Illuminate\Database\Connection->run() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:351 Illuminate\Database\Connection->select() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:55 Illuminate\Database\Schema\Builder->hasTable() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php:156 Illuminate\Database\Migrations\DatabaseMigrationRepository->repositoryExists() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:515 Illuminate\Database\Migrations\Migrator->repositoryExists() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:92 Illuminate\Database\Console\Migrations\MigrateCommand->prepareDatabase() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:58 Illuminate\Database\Console\Migrations\MigrateCommand->fire() at n/a:n/a call_user_func_array() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Container/Container.php:508 Illuminate\Container\Container->call() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Console/Command.php:169 Illuminate\Console\Command->execute() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Command/Command.php:254 Symfony\Component\Console\Command\Command->run() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Console/Command.php:155 Illuminate\Console\Command->run() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Application.php:821 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Application.php:187 Symfony\Component\Console\Application->doRun() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Application.php:118 Symfony\Component\Console\Application->run() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:121 Illuminate\Foundation\Console\Kernel->handle() at /var/www/html/Laracast/07Laravel/project/artisan:35

[PDOException] could not find driver

Exception trace: () at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:119 PDO->__construct() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:119 Illuminate\Database\Connectors\Connector->createPdoConnection() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:56 Illuminate\Database\Connectors\Connector->createConnection() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connectors/SQLiteConnector.php:37 Illuminate\Database\Connectors\SQLiteConnector->connect() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:147 Illuminate\Database\Connectors\ConnectionFactory->Illuminate\Database\Connectors{closure}() at n/a:n/a call_user_func() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:965 Illuminate\Database\Connection->getPdo() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:986 Illuminate\Database\Connection->getReadPdo() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423 Illuminate\Database\Connection->getPdoForSelect() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:333 Illuminate\Database\Connection->Illuminate\Database{closure}() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:763 Illuminate\Database\Connection->runQueryCallback() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:726 Illuminate\Database\Connection->run() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Connection.php:351 Illuminate\Database\Connection->select() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:55 Illuminate\Database\Schema\Builder->hasTable() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Migrations/DatabaseMigrationRepository.php:156 Illuminate\Database\Migrations\DatabaseMigrationRepository->repositoryExists() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php:515 Illuminate\Database\Migrations\Migrator->repositoryExists() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:92 Illuminate\Database\Console\Migrations\MigrateCommand->prepareDatabase() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php:58 Illuminate\Database\Console\Migrations\MigrateCommand->fire() at n/a:n/a call_user_func_array() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Container/Container.php:508 Illuminate\Container\Container->call() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Console/Command.php:169 Illuminate\Console\Command->execute() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Command/Command.php:254 Symfony\Component\Console\Command\Command->run() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Console/Command.php:155 Illuminate\Console\Command->run() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Application.php:821 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Application.php:187 Symfony\Component\Console\Application->doRun() at /var/www/html/Laracast/07Laravel/project/vendor/symfony/console/Application.php:118 Symfony\Component\Console\Application->run() at /var/www/html/Laracast/07Laravel/project/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php:121 Illuminate\Foundation\Console\Kernel->handle() at /var/www/html/Laracast/07Laravel/project/artisan:35

bulgaria_mitko's avatar
bulgaria_mitko
OP
Best Answer
Level 6

I FINALLY FIX IT :D i just need to run this command:

sudo apt-get install php7.1-sqlite3

and then other error, lol, laravel loves me <3

[Illuminate\Database\QueryException] Database (databaseName) does not exist. (SQL: select * from sqlite_master where type = 'ta ble' and name = migrations)

[InvalidArgumentException] Database (databaseName) does not exist.

so in my case i created the database.sqlite file with touch database/database.sqlite

then in config/database.php i changed the 'default' => env('DB_CONNECTION', 'sqlite'), to sqlite

and in .env file i just deleted those lines of code:

DB_PORT=3306 DB_DATABASE=database DB_USERNAME=root DB_PASSWORD=secret

and finally everything is working fine :D

Migration table created successfully. Migrated: 2017_01_11_190412_create_cards_table

hope this will help to someone ;) :P

16 likes
Gizmo's avatar

sudo apt-get install php7.0-sqlite3 <- that helped me.

2 likes
rollerdead's avatar

i got same error but im using mysql not sqlite. anyone got same problem?

pvaitonis's avatar

sudo apt-get install php7.1-mysql php7.1-sqlite3

or

sudo apt-get install php7.2-mysql php7.1-sqlite3

check your current version of php and drivers for that version (install/update if not match) on apache.

2 likes
peter_j's avatar

I had the same problem and in my case it was not enough to merely enable SQLite on my local server.

What solved this problem was modifying the php.ini file. Look for the line: extension = pdo_sqlite and make sure it is enabled (remove the semicolon in front, if there is one). It worked in my case!

Chimsy's avatar

Thank you for helping me out, I am new to Laravel and this solution just saved me. Thank you

dongun's avatar
php artisan cache:clear

you mean

Please or to participate in this conversation.