TromsFylkestrafikk / ragnarok

Harvest public transport data for statistics usage
0 stars 0 forks source link

Migration fails #78

Closed jbtfk closed 4 months ago

jbtfk commented 4 months ago

Creation of table 'ragnarok_sinks' fails - Invalid default value for 'status' (2023_06_07_100000_ragnarok_tables.php):

Error
 Illuminate\Database\QueryException

  SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'status' (Connection: mysql, SQL: create table `ragnarok_sinks` (`id` char(64) not null comment 'Unique sink ID', `title` char(255) not null comment 'Title/name of sink for presentation', `single_state` tinyint(1) not null comment 'Chunks represent a non-incremental, single state in DB', `impl_class` varchar(255) not null comment 'Implementation of \\Ragnarok\\Sink\\Sinks\\SinkBase', `status` enum('live', 'suspended', 'disabled') not null default 'active' comment 'Sink is live or in suspended state', `created_at` timestamp null, `updated_at` timestamp null, primary key (`id`)) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:829
    825▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    826▕                 );
    827▕             }
    828▕
  ➜ 829▕             throw new QueryException(
    830▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    831▕             );
    832▕         }
    833▕     }

      +9 vendor frames

  10  database/migrations/2023_06_07_100000_ragnarok_tables.php:22
      Illuminate\Support\Facades\Facade::__callStatic()
      +35 vendor frames

  46  artisan:37
      Illuminate\Foundation\Console\Kernel::handle()
tfk-kaare commented 4 months ago

Fixed.