SQLite error for migration without default value in Laravel

Question

I have a Laravel project with a MySQL database, and my migration works perfectly, but my problem is when I change the MySQL connection to SQLite and run the migration, I get an error for fields that do not have a default value. What is the solution for this? I found this solution for that is dirty, and I have to add this condition to many migrations.

$driver = Schema::connection($this->getConnection())
    ->getConnection()->getDriverName();
Schema::table('proposals', function (Blueprint $table) use ($driver) {
    if ($driver === 'sqlite') {
        $table->unsignedBigInteger('final_amount')->default('');
    } else {
        $table->unsignedBigInteger('final_amount');
    }
});

Error

SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL

unsignedBigInteger but you set default to empty string? try use 0 instead. — Bagus Tesa
– Bagus Tesa, Commented May 1, 2022 at 12:39
sure, it says "General error: 1 Cannot add a NOT NULL column with default value NULL." — Bagus Tesa
– Bagus Tesa, Commented May 1, 2022 at 13:22
@connectaadmin it would be faster for you to try his suggestion than arguing it. If you want to add a new column in an existing table with entries, either set a valid default or set it nullable. — N69S
– N69S, Commented May 1, 2022 at 13:29

N69S · Accepted Answer · 2022-05-01 13:30:53Z

1

If you want to add a new column in an existing table with entries, either set a valid default or set it nullable

 $driver = Schema::connection($this->getConnection())->getConnection()->getDriverName();
    Schema::table('proposals', function (Blueprint $table) use ($driver){
        if ($driver === 'sqlite'){
            $table->unsignedBigInteger('final_amount')->default(0);
        }else{
            $table->unsignedBigInteger('final_amount')->nullable();
        }
    });

answered May 1, 2022 at 13:30

N69S

17.3k4 gold badges25 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQLite error for migration without default value in Laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related