could not find driver issue

Are you using MySQL for your tests or SQLite?

@TRAY2 - sqlite

<env name="DB_CONNECTION" value="sqlite"/>
<env name="DB_DATABASE" value=":memory:"/>

i just switched to a new machine so i installed sqlite and everything but still get the same error

How are you calling that statement?

Check this link chapter 2 for info. https://www.sqlite.org/foreignkeys.html

i just reinstalled sqlite and now it's working fine . thnx @Tray2

Mark the thread as solved by making one of the replies as best answer.

You have to install the sqlite extension. In the follow link the resource: Link : https://www.getastra.com/kb/knowledgebase/how-to-install-sqlite-for-php-on-my-apache-nginx-server/

Inside PHPUNIT.XML you will find on the bottom some server options check this and change to mysql

        <server name="DB_CONNECTION" value="mysql"/>

that removes the error for me because I am testing with MYSQL NO WITH SQLITE

hope this helps someone else

sudo apt-get install php-sqlite3

For me reinstall sqlite worked fine. The foreign keys are enabled by Laravel in the config/database.php

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

So, if you get this error today it is likely that the sqlite extension for your php version is not correct.

Try to purge it and reinstall it by running sudo apt-get purge sqlite3 and re-install the extension by running

# run this to check which php.ini file is loaded 
php -i | grep php.ini

You should get an output like:

Configuration File (php.ini) Path => /etc/php/8.0/cli
Loaded Configuration File => /etc/php/8.0/cli/php.ini

From here, given that the php version if 8.0 you can install sqlite extension for it running

sudo apt-get install php8.0-sqlite3

If using mysql, add this line in phpunit.xml:

Then install the mysql package in php $ apt-get install php-mysql

Try again :)