search

monicahq / monica

Personal CRM. Remember everything about your friends, family and business relationships.
https://beta.monicahq.com
GNU Affero General Public License v3.0
21.61k stars 2.16k forks source link

Migration fails when DB_PREFIX is non-empty #4751

Open mwnciau opened 3 years ago

mwnciau commented 3 years ago

On first installation of Monica, I set it up to use a DBPREFIX of monica. However, when trying to register, I would get an error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'temperature_scale' in 'field list' (SQL: insert into `monica_users` ...

Upon investigation, the last migration in the migrations table was 2018_08_29_222051_add_conversations_to_modules and the temperature_scale field was added in migration 2018_12_22_021123_add_weather_preferences_to_users.

Running php artisan migrate --force at this point gives me the error

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'monica_default_life_event_categories' already exists ...

So I deleted the two monica_default_life_* tables and ran it again to see if I could get any further, and

SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'm_default_life_event_types_default_life_event_category_id_foreign' is too long

It appears that the maximum identifier name in MySQL is 64, and default_life_event_types_default_life_event_category_id_foreign is 63 without the prefix so any prefix longer than 1 character will cause the migration to fail. This is a common issue in Laravel.

Changing the prefix to one character fails on migration 2019_01_06_135133_update_u2f_key_table.

Removing the prefix applied all the migrations successfully.

This is a self installed version of monica, v2.19.1.

It seems that the IDs for these identifiers should be manually set, and the maximum length of the DB_PREFIX option should be in the example .env file, or this option should be removed entirely.

overkill32 commented 3 years ago

I'm able to recreate this exactly. Same steps, same errors.

New install using this docker-compose example.

Docker-compose: 

version: "3.4"

services:
  app:
    build: ./app
    image: monica-app
    depends_on:
      - db
    env_file: .env
    ports:
      - 3001:80
    volumes:
      - data:/var/www/html/storage
    restart: always

  db:
    image: mysql:5.7
    environment:
      - MYSQL_ROOT_PASSWORD=loser123
      - MYSQL_DATABASE=monica
      - MYSQL_USER=homestead
      - MYSQL_PASSWORD=secret
    volumes:
      - mysql:/var/lib/mysql
    restart: always

volumes:
  data:
  mysql:

Docker install log file:

db_1   | 2020-12-31 17:46:40+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.32-1debian10 started.
db_1   | 2020-12-31 17:46:40+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
db_1   | 2020-12-31 17:46:40+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.7.32-1debian10 started.
db_1   | 2020-12-31T17:46:40.659776Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
db_1   | 2020-12-31T17:46:40.660009Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
db_1   | 2020-12-31T17:46:40.908860Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
db_1   | 2020-12-31T17:46:40.914379Z 0 [Note] mysqld (mysqld 5.7.32) starting as process 1 ...
db_1   | 2020-12-31T17:46:40.927850Z 0 [Note] InnoDB: PUNCH HOLE support available
db_1   | 2020-12-31T17:46:40.927897Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
db_1   | 2020-12-31T17:46:40.927914Z 0 [Note] InnoDB: Uses event mutexes
db_1   | 2020-12-31T17:46:40.927932Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
db_1   | 2020-12-31T17:46:40.927967Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
db_1   | 2020-12-31T17:46:40.927984Z 0 [Note] InnoDB: Using Linux native AIO
db_1   | 2020-12-31T17:46:40.928735Z 0 [Note] InnoDB: Number of pools: 1
db_1   | 2020-12-31T17:46:40.929132Z 0 [Note] InnoDB: Using CPU crc32 instructions
db_1   | 2020-12-31T17:46:40.936305Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
db_1   | 2020-12-31T17:46:40.973525Z 0 [Note] InnoDB: Completed initialization of buffer pool
db_1   | 2020-12-31T17:46:40.981193Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
db_1   | 2020-12-31T17:46:40.996464Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
db_1   | 2020-12-31T17:46:41.096917Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
db_1   | 2020-12-31T17:46:41.097125Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
db_1   | 2020-12-31T17:46:41.387848Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
db_1   | 2020-12-31T17:46:41.390079Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
db_1   | 2020-12-31T17:46:41.390155Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
db_1   | 2020-12-31T17:46:41.390926Z 0 [Note] InnoDB: Waiting for purge to start
db_1   | 2020-12-31T17:46:41.441943Z 0 [Note] InnoDB: 5.7.32 started; log sequence number 16090282
db_1   | 2020-12-31T17:46:41.442773Z 0 [Note] Plugin 'FEDERATED' is disabled.
db_1   | 2020-12-31T17:46:41.449655Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
db_1   | 2020-12-31T17:46:41.465582Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
app_1  | 2020-12-31 17:46:44,933 INFO Set uid to user 0 succeeded
db_1   | 2020-12-31T17:46:41.465753Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
app_1  | 2020-12-31 17:46:44,944 INFO supervisord started with pid 1
db_1   | 2020-12-31T17:46:41.467504Z 0 [Warning] CA certificate ca.pem is self signed.
app_1  | 2020-12-31 17:46:45,951 INFO spawned: 'cron' with pid 10
db_1   | 2020-12-31T17:46:41.467632Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
app_1  | 2020-12-31 17:46:45,956 INFO spawned: 'httpd_00' with pid 11
db_1   | 2020-12-31T17:46:41.470670Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
db_1   | 2020-12-31T17:46:41.470807Z 0 [Note] IPv6 is available.
app_1  | 2020-12-31 17:46:45,961 INFO spawned: 'queue_00' with pid 12
db_1   | 2020-12-31T17:46:41.470912Z 0 [Note]   - '::' resolves to '::';
app_1  | crond: crond (busybox 1.30.1) started, log level 0
db_1   | 2020-12-31T17:46:41.471022Z 0 [Note] Server socket created on IP: '::'.
app_1  | crond: user:www-data entry:(null)
app_1  | 100001000010000100001000010000100001000010000100001000010000
db_1   | 2020-12-31T17:46:41.482760Z 0 [Note] InnoDB: Buffer pool(s) load completed at 201231 17:46:41
app_1  | 111111111111111111111111
db_1   | 2020-12-31T17:46:41.542339Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
app_1  | 11111111111111111111111111111111
db_1   | 2020-12-31T17:46:41.728965Z 0 [Note] Event Scheduler: Loaded 0 events
app_1  | 111111111111
db_1   | 2020-12-31T17:46:41.729732Z 0 [Note] mysqld: ready for connections.
app_1  | 1111111
db_1   | Version: '5.7.32'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server (GPL)
app_1  | APP_KEY already set
db_1   | 2020-12-31T17:46:56.144601Z 2 [Note] Got timeout reading communication packets
app_1  | Connecting to db:3306
app_1  | J
app_1  | 5.7.32+E!Ka:???A><pGe
                              aTmysql_native_password2020-12-31 17:46:47,138 INFO success: cron entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
app_1  | 2020-12-31 17:46:47,138 INFO success: httpd_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
app_1  | 2020-12-31 17:46:47,138 INFO success: queue_00 entered RUNNING state, process has stayed up for > than 1 seconds (startsecs)
app_1  | 
app_1  | In Connection.php line 671:
app_1  |                                                                                
app_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'monica.cache' do  
app_1  |   esn't exist (SQL: select * from `cache` where `key` = laravel_cacheillumina  
app_1  |   te:queue:restart limit 1)                                                    
app_1  |                                                                                
app_1  | 
app_1  | In PDOConnection.php line 63:
app_1  |                                                                                
app_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'monica.cache' do  
app_1  |   esn't exist                                                                  
app_1  |                                                                                
app_1  | 
app_1  | In PDOConnection.php line 61:
app_1  |                                                                                
app_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'monica.cache' do  
app_1  |   esn't exist                                                                  
app_1  |                                                                                
app_1  | 
app_1  | 2020-12-31 17:46:47,207 INFO exited: queue_00 (exit status 1; not expected)
app_1  | 2020-12-31 17:46:48,212 INFO spawned: 'queue_00' with pid 28
app_1  | 
app_1  | In Connection.php line 671:
app_1  |                                                                                
app_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'monica.cache' do  
app_1  |   esn't exist (SQL: select * from `cache` where `key` = laravel_cacheillumina  
app_1  |   te:queue:restart limit 1)                                                    
app_1  |                                                                                
app_1  | 
app_1  | In PDOConnection.php line 63:
app_1  |                                                                                
app_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'monica.cache' do  
app_1  |   esn't exist                                                                  
app_1  |                                                                                
app_1  | 
app_1  | In PDOConnection.php line 61:
app_1  |                                                                                
app_1  |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'monica.cache' do  
app_1  |   esn't exist                                                                  
app_1  |                                                                                
app_1  | 
app_1  | 2020-12-31 17:46:49,029 INFO exited: queue_00 (exit status 1; not expected)
app_1  | 2020-12-31 17:46:50,031 INFO gave up: queue_00 entered FATAL state, too many start retries too quickly
app_1  | Waiting for database to settle...
app_1  | ? Maintenance mode: on
app_1  | '/usr/local/bin/php' 'artisan' down --message="Upgrading Monica v2.19.1" --retry="10"
app_1  | Application is now in maintenance mode.
app_1  | 
app_1  | ? Clear config cache
app_1  | '/usr/local/bin/php' 'artisan' config:clear
app_1  | crond: user:www-data entry:(null)
app_1  | 100001000010000100001000010000100001000010000100001000010000
app_1  | 111111111111111111111111
app_1  | 11111111111111111111111111111111
app_1  | 111111111111
app_1  | 1111111
app_1  | crond: wakeup dt=15
app_1  | crond: file www-data:
app_1  | crond:  line php /var/www/html/artisan schedule:run -v
app_1  | Configuration cache cleared!
app_1  | 
app_1  | ? Clear route cache
app_1  | '/usr/local/bin/php' 'artisan' route:clear
app_1  | Route cache cleared!
app_1  | 
app_1  | ? Clear view cache
app_1  | '/usr/local/bin/php' 'artisan' view:clear
app_1  | Compiled views cleared!
app_1  | 
app_1  | ? Symlink the storage folder
app_1  | '/usr/local/bin/php' 'artisan' storage:link
app_1  | The [/var/www/html/public/storage] link has been connected to [/var/www/html/storage/app/public].
app_1  | The links have been created.
app_1  | 
app_1  | ? Performing migrations
app_1  | '/usr/local/bin/php' 'artisan' migrate --force
app_1  | crond: wakeup dt=60
app_1  | crond: file www-data:
app_1  | crond:  line php /var/www/html/artisan schedule:run -v
app_1  | crond: wakeup dt=60
app_1  | crond: file www-data:
app_1  | crond:  line php /var/www/html/artisan schedule:run -v
app_1  | crond: wakeup dt=60
app_1  | crond: file www-data:
app_1  | crond:  line php /var/www/html/artisan schedule:run -v
app_1  | crond:  job: 0 php /var/www/html/artisan schedule:run -v
app_1  | crond: child running /bin/bash
app_1  | crond: USER www-data pid  55 cmd php /var/www/html/artisan schedule:run -v
app_1  | crond: wakeup dt=10
app_1  | crond: wakeup dt=50
app_1  | crond: file www-data:
app_1  | crond:  line php /var/www/html/artisan schedule:run -v
app_1  | Migration table created successfully.
app_1  | Migrating: 2014_10_12_000000_create_users_table
app_1  | Migrated:  2014_10_12_000000_create_users_table (0.59 seconds)
app_1  | Migrating: 2014_10_12_100000_create_password_resets_table
app_1  | Migrated:  2014_10_12_100000_create_password_resets_table (0.6 seconds)
app_1  | Migrating: 2016_06_01_000001_create_oauth_auth_codes_table
app_1  | Migrated:  2016_06_01_000001_create_oauth_auth_codes_table (0.82 seconds)
app_1  | Migrating: 2016_06_01_000002_create_oauth_access_tokens_table
app_1  | Migrated:  2016_06_01_000002_create_oauth_access_tokens_table (0.82 seconds)
app_1  | Migrating: 2016_06_01_000003_create_oauth_refresh_tokens_table
app_1  | Migrated:  2016_06_01_000003_create_oauth_refresh_tokens_table (1.19 seconds)
app_1  | Migrating: 2016_06_01_000004_create_oauth_clients_table
app_1  | Migrated:  2016_06_01_000004_create_oauth_clients_table (0.73 seconds)
app_1  | Migrating: 2016_06_01_000005_create_oauth_personal_access_clients_table
app_1  | Migrated:  2016_06_01_000005_create_oauth_personal_access_clients_table (0.39 seconds)
app_1  | Migrating: 2016_06_07_234741_create_account_table
app_1  | Migrated:  2016_06_07_234741_create_account_table (0.26 seconds)
app_1  | Migrating: 2016_06_08_003006_add_account_info_table
app_1  | Migrated:  2016_06_08_003006_add_account_info_table (0.43 seconds)
app_1  | Migrating: 2016_06_08_005413_create_contacts_table
app_1  | Migrated:  2016_06_08_005413_create_contacts_table (3.6 seconds)
app_1  | Migrating: 2016_06_25_224219_create_reminder_type_table
app_1  | Migrated:  2016_06_25_224219_create_reminder_type_table (0.92 seconds)
app_1  | Migrating: 2016_06_28_191025_create_tasks_table
app_1  | Migrated:  2016_06_28_191025_create_tasks_table (0.66 seconds)
app_1  | Migrating: 2016_06_30_185050_create_notes_table
app_1  | Migrated:  2016_06_30_185050_create_notes_table (0.28 seconds)
app_1  | Migrating: 2016_07_25_133835_add_width_field
app_1  | Migrated:  2016_07_25_133835_add_width_field (0.46 seconds)
app_1  | Migrating: 2016_08_28_122938_create_kids_table
app_1  | Migrated:  2016_08_28_122938_create_kids_table (2.5 seconds)
app_1  | Migrating: 2016_08_28_215159_create_relations_table
app_1  | Migrated:  2016_08_28_215159_create_relations_table (0.82 seconds)
app_1  | Migrating: 2016_09_03_202027_add_reminder_id_to_contacts
app_1  | Migrated:  2016_09_03_202027_add_reminder_id_to_contacts (1.28 seconds)
app_1  | Migrating: 2016_09_05_134937_add_last_talked_to_field
app_1  | Migrated:  2016_09_05_134937_add_last_talked_to_field (0.7 seconds)
app_1  | Migrating: 2016_09_05_135927_add_people_id_to_contacts
app_1  | Migrated:  2016_09_05_135927_add_people_id_to_contacts (0.49 seconds)
app_1  | Migrating: 2016_09_05_145111_add_name_info_to_peoples
app_1  | Migrated:  2016_09_05_145111_add_name_info_to_peoples (1.56 seconds)
app_1  | Migrating: 2016_09_06_213550_create_activity_type_table
app_1  | Migrated:  2016_09_06_213550_create_activity_type_table (0.39 seconds)
app_1  | Migrating: 2016_09_10_164406_create_jobs_table
app_1  | Migrated:  2016_09_10_164406_create_jobs_table (0.42 seconds)
app_1  | Migrating: 2016_09_10_170122_create_notifications_table
app_1  | Migrated:  2016_09_10_170122_create_notifications_table (0.2 seconds)
app_1  | Migrating: 2016_09_12_014120_create_failed_jobs_table
app_1  | Migrated:  2016_09_12_014120_create_failed_jobs_table (0.17 seconds)
app_1  | Migrating: 2016_09_30_014720_add_kid_to_reminder
app_1  | Migrated:  2016_09_30_014720_add_kid_to_reminder (0.34 seconds)
app_1  | Migrating: 2016_10_15_024156_add_deleted_at_to_users
app_1  | Migrated:  2016_10_15_024156_add_deleted_at_to_users (0.38 seconds)
app_1  | Migrating: 2016_10_19_155139_create_cache_table
app_1  | Migrated:  2016_10_19_155139_create_cache_table (0.7 seconds)
app_1  | Migrating: 2016_10_19_155800_create_sessions_table
app_1  | Migrated:  2016_10_19_155800_create_sessions_table (0.56 seconds)
app_1  | Migrating: 2016_10_21_022941_add_statistics_table
app_1  | Migrated:  2016_10_21_022941_add_statistics_table (0.16 seconds)
app_1  | Migrating: 2016_10_24_013543_add_journal_setting_to_users
app_1  | Migrated:  2016_10_24_013543_add_journal_setting_to_users (1.6 seconds)
app_1  | Migrating: 2016_10_24_014257_create_journal_tables
app_1  | Migrated:  2016_10_24_014257_create_journal_tables (0.11 seconds)
app_1  | Migrating: 2016_10_28_002518_add_metric_to_settings
app_1  | Migrated:  2016_10_28_002518_add_metric_to_settings (0.35 seconds)
app_1  | Migrating: 2016_11_01_014353_create_activities_table
app_1  | Migrated:  2016_11_01_014353_create_activities_table (0.22 seconds)
app_1  | Migrating: 2016_11_01_015957_add_icon_column
app_1  | Migrated:  2016_11_01_015957_add_icon_column (0.29 seconds)
app_1  | Migrating: 2016_11_03_150307_add_activity_location_to_activities
app_1  | Migrated:  2016_11_03_150307_add_activity_location_to_activities (0.31 seconds)
app_1  | Migrating: 2016_11_09_013049_add_events_table
app_1  | Migrated:  2016_11_09_013049_add_events_table (0.22 seconds)
app_1  | Migrating: 2016_12_08_011555_remove_type_from_notes
app_1  | Migrated:  2016_12_08_011555_remove_type_from_notes (1.05 seconds)
app_1  | Migrating: 2016_12_13_133945_add_gifts_table
app_1  | Migrated:  2016_12_13_133945_add_gifts_table (0.46 seconds)
app_1  | Migrating: 2016_12_28_150831_change_title_column
app_1  | Migrated:  2016_12_28_150831_change_title_column (1.44 seconds)
app_1  | Migrating: 2017_01_14_200815_add_facebook_columns_to_users_table
app_1  | Migrated:  2017_01_14_200815_add_facebook_columns_to_users_table (0.59 seconds)
app_1  | Migrating: 2017_01_15_045025_add_colors_to_users
app_1  | Migrated:  2017_01_15_045025_add_colors_to_users (0.33 seconds)
app_1  | Migrating: 2017_01_22_142645_add_fields_to_contacts
app_1  | Migrated:  2017_01_22_142645_add_fields_to_contacts (1.69 seconds)
app_1  | Migrating: 2017_01_23_043831_change_people_to_contact_for_kids
app_1  | Migrated:  2017_01_23_043831_change_people_to_contact_for_kids (0.89 seconds)
app_1  | Migrating: 2017_01_26_013524_change_people_to_significantother
app_1  | Migrated:  2017_01_26_013524_change_people_to_significantother (1.5 seconds)
app_1  | Migrating: 2017_01_26_022852_change_notes_to_contact
app_1  | Migrated:  2017_01_26_022852_change_notes_to_contact (0.62 seconds)
app_1  | Migrating: 2017_01_26_034553_add_notes_count_to_contact
app_1  | Migrated:  2017_01_26_034553_add_notes_count_to_contact (0.34 seconds)
app_1  | Migrating: 2017_01_27_024356_change_people_in_events
app_1  | Migrated:  2017_01_27_024356_change_people_in_events (0.66 seconds)
app_1  | Migrating: 2017_01_28_180156_remove_deleted_at_from_significant_others
app_1  | Migrated:  2017_01_28_180156_remove_deleted_at_from_significant_others (0.4 seconds)
app_1  | Migrating: 2017_01_28_184901_remove_deleted_at_from_kids
app_1  | Migrated:  2017_01_28_184901_remove_deleted_at_from_kids (0.59 seconds)
app_1  | Migrating: 2017_01_28_193913_remove_deleted_at_from_notes
app_1  | Migrated:  2017_01_28_193913_remove_deleted_at_from_notes (0.37 seconds)
app_1  | Migrating: 2017_01_28_222114_remove_viewed_at_from_contacts
app_1  | Migrated:  2017_01_28_222114_remove_viewed_at_from_contacts (0.5 seconds)
app_1  | Migrating: 2017_01_29_175146_remove_delete_at_from_activities
app_1  | Migrated:  2017_01_29_175146_remove_delete_at_from_activities (1.32 seconds)
app_1  | Migrating: 2017_01_29_175629_add_number_activities_to_contacts
app_1  | Migrated:  2017_01_29_175629_add_number_activities_to_contacts (0.42 seconds)
app_1  | Migrating: 2017_01_31_025849_add_activity_statistics_table
app_1  | Migrated:  2017_01_31_025849_add_activity_statistics_table (0.22 seconds)
app_1  | Migrating: 2017_02_02_232450_add_confirmation
app_1  | Migrated:  2017_02_02_232450_add_confirmation (0.35 seconds)
app_1  | Migrating: 2017_02_04_225618_change_reminders_table
app_1  | Migrated:  2017_02_04_225618_change_reminders_table (0.79 seconds)
app_1  | Migrating: 2017_02_05_035925_add_gifts_metrics_to_contacts
app_1  | Migrated:  2017_02_05_035925_add_gifts_metrics_to_contacts (0.62 seconds)
app_1  | Migrating: 2017_02_05_041740_change_gifts_table
app_1  | Migrated:  2017_02_05_041740_change_gifts_table (0.23 seconds)
app_1  | Migrating: 2017_02_05_042122_change_people_to_contact_for_gifts
app_1  | Migrated:  2017_02_05_042122_change_people_to_contact_for_gifts (0.88 seconds)
app_1  | Migrating: 2017_02_07_041607_change_tasks_table
app_1  | Migrated:  2017_02_07_041607_change_tasks_table (1.94 seconds)
app_1  | Migrating: 2017_02_07_051355_add_number_tasks_to_contact
app_1  | Migrated:  2017_02_07_051355_add_number_tasks_to_contact (0.37 seconds)
app_1  | Migrating: 2017_02_08_002251_change_number_tasks_contact
app_1  | Migrated:  2017_02_08_002251_change_number_tasks_contact (0.95 seconds)
app_1  | Migrating: 2017_02_08_025358_add_sort_preferences_to_users
app_1  | Migrated:  2017_02_08_025358_add_sort_preferences_to_users (0.53 seconds)
app_1  | Migrating: 2017_02_10_195613_remove_notifications_table
app_1  | Migrated:  2017_02_10_195613_remove_notifications_table (0.17 seconds)
app_1  | Migrating: 2017_02_10_214714_remove_people_table
app_1  | Migrated:  2017_02_10_214714_remove_people_table (0.17 seconds)
app_1  | Migrating: 2017_02_10_215405_remove_entities_table
app_1  | Migrated:  2017_02_10_215405_remove_entities_table (0.09 seconds)
app_1  | Migrating: 2017_02_10_215705_remove_deleted_at_from_contact
app_1  | Migrated:  2017_02_10_215705_remove_deleted_at_from_contact (0.45 seconds)
app_1  | Migrating: 2017_02_10_224355_calculate_statistics
app_1  | Migrated:  2017_02_10_224355_calculate_statistics (0.02 seconds)
app_1  | Migrating: 2017_02_11_154900_add_avatars_to_contacts
app_1  | Migrated:  2017_02_11_154900_add_avatars_to_contacts (2.04 seconds)
app_1  | Migrating: 2017_02_12_134220_create_entries_table
app_1  | Migrated:  2017_02_12_134220_create_entries_table (0.18 seconds)
app_1  | Migrating: 2017_05_03_155254_move_significant_other_data
app_1  | Migrated:  2017_05_03_155254_move_significant_other_data (0.55 seconds)
app_1  | Migrating: 2017_05_04_164723_remove_contact_encryption
app_1  | Migrated:  2017_05_04_164723_remove_contact_encryption (0 seconds)
app_1  | Migrating: 2017_05_04_185921_add_title_to_activities
app_1  | Migrated:  2017_05_04_185921_add_title_to_activities (0.32 seconds)
app_1  | Migrating: 2017_05_04_193252_alter_activity_nullable
app_1  | Migrated:  2017_05_04_193252_alter_activity_nullable (0.63 seconds)
app_1  | Migrating: 2017_05_08_164514_remove_encryption_tasks
app_1  | Migrated:  2017_05_08_164514_remove_encryption_tasks (0 seconds)
app_1  | Migrating: 2017_05_30_002239_remove_predefined_reminders
app_1  | Migrated:  2017_05_30_002239_remove_predefined_reminders (0.49 seconds)
app_1  | Migrating: 2017_05_30_023116_create_money_table
app_1  | Migrated:  2017_05_30_023116_create_money_table (0.28 seconds)
app_1  | Migrating: 2017_06_07_173437_add_multiple_genders_choices
app_1  | Migrated:  2017_06_07_173437_add_multiple_genders_choices (2.62 seconds)
app_1  | Migrating: 2017_06_10_152945_add_social_networks_to_contacts
app_1  | Migrated:  2017_06_10_152945_add_social_networks_to_contacts (0.38 seconds)
app_1  | Migrating: 2017_06_10_155349_create_currencies_data
app_1  | Migrated:  2017_06_10_155349_create_currencies_data (1.04 seconds)
app_1  | Migrating: 2017_06_11_025227_remove_encryption_journal
app_1  | Migrated:  2017_06_11_025227_remove_encryption_journal (0 seconds)
app_1  | Migrating: 2017_06_11_110735_change_unique_constraint_for_contacts
app_1  | Migrated:  2017_06_11_110735_change_unique_constraint_for_contacts (0.31 seconds)
app_1  | Migrating: 2017_06_13_035059_remove_gifts_encryption
app_1  | Migrated:  2017_06_13_035059_remove_gifts_encryption (0.01 seconds)
app_1  | Migrating: 2017_06_13_195740_add_company_to_contacts
app_1  | Migrated:  2017_06_13_195740_add_company_to_contacts (0.49 seconds)
app_1  | Migrating: 2017_06_14_131803_remove_bern_timezone
app_1  | Migrated:  2017_06_14_131803_remove_bern_timezone (0.01 seconds)
app_1  | Migrating: 2017_06_14_132911_add_zar_currency_to_currencies_table
app_1  | Migrated:  2017_06_14_132911_add_zar_currency_to_currencies_table (0.17 seconds)
app_1  | Migrating: 2017_06_16_215256_add_about_who_to_reminders
app_1  | Migrated:  2017_06_16_215256_add_about_who_to_reminders (1.11 seconds)
app_1  | Migrating: 2017_06_17_010900_fix_contacts_table
app_1  | Migrated:  2017_06_17_010900_fix_contacts_table (0 seconds)
app_1  | Migrating: 2017_06_17_153814_refactor_user_table
app_1  | Migrated:  2017_06_17_153814_refactor_user_table (1.38 seconds)
app_1  | Migrating: 2017_06_19_105842_add_stripe_fields_to_users
app_1  | Migrated:  2017_06_19_105842_add_stripe_fields_to_users (0.63 seconds)
app_1  | Migrating: 2017_06_20_121345_add_invitations_statistics
app_1  | Migrated:  2017_06_20_121345_add_invitations_statistics (1.6 seconds)
app_1  | Migrating: 2017_06_22_210813_add_name_order_to_users
app_1  | Migrated:  2017_06_22_210813_add_name_order_to_users (0.49 seconds)
app_1  | Migrating: 2017_06_27_134704_create_import_table
app_1  | Migrated:  2017_06_27_134704_create_import_table (0.42 seconds)
app_1  | Migrating: 2017_06_29_211725_add_import_job_to_statistics
app_1  | Migrated:  2017_06_29_211725_add_import_job_to_statistics (0.3 seconds)
app_1  | Migrating: 2017_06_29_230523_add_gravatar_url_to_users
app_1  | Migrated:  2017_06_29_230523_add_gravatar_url_to_users (0.49 seconds)
app_1  | Migrating: 2017_07_02_155736_create_tags_table
app_1  | Migrated:  2017_07_02_155736_create_tags_table (0.46 seconds)
app_1  | Migrating: 2017_07_04_132743_add_tags_to_statistics
app_1  | Migrated:  2017_07_04_132743_add_tags_to_statistics (0.51 seconds)
app_1  | Migrating: 2017_07_09_164312_update_bad_translation_key
app_1  | Migrated:  2017_07_09_164312_update_bad_translation_key (0 seconds)
app_1  | Migrating: 2017_07_12_014244_create_calls_table
app_1  | Migrated:  2017_07_12_014244_create_calls_table (0.35 seconds)
app_1  | Migrating: 2017_07_17_005012_drop_reminders_count_from_contacts
app_1  | Migrated:  2017_07_17_005012_drop_reminders_count_from_contacts (0.62 seconds)
app_1  | Migrating: 2017_07_18_215312_add_danish_kroner_to_currencies_table
app_1  | Migrated:  2017_07_18_215312_add_danish_kroner_to_currencies_table (0.02 seconds)
app_1  | Migrating: 2017_07_18_215758_add_indian_rupee_to_currencies_table
app_1  | Migrated:  2017_07_18_215758_add_indian_rupee_to_currencies_table (0.03 seconds)
app_1  | Migrating: 2017_07_19_094503_add_brazilian_real_to_currencies
app_1  | Migrated:  2017_07_19_094503_add_brazilian_real_to_currencies (0.35 seconds)
app_1  | Migrating: 2017_07_22_153209_create_instance_table
app_1  | Migrated:  2017_07_22_153209_create_instance_table (0.4 seconds)
app_1  | Migrating: 2017_07_26_220021_change_contacts_table
app_1  | Migrated:  2017_07_26_220021_change_contacts_table (2.3 seconds)
app_1  | Migrating: 2017_08_02_152838_change_string_to_boolean_for_reminders
app_1  | Migrated:  2017_08_02_152838_change_string_to_boolean_for_reminders (2.05 seconds)
app_1  | Migrating: 2017_08_06_085629_change_events_data
app_1  | Migrated:  2017_08_06_085629_change_events_data (0 seconds)
app_1  | Migrating: 2017_08_06_153253_move_kids_to_contacts
app_1  | Migrated:  2017_08_06_153253_move_kids_to_contacts (1.34 seconds)
app_1  | Migrating: 2017_08_16_041431_add_contact_avatar_location
app_1  | Migrated:  2017_08_16_041431_add_contact_avatar_location (0.57 seconds)
app_1  | Migrating: 2017_08_21_224835_remove_paid_limitations_for_current_users
app_1  | Migrated:  2017_08_21_224835_remove_paid_limitations_for_current_users (0.38 seconds)
app_1  | Migrating: 2017_09_10_125918_remove_unusued_counters
app_1  | Migrated:  2017_09_10_125918_remove_unusued_counters (0.58 seconds)
app_1  | Migrating: 2017_09_13_095923_add_tracking_table
app_1  | Migrated:  2017_09_13_095923_add_tracking_table (0.25 seconds)
app_1  | Migrating: 2017_09_13_191714_add_partial_notion
app_1  | Migrated:  2017_09_13_191714_add_partial_notion (2.24 seconds)
app_1  | Migrating: 2017_10_14_083556_change_gift_column_structure
app_1  | Migrated:  2017_10_14_083556_change_gift_column_structure (2.59 seconds)
app_1  | Migrating: 2017_10_17_170803_change_gift_structure
app_1  | Migrated:  2017_10_17_170803_change_gift_structure (0.33 seconds)
app_1  | Migrating: 2017_10_19_134816_create_activity_contact_table
app_1  | Migrated:  2017_10_19_134816_create_activity_contact_table (2.63 seconds)
app_1  | Migrating: 2017_10_19_135215_move_activities_to_pivot_table
app_1  | Migrated:  2017_10_19_135215_move_activities_to_pivot_table (0 seconds)
app_1  | Migrating: 2017_10_25_102923_remove_contact_id_activities_table
app_1  | Migrated:  2017_10_25_102923_remove_contact_id_activities_table (0.42 seconds)
app_1  | Migrating: 2017_11_01_122541_add_met_through_to_contacts
app_1  | Migrated:  2017_11_01_122541_add_met_through_to_contacts (0.8 seconds)
app_1  | Migrating: 2017_11_02_202601_add_is_dead_to_contacts
app_1  | Migrated:  2017_11_02_202601_add_is_dead_to_contacts (0.43 seconds)
app_1  | Migrating: 2017_11_10_174654_create_contact_fields_table
app_1  | Migrated:  2017_11_10_174654_create_contact_fields_table (8.1 seconds)
app_1  | Migrating: 2017_11_10_181043_migrate_contacts_information
app_1  | Migrated:  2017_11_10_181043_migrate_contacts_information (0.12 seconds)
app_1  | Migrating: 2017_11_10_202620_move_addresses_from_contact_to_addresses
app_1  | Migrated:  2017_11_10_202620_move_addresses_from_contact_to_addresses (0 seconds)
app_1  | Migrating: 2017_11_10_204035_delete_contact_fields_from_contacts
app_1  | Migrated:  2017_11_10_204035_delete_contact_fields_from_contacts (4.83 seconds)
app_1  | Migrating: 2017_11_20_115635_change-amount-to-double-on-debts
app_1  | Migrated:  2017_11_20_115635_change-amount-to-double-on-debts (0.47 seconds)
app_1  | Migrating: 2017_11_27_083043_add_more_statistics
app_1  | Migrated:  2017_11_27_083043_add_more_statistics (0.48 seconds)
app_1  | Migrating: 2017_11_27_134403_add_new_avatar_to_contacts
app_1  | Migrated:  2017_11_27_134403_add_new_avatar_to_contacts (1.26 seconds)
app_1  | Migrating: 2017_11_27_202857_change_tasks_table_structure
app_1  | Migrated:  2017_11_27_202857_change_tasks_table_structure (1.33 seconds)
app_1  | Migrating: 2017_12_01_113748_update_notes
app_1  | Migrated:  2017_12_01_113748_update_notes (0.41 seconds)
app_1  | Migrating: 2017_12_04_164831_create_ages_table
app_1  | Migrated:  2017_12_04_164831_create_ages_table (1.04 seconds)
app_1  | Migrating: 2017_12_04_165421_move_ages_data
app_1  | Migrated:  2017_12_04_165421_move_ages_data (0.91 seconds)
app_1  | Migrating: 2017_12_10_181535_remove_important_dates_table
app_1  | Migrated:  2017_12_10_181535_remove_important_dates_table (0.11 seconds)
app_1  | Migrating: 2017_12_10_205328_add_account_id_to_activities
app_1  | Migrated:  2017_12_10_205328_add_account_id_to_activities (0.41 seconds)
app_1  | Migrating: 2017_12_10_214545_add_last_consulted_at_to_contacts
app_1  | Migrated:  2017_12_10_214545_add_last_consulted_at_to_contacts (0.32 seconds)
app_1  | Migrating: 2017_12_13_115857_create_day_table
app_1  | Migrated:  2017_12_13_115857_create_day_table (0.33 seconds)
app_1  | Migrating: 2017_12_21_163616_update_journal_entries_with_existing_activities
app_1  | Migrated:  2017_12_21_163616_update_journal_entries_with_existing_activities (0 seconds)
app_1  | Migrating: 2017_12_21_170327_add_google2fa_secret_to_users
app_1  | Migrated:  2017_12_21_170327_add_google2fa_secret_to_users (1.04 seconds)
app_1  | Migrating: 2017_12_24_115641_create_pets_table
app_1  | Migrated:  2017_12_24_115641_create_pets_table (0.79 seconds)
app_1  | Migrating: 2017_12_31_114224_add_dashboard_tab_to_users
app_1  | Migrated:  2017_12_31_114224_add_dashboard_tab_to_users (0.54 seconds)
app_1  | Migrating: 2018_01_15_105858_create_additional_reminders_table
app_1  | Migrated:  2018_01_15_105858_create_additional_reminders_table (0.89 seconds)
app_1  | Migrating: 2018_01_16_203358_add_gift_received
app_1  | Migrated:  2018_01_16_203358_add_gift_received (0.41 seconds)
app_1  | Migrating: 2018_01_16_212320_rename_gift_columns
app_1  | Migrated:  2018_01_16_212320_rename_gift_columns (0.14 seconds)
app_1  | Migrating: 2018_01_17_230820_add_gift_tab_view_to_users
app_1  | Migrated:  2018_01_17_230820_add_gift_tab_view_to_users (0.29 seconds)
app_1  | Migrating: 2018_01_27_014146_add_custom_gender
app_1  | Migrated:  2018_01_27_014146_add_custom_gender (0.8 seconds)
app_1  | Migrating: 2018_02_25_202752_change_locale_in_db
app_1  | Migrated:  2018_02_25_202752_change_locale_in_db (0 seconds)
app_1  | Migrating: 2018_02_28_223747_update_notification_table
app_1  | Migrated:  2018_02_28_223747_update_notification_table (0.89 seconds)
app_1  | Migrating: 2018_03_03_204440_create_relationship_type_table
app_1  | Migrated:  2018_03_03_204440_create_relationship_type_table (1.3 seconds)
app_1  | Migrating: 2018_03_18_085815_populate_default_relationship_type_tables
app_1  | Migrated:  2018_03_18_085815_populate_default_relationship_type_tables (0.45 seconds)
app_1  | Migrating: 2018_03_18_090209_populate_relationship_type_tables_with_default_values
app_1  | Migrated:  2018_03_18_090209_populate_relationship_type_tables_with_default_values (0.09 seconds)
app_1  | Migrating: 2018_03_18_090345_migrate_current_relationship_table_to_new_relationship_structure
app_1  | Migrated:  2018_03_18_090345_migrate_current_relationship_table_to_new_relationship_structure (0.19 seconds)
app_1  | Migrating: 2018_03_24_083258_migrate_offsprings
app_1  | Migrated:  2018_03_24_083258_migrate_offsprings (0.61 seconds)
app_1  | Migrating: 2018_04_04_220850_create_default_modules_table
app_1  | Migrated:  2018_04_04_220850_create_default_modules_table (0.26 seconds)
app_1  | Migrating: 2018_04_04_222608_create_account_modules_table
app_1  | Migrated:  2018_04_04_222608_create_account_modules_table (0.24 seconds)
app_1  | Migrating: 2018_04_10_205655_fix_production_error
app_1  | Migrated:  2018_04_10_205655_fix_production_error (0 seconds)
app_1  | Migrating: 2018_04_10_222515_migrate-modules
app_1  | Migrated:  2018_04_10_222515_migrate-modules (0.02 seconds)
app_1  | Migrating: 2018_04_13_131008_fix-contacts-data
app_1  | Migrated:  2018_04_13_131008_fix-contacts-data (0 seconds)
app_1  | Migrating: 2018_04_13_205231_create_changes_table
app_1  | Migrated:  2018_04_13_205231_create_changes_table (0.35 seconds)
app_1  | Migrating: 2018_04_14_081052_fix_wrong_gender
app_1  | Migrated:  2018_04_14_081052_fix_wrong_gender (0 seconds)
app_1  | Migrating: 2018_04_19_190239_stay_in_touch
app_1  | Migrated:  2018_04_19_190239_stay_in_touch (1.04 seconds)
app_1  | Migrating: 2018_05_06_061227_external_countries
app_1  | Migrated:  2018_05_06_061227_external_countries (0.84 seconds)
app_1  | Migrating: 2018_05_06_194710_delete_reminder_sent_table
app_1  | Migrated:  2018_05_06_194710_delete_reminder_sent_table (0.08 seconds)
app_1  | Migrating: 2018_05_07_070458_create_terms_table
app_1  | Migrated:  2018_05_07_070458_create_terms_table (0.42 seconds)
app_1  | Migrating: 2018_05_13_110706_add_ex_wife_husband_relationship
app_1  | Migrated:  2018_05_13_110706_add_ex_wife_husband_relationship (0.05 seconds)
app_1  | Migrating: 2018_05_16_143631_add_nickname_to_contacts
app_1  | Migrated:  2018_05_16_143631_add_nickname_to_contacts (0.66 seconds)
app_1  | Migrating: 2018_05_16_214222_add_timestamps_to_currencies
app_1  | Migrated:  2018_05_16_214222_add_timestamps_to_currencies (0.46 seconds)
app_1  | Migrating: 2018_05_20_121028_accept_terms
app_1  | Migrated:  2018_05_20_121028_accept_terms (0 seconds)
app_1  | Migrating: 2018_05_20_225034_change_name_order_user-_preferencies
app_1  | Migrated:  2018_05_20_225034_change_name_order_user-_preferencies (0 seconds)
app_1  | Migrating: 2018_05_24_160546_fix-inconsistant-reminder-time
app_1  | Migrated:  2018_05_24_160546_fix-inconsistant-reminder-time (0 seconds)
app_1  | Migrating: 2018_06_10_191450_add_love_metadata_relationshisp
app_1  | Migrated:  2018_06_10_191450_add_love_metadata_relationshisp (1.21 seconds)
app_1  | Migrating: 2018_06_10_221746_migrate_entries_objects
app_1  | Migrated:  2018_06_10_221746_migrate_entries_objects (0.01 seconds)
app_1  | Migrating: 2018_06_11_184017_change_default_user_table
app_1  | Migrated:  2018_06_11_184017_change_default_user_table (0.04 seconds)
app_1  | Migrating: 2018_06_13_000100_create_u2f_key_table
app_1  | Migrated:  2018_06_13_000100_create_u2f_key_table (1.05 seconds)
app_1  | Migrating: 2018_06_14_212502_change_default_name_order_user_table
app_1  | Migrated:  2018_06_14_212502_change_default_name_order_user_table (0.03 seconds)
app_1  | Migrating: 2018_07_03_204220_create_default_activity_type_groups_table
app_1  | Migrated:  2018_07_03_204220_create_default_activity_type_groups_table (4.99 seconds)
app_1  | Migrating: 2018_07_08_104306_update-timestamps-timezone
app_1  | Migrated:  2018_07_08_104306_update-timestamps-timezone (0 seconds)
app_1  | Migrating: 2018_07_26_104306_create-conversations
app_1  | Migrated:  2018_07_26_104306_create-conversations (5.25 seconds)
app_1  | Migrating: 2018_08_06_145046_add_starred_to_contacts
app_1  | Migrated:  2018_08_06_145046_add_starred_to_contacts (0.29 seconds)
app_1  | Migrating: 2018_08_09_18000_fix-empty-reminder-time
app_1  | Migrated:  2018_08_09_18000_fix-empty-reminder-time (0 seconds)
app_1  | Migrating: 2018_08_18_180426_add_legacy_free_plan
app_1  | Migrated:  2018_08_18_180426_add_legacy_free_plan (0.46 seconds)
app_1  | Migrating: 2018_08_29_124804_add_conversations_to_statistics
app_1  | Migrated:  2018_08_29_124804_add_conversations_to_statistics (0.36 seconds)
app_1  | Migrating: 2018_08_29_222051_add_conversations_to_modules
app_1  | Migrated:  2018_08_29_222051_add_conversations_to_modules (0.06 seconds)
app_1  | Migrating: 2018_08_31_020908_create_life_events_table
app_1  | Migrated:  2018_08_31_020908_create_life_events_table (8.17 seconds)
app_1  | Migrating: 2018_09_02_150531_contact_archiving
app_1  | Migrated:  2018_09_02_150531_contact_archiving (0.38 seconds)
app_1  | Migrating: 2018_09_05_025008_add_default_profile_view
app_1  | Migrated:  2018_09_05_025008_add_default_profile_view (0.33 seconds)
app_1  | Migrating: 2018_09_05_213507_mark_modules_migrated
app_1  | Migrated:  2018_09_05_213507_mark_modules_migrated (0 seconds)
app_1  | Migrating: 2018_09_13_135926_add_description_field_to_contacts
app_1  | Migrated:  2018_09_13_135926_add_description_field_to_contacts (0.36 seconds)
app_1  | Migrating: 2018_09_18_142844_remove_events
app_1  | Migrated:  2018_09_18_142844_remove_events (0.11 seconds)
app_1  | Migrating: 2018_09_23_024528_add_documents_table
app_1  | Migrated:  2018_09_23_024528_add_documents_table (1.27 seconds)
app_1  | Migrating: 2018_09_29_114125_add_reminder_to_life_events
app_1  | Migrated:  2018_09_29_114125_add_reminder_to_life_events (1.21 seconds)
app_1  | Migrating: 2018_10_01_211757_add_number_of_views
app_1  | Migrated:  2018_10_01_211757_add_number_of_views (0.44 seconds)
app_1  | Migrating: 2018_10_04_181116_life_event_vehicle
app_1  | Migrated:  2018_10_04_181116_life_event_vehicle (0.11 seconds)
app_1  | Migrating: 2018_10_07_120133_fix_json_column
app_1  | Migrated:  2018_10_07_120133_fix_json_column (0 seconds)
app_1  | Migrating: 2018_10_16_000703_add_documents_to_module_table
app_1  | Migrated:  2018_10_16_000703_add_documents_to_module_table (0.11 seconds)
app_1  | Migrating: 2018_10_19_081816_life_event_tattoo
app_1  | Migrated:  2018_10_19_081816_life_event_tattoo (0 seconds)
app_1  | Migrating: 2018_10_27_230346_fix_non_english_tab_slugs
app_1  | Migrated:  2018_10_27_230346_fix_non_english_tab_slugs (0.03 seconds)
app_1  | Migrating: 2018_10_28_165814_email_verified
app_1  | Migrated:  2018_10_28_165814_email_verified (1.23 seconds)
app_1  | Migrating: 2018_11_11_145035_remove_changelogs_table
app_1  | Migrated:  2018_11_11_145035_remove_changelogs_table (0.22 seconds)
app_1  | Migrating: 2018_11_15_172333_make_contact_id_nullable_in_tasks
app_1  | Migrated:  2018_11_15_172333_make_contact_id_nullable_in_tasks (0.52 seconds)
app_1  | Migrating: 2018_11_18_021908_create_images_table
app_1  | Migrated:  2018_11_18_021908_create_images_table (1.86 seconds)
app_1  | Migrating: 2018_11_21_212932_add_contacts_uuid
app_1  | Migrated:  2018_11_21_212932_add_contacts_uuid (0.36 seconds)
app_1  | Migrating: 2018_11_25_020818_add_contact_photo_table
app_1  | Migrated:  2018_11_25_020818_add_contact_photo_table (1.16 seconds)
app_1  | Migrating: 2018_11_30_154729_recovery_codes
app_1  | Migrated:  2018_11_30_154729_recovery_codes (1.52 seconds)
app_1  | Migrating: 2018_12_08_233140_add_who_called_to_calls
app_1  | Migrated:  2018_12_08_233140_add_who_called_to_calls (0.68 seconds)
app_1  | Migrating: 2018_12_09_023232_add_emotions_table
app_1  | Migrated:  2018_12_09_023232_add_emotions_table (9.37 seconds)
app_1  | Migrating: 2018_12_09_145956_create_emotion_call_table
app_1  | Migrated:  2018_12_09_145956_create_emotion_call_table (3.64 seconds)
app_1  | Migrating: 2018_12_16_195440_add_gps_coordinates_to_addressess
app_1  | Migrated:  2018_12_16_195440_add_gps_coordinates_to_addressess (0.37 seconds)
app_1  | Migrating: 2018_12_19_002819_create_places_table
app_1  | Migrated:  2018_12_19_002819_create_places_table (1.78 seconds)
app_1  | Migrating: 2018_12_19_003444_move_addresses_data
app_1  | Migrated:  2018_12_19_003444_move_addresses_data (4.32 seconds)
app_1  | Migrating: 2018_12_21_235418_add_weather_table
app_1  | Migrated:  2018_12_21_235418_add_weather_table (1.94 seconds)
app_1  | Migrating: 2018_12_22_021123_add_weather_preferences_to_users
app_1  | Migrated:  2018_12_22_021123_add_weather_preferences_to_users (0.53 seconds)
app_1  | Migrating: 2018_12_22_200413_add_reminder_initial_date_to_reminders
app_1  | Migrated:  2018_12_22_200413_add_reminder_initial_date_to_reminders (4.83 seconds)
app_1  | Migrating: 2018_12_24_164256_add_companies_table
app_1  | Migrated:  2018_12_24_164256_add_companies_table (0.85 seconds)
app_1  | Migrating: 2018_12_24_220019_add_occupations_table
app_1  | Migrated:  2018_12_24_220019_add_occupations_table (2.45 seconds)
app_1  | Migrating: 2018_12_25_001736_add_linkedin_to_default_contact_field_type
app_1  | Migrated:  2018_12_25_001736_add_linkedin_to_default_contact_field_type (0.84 seconds)
app_1  | Migrating: 2018_12_25_012011_move_linkedin_data_to_contact_field_type
app_1  | Migrated:  2018_12_25_012011_move_linkedin_data_to_contact_field_type (0.43 seconds)
app_1  | Migrating: 2018_12_29_091017_default_temperature_scale
app_1  | Migrated:  2018_12_29_091017_default_temperature_scale (0.04 seconds)
app_1  | Migrating: 2018_12_29_135516_sync_token
app_1  | Migrated:  2018_12_29_135516_sync_token (1.25 seconds)
app_1  | Migrating: 2019_01_05_152329_add_reminder_ids_to_contacts
app_1  | Migrated:  2019_01_05_152329_add_reminder_ids_to_contacts (2.12 seconds)
app_1  | Migrating: 2019_01_05_152405_migrate_previous_remiders
app_1  | Migrated:  2019_01_05_152405_migrate_previous_remiders (0 seconds)
app_1  | Migrating: 2019_01_05_152456_drop_special_date_id_from_reminders
app_1  | Migrated:  2019_01_05_152456_drop_special_date_id_from_reminders (2.02 seconds)
app_1  | Migrating: 2019_01_05_152526_schedule_new_reminders
app_1  | Migrated:  2019_01_05_152526_schedule_new_reminders (0 seconds)
app_1  | Migrating: 2019_01_05_202557_add_foreign_keys_to_reminder
app_1  | Migrated:  2019_01_05_202557_add_foreign_keys_to_reminder (1.47 seconds)
app_1  | Migrating: 2019_01_05_202748_add_foreign_key_to_reminder_rule
app_1  | Migrated:  2019_01_05_202748_add_foreign_key_to_reminder_rule (0.67 seconds)
app_1  | Migrating: 2019_01_05_202938_add_foreign_key_to_contacts
app_1  | Migrated:  2019_01_05_202938_add_foreign_key_to_contacts (3.69 seconds)
app_1  | Migrating: 2019_01_05_203201_add_foreign_key_for_reminder_in_life-events_table
app_1  | Migrated:  2019_01_05_203201_add_foreign_key_for_reminder_in_life-events_table (0.2 seconds)
app_1  | Migrating: 2019_01_06_135133_update_u2f_key_table
app_1  | Migrated:  2019_01_06_135133_update_u2f_key_table (0.67 seconds)
app_1  | Migrating: 2019_01_06_150143_add_inactive_flag_to_reminders
app_1  | Migrated:  2019_01_06_150143_add_inactive_flag_to_reminders (0.39 seconds)
app_1  | Migrating: 2019_01_06_190036_u2f_key_name
app_1  | Migrated:  2019_01_06_190036_u2f_key_name (1.6 seconds)
app_1  | Migrating: 2019_01_11_142944_add_foreign_keys_to_activities
app_1  | Migrated:  2019_01_11_142944_add_foreign_keys_to_activities (2.55 seconds)
app_1  | Migrating: 2019_01_11_183717_change_activities_date_type
app_1  | Migrated:  2019_01_11_183717_change_activities_date_type (0.62 seconds)
app_1  | Migrating: 2019_01_17_093812_add_admin_user
app_1  | Migrated:  2019_01_17_093812_add_admin_user (1.21 seconds)
app_1  | Migrating: 2019_01_18_142032_add_dav_uuid
app_1  | Migrated:  2019_01_18_142032_add_dav_uuid (1.93 seconds)
app_1  | Migrating: 2019_01_22_034555_create_emotion_activity_table
app_1  | Migrated:  2019_01_22_034555_create_emotion_activity_table (2.02 seconds)
app_1  | Migrating: 2019_01_24_221539_change_activity_model_location
app_1  | Migrated:  2019_01_24_221539_change_activity_model_location (0 seconds)
app_1  | Migrating: 2019_01_31_223600_add_swiss_chf_to_currencies_table
app_1  | Migrated:  2019_01_31_223600_add_swiss_chf_to_currencies_table (0.02 seconds)
app_1  | Migrating: 2019_02_08_234959_remove_users_without_account
app_1  | Migrated:  2019_02_08_234959_remove_users_without_account (0.09 seconds)
app_1  | Migrating: 2019_02_09_200203_add_gender_type
app_1  | Migrated:  2019_02_09_200203_add_gender_type (0.93 seconds)
app_1  | Migrating: 2019_02_17_112452_add_default_gender
app_1  | Migrated:  2019_02_17_112452_add_default_gender (1.35 seconds)
app_1  | Migrating: 2019_02_20_205744_allow_gender_null
app_1  | Migrated:  2019_02_20_205744_allow_gender_null (0.97 seconds)
app_1  | Migrating: 2019_02_24_223855_remove_relation_type_name
app_1  | Migrated:  2019_02_24_223855_remove_relation_type_name (0.6 seconds)
app_1  | Migrating: 2019_03_27_103012_set_default_profile_links
app_1  | Migrated:  2019_03_27_103012_set_default_profile_links (0.05 seconds)
app_1  | Migrating: 2019_03_29_163611_add_webauthn
app_1  | Migrated:  2019_03_29_163611_add_webauthn (2.35 seconds)
app_1  | Migrating: 2019_05_05_194746_add_cron_schedule
app_1  | Migrated:  2019_05_05_194746_add_cron_schedule (0.36 seconds)
app_1  | Migrating: 2019_05_15_205533_rename_preferences
app_1  | Migrated:  2019_05_15_205533_rename_preferences (0.23 seconds)
app_1  | Migrating: 2019_05_26_000000_add_relationship_table_indexes
app_1  | Migrated:  2019_05_26_000000_add_relationship_table_indexes (0.55 seconds)
app_1  | Migrating: 2019_05_27_000000_populate_relationship_type_tables_with_stepparent_values
app_1  | Migrated:  2019_05_27_000000_populate_relationship_type_tables_with_stepparent_values (0.08 seconds)
app_1  | Migrating: 2019_08_12_213308_change_avatars_structure
app_1  | Migrated:  2019_08_12_213308_change_avatars_structure (0.55 seconds)
app_1  | Migrating: 2019_08_12_222938_create_avatars_for_existing_contacts
app_1  | Migrated:  2019_08_12_222938_create_avatars_for_existing_contacts (0.72 seconds)
app_1  | Migrating: 2019_08_13_160332_add_me_contact_on_user
app_1  | Migrated:  2019_08_13_160332_add_me_contact_on_user (1.74 seconds)
app_1  | Migrating: 2019_08_14_091427_update_stripe_columns
app_1  | Migrated:  2019_08_14_091427_update_stripe_columns (1.18 seconds)
app_1  | Migrating: 2019_09_04_075311_fix_tattoo_or_piercing_translation
app_1  | Migrated:  2019_09_04_075311_fix_tattoo_or_piercing_translation (0 seconds)
app_1  | Migrating: 2019_12_17_024553_add_foreign_keys
app_1  | Migrated:  2019_12_17_024553_add_foreign_keys (25.36 seconds)
app_1  | Migrating: 2019_12_21_100315_change_gift_status
app_1  | Migrated:  2019_12_21_100315_change_gift_status (3.18 seconds)
app_1  | Migrating: 2019_12_21_194559_add_photo_gift
app_1  | Migrated:  2019_12_21_194559_add_photo_gift (1.95 seconds)
app_1  | Migrating: 2019_12_27_23533_rename_picnicked
app_1  | Migrated:  2019_12_27_23533_rename_picnicked (0.04 seconds)
app_1  | Migrating: 2020_02_03_015403_create_audit_log_table
app_1  | Migrated:  2020_02_03_015403_create_audit_log_table (2.78 seconds)
app_1  | Migrating: 2020_02_18_211620_add_contact_field_label
app_1  | Migrated:  2020_02_18_211620_add_contact_field_label (6.18 seconds)
app_1  | Migrating: 2020_03_22_132429_rename_birthday_reminder_title_deceased
app_1  | Migrated:  2020_03_22_132429_rename_birthday_reminder_title_deceased (0 seconds)
app_1  | Migrating: 2020_04_24_185810_remove_duplicate_currency
app_1  | Migrated:  2020_04_24_185810_remove_duplicate_currency (0 seconds)
app_1  | Migrating: 2020_04_24_205810_currencies_table_seed
app_1  | Migrated:  2020_04_24_205810_currencies_table_seed (0.09 seconds)
app_1  | Migrating: 2020_04_24_212138_update_amount_format
app_1  | Migrated:  2020_04_24_212138_update_amount_format (5.68 seconds)
app_1  | Migrating: 2020_05_08_072433_google2fa_column_size
app_1  | Migrated:  2020_05_08_072433_google2fa_column_size (0.05 seconds)
app_1  | Migrating: 2020_08_05_184814_upgrade_passport
app_1  | Migrated:  2020_08_05_184814_upgrade_passport (0.04 seconds)
app_1  | 
app_1  | ? Check for encryption keys
app_1  | '/usr/local/bin/php' 'artisan' monica:passport --force
app_1  | Checking encryption keys...
app_1  | ? Files storage/oauth-private.key and storage/oauth-public.key detected.
app_1  | Checking Personal Access Client...
app_1  | ? Creating personal access client
app_1  | '/usr/local/bin/php' 'artisan' passport:client --personal --no-interaction
app_1  | Personal access client created successfully.
app_1  | Client ID: 1
app_1  | Client secret: es704t0nx9n2bRM3cu8ihZE6pCK7otu3epQjT6pb
app_1  | 
app_1  | 
app_1  | ? Ping for new version
app_1  | '/usr/local/bin/php' 'artisan' monica:ping --force
app_1  | Call url:https://version.monicahq.com/ping
app_1  | instance version:2.19.1
app_1  | current version:2.19.1
app_1  | 
app_1  | ? Maintenance mode: off
app_1  | '/usr/local/bin/php' 'artisan' up
app_1  | Application is now live.
app_1  | 
app_1  | Monica v2.19.1 is set up, enjoy.
app_1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.28.0.3. Set the 'ServerName' directive globally to suppress this message
app_1  | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.28.0.3. Set the 'ServerName' directive globally to suppress this message
app_1  | [Thu Dec 31 17:51:42.475612 2020] [mpm_prefork:notice] [pid 11] AH00163: Apache/2.4.38 (Debian) PHP/7.3.25 configured -- resuming normal operations
app_1  | [Thu Dec 31 17:51:42.475785 2020] [core:notice] [pid 11] AH00094: Command line: 'apache2 -D FOREGROUND'
djjudas21 commented 1 year ago

