@experimentor yes i do

@alkhatib Ideally, RefreshDatabase should migrate all tables before running the tests. If the error is saying that the table does not exist, maybe its getting dropped in some other migration. I'd run the migrations fresh on a test / local database to verify if the settings table gets generated.

I can't think of anything else ... other than maybe clearing caches before running tests.

@experimentor My friend, when trying to get any table inside the provider, we get the same error. ex : User::all(); error General error: 1 no such table: users

When these two lines are disabled, the test runs correctly but the database is being emptied.

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

@Tray2 There are no files outside the features directory. I have only "renders successfully"

@Tray2 error caused by requesting a settings table inside DashboardPanelProvider

@alkhatib You need to migrate the database for your tests.

@Tray2 I used trait DatabaseMigrations . but same error

pest()
    ->extend(Tests\TestCase::class)
    ->use(Illuminate\Foundation\Testing\DatabaseMigrations::class)
    ->in('Feature');

@alkhatib Make sure that you have a migration file for settings.

@Tray2 I am sure all tables have been migrated. The problem is not of the settings table not exists, When requesting any table inside AppProvider, We will get the same error table does not exist.

Disable fetch from settings table

class DashboardPanelProvider extends PanelProvider
{
    public function panel(Panel $panel): Panel
    {
        return $panel
            ->default()
            // ->path(Settings::dashboardPrefix())
            ->id('dashboard');
  }
}

fetch from users table

class AppServiceProvider extends ServiceProvider
{
    public function boot(): void
    {
        dd(User::first());
  }
}

error

 FAILED  Tests\Feature\Livewire\Auth\LoginTest > it renders successfully               QueryException   
  SQLSTATE[HY000]: General error: 1 no such table: users (Connection: sqlite, SQL: select * from "users" limit 1)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:407
    403▕             // For select statements, we'll simply execute the query and return an array
    404▕             // of the database result set. Each element in the array will be a single
    405▕             // row from the database table, and will either be an array or objects.
    406▕             $statement = $this->prepared(
  ➜ 407▕                 $this->getPdoForSelect($useReadPdo)->prepare($query)
    408▕             );
    409▕ 
    410▕             $this->bindValues($statement, $this->prepareBindings($bindings));
    411▕ 

      +14 vendor frames 
  15  app/Providers/AppServiceProvider.php:37
      +11 vendor frames 
  27  tests/TestCase.php:11


  Tests:    1 failed (0 assertions)
  Duration: 19.62s

When all fetch queries disabled then run test

/** @test */
it('Login successfully', function () {
    $user = user();
    $response = $this->json('POST', '/login', [
        Fortify::username() => $user->email,
        'password' => 'password',
    ]);
    $response->assertOk();
    $this->assertAuthenticated();
});

   PASS  Tests\Feature\Livewire\Auth\LoginTest
  ✓ it Login successfully                                                                          9.98s  

  Tests:    1 passed (2 assertions)
  Duration: 11.50s

@alkhatib First you get

 General error: 1 no such table: settings

Then you comment out the code that fetches the settings, and then you get this.

General error: 1 no such table: users

That means that the migrations has not been ran, before you are attempting to access the tables in the database.

@Tray2 That means Provider boot method executes before table creation.