laravel-enso/core

companies_upgrade fails

wbovela opened this issue · 0 comments

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).