Monica: Error on fresh install with SQLite

[jdambron]

When trying to perform a fresh installation using SQLite I have an error during the php artisan migrate command.
The errors are the following :

Migration table created successfully.


  [Illuminate\Database\QueryException]                                                                 
  SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL (SQL: alter   
  table "users" add column "account_id" integer not null)                                              



  [Doctrine\DBAL\Driver\PDOException]                                                     
  SQLSTATE[HY000]: General error: 1 Cannot add a NOT NULL column with default value NULL  



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

[erdmenchen]

Duplicate of #137 (dont know why it was closed, as it is not fixed obviously).

[djoc]

Any update on this? At the moment Monica cannot be used with SQLite

[stevenbuehner]

The main reason why it cannot be used with sqlite is the usage of ENUM Type-field in databases/2017_06_07_173437_add_multiple_genders_choices.php

I was able to fix everything else in the migration-table up to this point. Wouldn't it make sense to use a enum-table instead of the enum-type? This would help in ways to be more compatible with other db drivers?

[stevenbuehner]

I need to correct myself. Enum-types are used more often in the migration-files. So I can't say how much effort it takes to change the stuff in the background.

Still. Why using enums at all? :-) Aren't enums considered "evil" anyways? (https://www.planetgeek.ch/2009/07/01/enums-are-evil/)

[djaiss]

Duplicate of #137

[asbiin]

https://stackoverflow.com/questions/20822159/laravel-migration-with-sqlite-cannot-add-a-not-null-column-with-default-value-n