Back to Hospitality Support

amdad
amdad

Update failed

"SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL (SQL: alter table "hospitality_booking" add column "customer_id" varchar not null)" on-line 666 of /home/dev/domains/devil.heel/public_html/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Problem show up when trying to install on sqlite db.

gergo85
gergo85

Please modify the line 12 of /plugins/indikator/hospitality/updates/add_extra_field_to_tables.php file to: $table->string('customer_id', 5)->default(0);

Is it works?

amdad
amdad

Of course it works. Push it. Push.

Zero by default instead of null? How you want it.

1-3 of 3