New Monica user here. I just installed Monica v4.0.0 on Kubernetes via a Helm chart, and ran into the same bug. I verified that DB_PREFIX is not set.

Here's the output of running the migrations on first startup:

✓ Performing migrations
'/usr/local/bin/php' 'artisan' migrate --force

   INFO  Running migrations.

  2017_11_10_174654_create_contact_fields_table ..................... 2ms FAIL
[2023-07-27 15:14:01] production.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'contact_field_types' already exists (SQL: create table `contact_field_types` (`id` int unsigned not null auto_increment primary key, `account_id` int unsigned not null, `name` varchar(255) not null, `fontawesome_icon` varchar(255) null, `protocol` varchar(255) null, `delible` tinyint(1) not null default '1', `type` varchar(255) null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'contact_field_types' already exists (SQL: create table `contact_field_types` (`id` int unsigned not null auto_increment primary key, `account_id` int unsigned not null, `name` varchar(255) not null, `fontawesome_icon` varchar(255) null, `protocol` varchar(255) null, `delible` tinyint(1) not null default '1', `type` varchar(255) null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)

I shelled into the container and ran php artisan migrate --force but it failed with the same error as above.

I haven't yet attempted to drop the duplicate table from the database. I haven't customised any of the settings yet so it's pretty surprising that migrations would fail on a vanilla installation. Any hints?

djjudas21 commented 1 year ago

I worked around my issue by running drop table contact_field_types; but it's not great that migrations fail on a new deployment