Laravel and PHPUnit: could not find driver (SQL: PRAGMA foreign_keys = ON;)
I have run my Laravel application with PHPUnit.
Everything is fine until at some point, when I run my test again, it turns out with this error.
Illuminate\Database\QueryException: could not find driver (SQL: PRAGMA foreign_keys = ON;)
Caused by PDOException: could not find driver
Here's my phpunit.xml file:
<phpunit xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="./vendor/phpunit/phpunit/phpunit.xsd"
bootstrap="vendor/autoload.php"
colors="true">
<testsuites>
<testsuite name="Unit">
<directory suffix="Test.php">./tests/Unit</directory>
</testsuite>
<testsuite name="Feature">
<directory suffix="Test.php">./tests/Feature</directory>
</testsuite>
</testsuites>
<filter>
<whitelist processUncoveredFilesFromWhitelist="true">
<directory suffix=".php">./app</directory>
</whitelist>
</filter>
<php>
<server name="APP_ENV" value="testing"/>
<server name="BCRYPT_ROUNDS" value="4"/>
<server name="CACHE_DRIVER" value="array"/>
<server name="DB_CONNECTION" value="sqlite"/>
<server name="DB_DATABASE" value=":memory:"/>
<server name="MAIL_MAILER" value="array"/>
<server name="QUEUE_CONNECTION" value="sync"/>
<server name="SESSION_DRIVER" value="array"/>
<server name="TELESCOPE_ENABLED" value="false"/>
</php>
</phpunit>
- OS: Windows 10
- PHP version: 7.4.11
- SQLite version: 3.19.1
How can I fix this error in Laravel 6 and PHPUnit?
Solution
This is actually happening after I upgraded my PHP version in Laragon. The solution is to enable pdo_sqlite in the PHP extension in Laragon.
That's it. This answer was found on PHPUnit SQLite error after updating Laragon (PDOException: could not find driver).
- Eloquent query for filter with multiple params from url (Some parameters may not be specified)
- Why I'm getting 'Non-static method should not be called statically' when invoking a method in a Eloquent model?
- Add sql table column before or after specific other column - by migrations in Laravel 4.1
- How to show DBMS name and version in laravel view?
- How to rename the summary section?
- Using factory in PHPUnit provider fails
- 404 URLs does not pass through web Middlewares in Laravel 11, php8.2 and TwillCMS
- storePubliclyAs not saving in public folder
- Disable sentry for laravel on local environment
- Laravel / Intervention Image Class - class not found
- Laravel - API login authentication check
- Order list not view properly in laravel API
- Possible to make laravel eloquent query or DB facade which I get result from raw SQL query?
- Livewire 3.6.10 with Laravel 11 – wire:click, wire:submit, and wire:model not working
- Laravel: Listen for Model save or update (after or before they're done)
- How can I manually return or throw a validation error/exception in Laravel?
- Target class [admin] does not exist
- Convert a collection of models to an array of models
- Laravel N+1 when accessing a pivot relationship and the related model (unit)
- Laravel pagination: Append query parameter without value
- How can I make my own double colon path in a blade component?
- Laravel naming convention for blade files
- How to colorize summarizers and/or their output?
- Get all models that have a specific relation
- Target class [config] does not exist error in laravel for testing
- I am getting array data from api response. I want to save this data to my database using laravel
- Laravel and PHPUnit: could not find driver (SQL: PRAGMA foreign_keys = ON;)
- How in user model with pivot to tasks to restrict to only uncompleted tasks?
- psr-4 autoloading issue in Laravel
- Can't receive broadcasted message from laravel echo server