Unable to install package on laravel 11 project.

[redtusker]

when adding package using composer getting this error, even after doing some tweaks of database migration.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'schedule_task_laravel.schedules' doesn't exist (Connection: mysql, SQL: select * from schedules where status = 1 and schedules.deleted_at is null)

at vendor\laravel\framework\src\Illuminate\Database\Connection.php:813
809▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
810▕ );
811▕ }
812▕
➜ 813▕ throw new QueryException(
814▕ $this->getName(), $query, $this->prepareBindings($bindings), $e
815▕ );
816▕ }
817▕ }

i A table was not found: You might have forgotten to run your database migrations.
https://laravel.com/docs/master/migrations#running-migrations

1 [internal]:0
RobersonFaria\DatabaseSchedule\Console\Scheduling\Schedule::__construct(Object(RobersonFaria\DatabaseSchedule\Http\Services\ScheduleService), Object(Illuminate\Console\Scheduling\Schedule))

2 vendor\laravel\framework\src\Illuminate\Database\Connection.php:407
PDOException::("SQLSTATE[42S02]: Base table or view not found: 1146 Table 'schedule_task_laravel.schedules' doesn't exist")

[Zwartpet]

Same for laravel 10 on php 8.1

[BabarAslamm]

I find solution to install it on laravel 11
folllow these steps

1. if you run composer require robersonfaria/laravel-database-schedule (optional)
   composer remove robersonfaria/laravel-database-schedule
2. Create Schedule model and migration (Reason : config file database-schedule.php use 'model' => Schedule::class,)
   php artisan make:model Schedule -m

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('schedules', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->integer('status')->default(1);
            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('schedules');
    }
};

3. php artisan migrate

4. composer require robersonfaria/laravel-database-schedule

5. Now copy all migrations file from vendor\robersonfaria\laravel-database-schedule\database\migrations
   and paste in database\migrations

6. modify vendor folder migration name is 2018_07_17_172600_create_schedule_table.php

 <?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Config;
use Illuminate\Support\Facades\Schema;

class CreateScheduleTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        // Drop the 'schedules' table if it exists
        Schema::dropIfExists('schedules');

        Schema::create(Config::get('database-schedule.table.schedules', 'schedules'), function (Blueprint $table) {
            $table->increments('id');
            $table->string('command');
            $table->text('params')->nullable();
            $table->string('expression');
            $table->boolean('even_in_maintenance_mode')->default(false);
            $table->boolean('without_overlapping')->default(false);
            $table->boolean('on_one_server')->default(false);

            $table->string('webhook_before')->nullable();
            $table->string('webhook_after')->nullable();
            $table->string('email_output')->nullable();
            $table->boolean('sendmail_error')->default(false);

            $table->boolean('status')->default(true);

            $table->timestamps();
            $table->softDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists(Config::get('database-schedule.table.schedules', 'schedules'));
    }
}

7. php artisan migrate

8. php artisan vendor:publish --provider="RobersonFaria\DatabaseSchedule\DatabaseSchedulingServiceProvider" --tag="config"