companies_upgrade fails
wbovela opened this issue · 0 comments
wbovela commented
This is a bug.
Prerequisites
- [X ] Are you running the latest version?
- [X ] Are you reporting to the correct repository?
- [X ] Did you check the documentation?
- [X ] Did you perform a cursory search?
Description
when running php artisan enso:upgrade to 3.5.0 companies_upgrade fails:
Illuminate\Database\QueryException : SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "status" cannot be cast automatically to type boolean
Steps to Reproduce
upgrade
Expected behaviour
no errors
Actual behaviour
errors
Note:
In namespace LaravelEnso\Core\app\Commands\DatabaseUpgrades\CompaniesUpgrade these two statements appear to conflict:
line 22: $table->tinyInteger('status')->nullable()->after('pays_vat');
line 30: $table->boolean('status')->nullable(false)->change();
the actual type of the status column is smallint (postgres).