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
Did you create the empty database.sqlite file?
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@yahoo.com There is many possibility to cause this and really sorry but it's not possible state all here. BTW you can try google for it.
im fighting with this problem for 2 days now :( still no luck :(
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
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
sudo apt-get install php7.0-sqlite3 <- that helped me.
@bulgaria_mitko@yahoo.com you save my life, thanks for the fix
it works,thx
i got same error but im using mysql not sqlite. anyone got same problem?
i have the same problem
for the mysql user ... update / install mysql
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.
@pvaitonis you saved my day thank you very much
@BULGARIA_MITKO@YAHOO.COM - php artisan clear-cache after making changes to .env file.
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!
Thank you for helping me out, I am new to Laravel and this solution just saved me. Thank you
php artisan cache:clear
you mean
Please or to participate in this conversation.