Error trying to send a transaction

[Azlond]

I'm currently running an older version of Firefly III, and would like to upgrade to the latest version using docker. I am however having trouble with the following error (which is also currently present on my 5.7.9 version), which seems to relate to #5764, but which doesn't list a solution for me to try.

The transaction is still correctly stored, but I'd like to get rid of the error if possible. Any help would be appreciated.

Log of the container booting up

docker@ubuntu:~/Desktop/firefly$ docker-compose up
Starting firefly_fireflyiiidb_1 ... done
Starting firefly_fireflyiii_1   ... done
Attaching to firefly_fireflyiiidb_1, firefly_fireflyiii_1
fireflyiii_1    | Now in entrypoint.sh for Firefly III
fireflyiii_1    | Script:       1.0.21 (2022-02-17)
fireflyiiidb_1  | [i] mysqld already present, skipping creation
fireflyiiidb_1  | [i] MySQL directory already present, skipping creation
fireflyiiidb_1  | 2023-04-12 21:11:33 0 [Note] /usr/bin/mysqld (mysqld 10.4.17-MariaDB) starting as process 1 ...
fireflyiii_1    | User:         'root'
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Using Linux native AIO
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Uses event mutexes
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Number of pools: 1
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] mysqld: O_TMPFILE is not supported on /var/tmp (disabling future attempts)
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Completed initialization of buffer pool
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
fireflyiiidb_1  | 2023-04-12 21:11:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=36519952
fireflyiii_1    | Group:        'root'
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: Creating shared tablespace for temporary tables
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: Waiting for purge to start
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: 10.4.17 started; log sequence number 36519961; transaction id 153041
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] Plugin 'FEEDBACK' is disabled.
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] Server socket created on IP: '::'.
fireflyiii_1    | Working dir:  '/var/www/html'
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Warning] 'user' entry '@cfa8ffd57da1' ignored in --skip-name-resolve mode.
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Warning] 'proxies_priv' entry '@% root@cfa8ffd57da1' ignored in --skip-name-resolve mode.
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] Reading of all Master_info entries succeeded
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] Added new Master_info '' to hash table
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] /usr/bin/mysqld: ready for connections.
fireflyiiidb_1  | Version: '10.4.17-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  MariaDB Server
fireflyiiidb_1  | 2023-04-12 21:11:35 0 [Note] InnoDB: Buffer pool(s) load completed at 230412 21:11:35
fireflyiii_1    | Build number:  448
fireflyiii_1    | Build date:    08-04-2023 08:59:26 CEST
fireflyiii_1    | Now parsing _FILE variables.
fireflyiii_1    | done!
fireflyiii_1    | Touch DB file (if SQLite)...
fireflyiii_1    | Dump auto load...
fireflyiii_1    | Generating optimized autoload files
fireflyiii_1    | > Illuminate\Foundation\ComposerScripts::postAutoloadDump
fireflyiii_1    | Generated optimized autoload files containing 6284 classes
fireflyiii_1    | Discover packages...
fireflyiii_1    | 
fireflyiii_1    |    INFO  Discovering packages.  
fireflyiii_1    | 
fireflyiii_1    |   diglactic/laravel-breadcrumbs ......................................... DONE
fireflyiii_1    |   jc5/google2fa-laravel ................................................. DONE
fireflyiii_1    |   laravel/passport ...................................................... DONE
fireflyiii_1    |   laravel/sanctum ....................................................... DONE
fireflyiii_1    |   laravel/slack-notification-channel .................................... DONE
fireflyiii_1    |   laravel/ui ............................................................ DONE
fireflyiii_1    |   laravelcollective/html ................................................ DONE
fireflyiii_1    |   nesbot/carbon ......................................................... DONE
fireflyiii_1    |   nunomaduro/collision .................................................. DONE
fireflyiii_1    |   nunomaduro/termwind ................................................... DONE
fireflyiii_1    |   rcrowe/twigbridge ..................................................... DONE
fireflyiii_1    |   spatie/laravel-ignition ............................................... DONE
fireflyiii_1    |   therobfonz/laravel-mandrill-driver .................................... DONE
fireflyiii_1    | 
fireflyiii_1    | Current working dir is '/var/www/html'
fireflyiii_1    | Wait for the database.
fireflyiii_1    | wait-for-it.sh: waiting 60 seconds for fireflyiiidb:3306
fireflyiiidb_1  | 2023-04-12 21:11:47 8 [Warning] Aborted connection 8 to db: 'unconnected' user: 'unauthenticated' host: '172.31.0.3' (This connection closed normally without authentication)
fireflyiii_1    | wait-for-it.sh: fireflyiiidb:3306 is available after 0 seconds
fireflyiii_1    | DB is up.
fireflyiii_1    | Wait another 5 seconds in case the DB needs to boot.
fireflyiii_1    | Done waiting for the DB to boot.
fireflyiii_1    | Will not build the locales...
fireflyiii_1    | Run various artisan commands...
fireflyiii_1    | Running migration commands...
fireflyiii_1    | DSN is mysql:host=fireflyiiidb;port=3306;charset=utf8mb4
fireflyiii_1    | Database "firefly" exists.
fireflyiii_1    | 
fireflyiii_1    |    INFO  Running migrations.  
fireflyiii_1    | 
fireflyiiidb_1  | 2023-04-12 21:11:53 10 [ERROR] InnoDB: Table `firefly`.`failed_jobs` does not exist in the InnoDB internal data dictionary though MariaDB is trying to drop it. Have you copied the .frm file of the table to the MariaDB database directory from another database? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.
fireflyiiidb_1  | 2023-04-12 21:11:53 10 [ERROR] InnoDB: Operating system error number 17 in a file operation.
fireflyiiidb_1  | 2023-04-12 21:11:53 10 [ERROR] InnoDB: Error number 17 means 'File exists'
fireflyiiidb_1  | 2023-04-12 21:11:53 10 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
fireflyiiidb_1  | 2023-04-12 21:11:53 10 [Note] InnoDB: The file './firefly/failed_jobs.ibd' already exists though the corresponding table did not exist in the InnoDB data dictionary. You can resolve the problem by removing the file.
fireflyiiidb_1  | 2023-04-12 21:11:53 10 [ERROR] InnoDB: Cannot create file './firefly/failed_jobs.ibd'
fireflyiii_1    |   2020_11_12_070604_changes_for_v550 [2023-04-12 23:11:53] local.ERROR: Could not create table "failed_jobs": SQLSTATE[HY000]: General error: 1813 Tablespace for table '`firefly`.`failed_jobs`' exists. Please DISCARD the tablespace before IMPORT (Connection: mysql, SQL: create table `failed_jobs` (`id` bigint unsigned not null auto_increment primary key, `uuid` varchar(191) not null, `connection` text not null, `queue` text not null, `payload` longtext not null, `exception` longtext not null, `failed_at` timestamp not null default CURRENT_TIMESTAMP) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:53] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | .............................. 255ms DONE
fireflyiii_1    |   2021_03_12_061213_changes_for_v550b2 ............................ 155ms DONE
fireflyiii_1    |   2021_05_09_064644_add_ldap_columns_to_users_table ................ 20ms DONE
fireflyiii_1    |   2021_05_13_053836_extend_currency_info .......................... 145ms DONE
fireflyiii_1    |   2021_07_05_193044_drop_tele_table ................................. 9ms DONE
fireflyiii_1    |   2021_08_28_073733_user_groups [2023-04-12 23:11:54] local.ERROR: Could not create table "user_groups": SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'user_groups' already exists (Connection: mysql, SQL: create table `user_groups` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `title` varchar(255) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not create table "user_roles": SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'user_roles' already exists (Connection: mysql, SQL: create table `user_roles` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `title` varchar(255) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not create table "group_memberships": SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'group_memberships' already exists (Connection: mysql, SQL: create table `group_memberships` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `user_id` int unsigned not null, `user_group_id` bigint unsigned not null, `user_role_id` bigint unsigned not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`users` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `users` add constraint `type_user_group_id` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`accounts` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `accounts` add constraint `accounts_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`attachments` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `attachments` add constraint `attachments_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`available_budgets` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `available_budgets` add constraint `available_budgets_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`bills` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `bills` add constraint `bills_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`budgets` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `budgets` add constraint `budgets_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`categories` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `categories` add constraint `categories_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`recurrences` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `recurrences` add constraint `recurrences_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`rule_groups` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `rule_groups` add constraint `rule_groups_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`rules` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `rules` add constraint `rules_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:54] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`tags` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `tags` add constraint `tags_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`transaction_groups` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `transaction_groups` add constraint `transaction_groups_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`transaction_journals` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `transaction_journals` add constraint `transaction_journals_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: Could not execute query: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.webhooks' doesn't exist in engine (Connection: mysql, SQL: alter table `webhooks` add `user_group_id` bigint unsigned null after `user_id`)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | ................................... 697ms DONE
fireflyiii_1    |   2021_12_27_000001_create_local_personal_access_tokens_table ....... 6ms DONE
fireflyiii_1    |   2022_08_21_104626_add_user_groups [2023-04-12 23:11:55] local.ERROR: Could not execute query: SQLSTATE[HY000]: General error: 1005 Can't create table `firefly`.`currency_exchange_rates` (errno: 150 "Foreign key constraint is incorrectly formed") (Connection: mysql, SQL: alter table `currency_exchange_rates` add constraint `cer_to_ugi` foreign key (`user_group_id`) references `user_groups` (`id`) on delete set null on update cascade)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If the column or index already exists (see error), this is not an problem. Otherwise, please open a GitHub discussion.  
fireflyiii_1    | ................................ 52ms DONE
fireflyiii_1    |   2022_09_18_123911_create_notifications_table [2023-04-12 23:11:55] local.ERROR: Could not create table "notifications": SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'notifications' already exists (Connection: mysql, SQL: create table `notifications` (`id` char(36) not null, `type` varchar(191) not null, `notifiable_type` varchar(191) not null, `notifiable_id` bigint unsigned not null, `data` text not null, `read_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | ...................... 4ms DONE
fireflyiii_1    |   2022_10_01_074908_invited_users [2023-04-12 23:11:55] local.ERROR: Could not create table "invited_users": SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'invited_users' already exists (Connection: mysql, SQL: create table `invited_users` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null, `user_id` int unsigned not null, `email` varchar(255) not null, `invite_code` varchar(64) not null, `expires` datetime not null, `redeemed` tinyint(1) not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | ................................... 8ms DONE
fireflyiii_1    |   2022_10_01_210238_audit_log_entries [2023-04-12 23:11:55] local.ERROR: Could not create table "audit_log_entries": SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'audit_log_entries' already exists (Connection: mysql, SQL: create table `audit_log_entries` (`id` bigint unsigned not null auto_increment primary key, `created_at` timestamp null, `updated_at` timestamp null, `deleted_at` timestamp null, `auditable_id` int unsigned not null, `auditable_type` varchar(191) not null, `changer_id` int unsigned not null, `changer_type` varchar(191) not null, `action` varchar(255) not null, `before` text null, `after` text null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)  
fireflyiii_1    | [2023-04-12 23:11:55] local.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  
fireflyiii_1    | ............................... 6ms DONE
fireflyiii_1    | 
fireflyiii_1    |    INFO  Seeding database.  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\AccountTypeSeeder ................................. RUNNING  
fireflyiii_1    |   Database\Seeders\AccountTypeSeeder ........................... 88.44 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\TransactionCurrencySeeder ......................... RUNNING  
fireflyiii_1    |   Database\Seeders\TransactionCurrencySeeder .................. 119.92 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\TransactionTypeSeeder ............................. RUNNING  
fireflyiii_1    |   Database\Seeders\TransactionTypeSeeder ....................... 39.52 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\PermissionSeeder .................................. RUNNING  
fireflyiii_1    |   Database\Seeders\PermissionSeeder ............................. 9.70 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\LinkTypeSeeder .................................... RUNNING  
fireflyiii_1    |   Database\Seeders\LinkTypeSeeder .............................. 32.14 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\ConfigSeeder ...................................... RUNNING  
fireflyiii_1    | [2023-04-12 23:11:55] local.WARNING: Database entry exists. Update to latest version (19)  
fireflyiii_1    |   Database\Seeders\ConfigSeeder ................................ 30.16 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\UserRoleSeeder .................................... RUNNING  
fireflyiii_1    |   Database\Seeders\UserRoleSeeder .............................. 22.85 ms DONE  
fireflyiii_1    | 
fireflyiii_1    |   Database\Seeders\ExchangeRateSeeder ................................ RUNNING  
fireflyiii_1    |   Database\Seeders\ExchangeRateSeeder ......................... 307.33 ms DONE  
fireflyiii_1    | 
fireflyiii_1    | Going to decrypt the database.
fireflyiii_1    | No decryption required for table "accounts".
fireflyiii_1    | No decryption required for table "attachments".
fireflyiii_1    | No decryption required for table "bills".
fireflyiii_1    | No decryption required for table "budgets".
fireflyiii_1    | No decryption required for table "categories".
fireflyiii_1    | No decryption required for table "piggy_banks".
fireflyiii_1    | No decryption required for table "preferences".
fireflyiii_1    | No decryption required for table "tags".
fireflyiii_1    | No decryption required for table "transaction_journals".
fireflyiii_1    | No decryption required for table "transactions".
fireflyiii_1    | No decryption required for table "journal_links".
fireflyiii_1    | Done!
fireflyiii_1    | Current working dir is '/var/www/html'
fireflyiii_1    | Command executed successfully.
fireflyiii_1    | Running upgrade commands...
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | Database already seems to be migrated.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | No incorrectly stored credit card liabilities.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | Updated recurrence #1 to new transaction type model.
fireflyiii_1    | Updated recurrence #2 to new transaction type model.
fireflyiii_1    | Updated recurrence #3 to new transaction type model.
fireflyiii_1    | Updated recurrence #4 to new transaction type model.
fireflyiii_1    | Updated recurrence #5 to new transaction type model.
fireflyiii_1    | Updated recurrence #6 to new transaction type model.
fireflyiii_1    | Updated recurrence #7 to new transaction type model.
fireflyiii_1    | Updated recurrence #8 to new transaction type model.
fireflyiii_1    | Updated recurrence #9 to new transaction type model.
fireflyiii_1    | Updated recurrence #10 to new transaction type model.
fireflyiii_1    | Updated recurrence #11 to new transaction type model.
fireflyiii_1    | Updated recurrence #12 to new transaction type model.
fireflyiii_1    | Updated recurrence #13 to new transaction type model.
fireflyiii_1    | Updated recurrence #14 to new transaction type model.
fireflyiii_1    | Updated recurrence #15 to new transaction type model.
fireflyiii_1    | Updated recurrence #16 to new transaction type model.
fireflyiii_1    | Updated recurrence #17 to new transaction type model.
fireflyiii_1    | Updated recurrence #18 to new transaction type model.
fireflyiii_1    | Updated recurrence #19 to new transaction type model.
fireflyiii_1    | Update recurring transaction types in 0.57 seconds.
fireflyiii_1    | This command has already been executed.
fireflyiii_1    | Upgraded liabilities for 6.0.0 in 0.09 seconds.
fireflyiii_1    | Running verification commands...
fireflyiii_1    | All piggy bank events are correct.
fireflyiii_1    | Verified the content of 0 piggy bank events in 0.04 seconds.
fireflyiii_1    | All link types OK!
fireflyiii_1    | Verified link types in 0.05 seconds
fireflyiii_1    | All access tokens OK!
fireflyiii_1    | Verify access tokens in 0.05 seconds.
fireflyiii_1    | All transaction journals have correct bill information.
fireflyiii_1    | Verified bills / journals in 0.05 seconds
fireflyiii_1    | All budget limits are OK.
fireflyiii_1    | 1 different currencies are currently in use.
fireflyiii_1    | All currencies are correctly enabled or disabled.
fireflyiii_1    | Verified currencies in 0.12 seconds.
fireflyiii_1    | No invalid budget/journal entries.
fireflyiii_1    | Verified budget/journals in 0.06 seconds.
fireflyiii_1    | Amount integrity OK!
fireflyiii_1    | Verified amount integrity in 0.05 seconds
fireflyiii_1    | No zero-amount transaction journals.
fireflyiii_1    | Verified zero-amount integrity in 0.05 seconds
fireflyiii_1    | No orphaned journals.
fireflyiii_1    | No orphaned transactions.
fireflyiii_1    | No orphaned accounts.
fireflyiii_1    | Verified orphans in 0.06 seconds
fireflyiii_1    | No uneven transaction journals.
fireflyiii_1    | No empty transaction journals.
fireflyiii_1    | Verified empty journals in 0.01 seconds
fireflyiii_1    | Verified empty groups in 0.05 seconds
fireflyiii_1    | All account types are OK!
fireflyiii_1    | Verifying account types took 14.33 seconds
fireflyiii_1    | Verifying account order took 0.07 seconds
fireflyiii_1    | All meta fields are correct.
fireflyiii_1    | Renamed meta fields in 0.16 seconds
fireflyiii_1    | Going to verify 9 opening balance transactions.
fireflyiii_1    | There was nothing to fix in the opening balance transactions.
fireflyiii_1    | Verified all transaction group and journal title lengths.
fireflyiii_1    | Took 0.17 seconds.
fireflyiii_1    | Recurring transaction #16 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #2 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #15 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #17 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #13 should be a "Transfer" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #19 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #3 should be a "Deposit" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #8 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #7 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #1 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #12 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #6 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #14 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #4 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #5 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #11 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #9 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #10 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Recurring transaction #18 should be a "Withdrawal" but is a "Invalid" and will be corrected.
fireflyiii_1    | Corrected recurring transactions in 0.52 seconds.
fireflyiii_1    | Updated inconsistent transaction groups.
fireflyiii_1    | All transaction journals are of the correct transaction type (in 0.59 seconds).
fireflyiii_1    | Verifying account preferences took 0.09 seconds
fireflyiii_1    | [2023-04-12 23:12:40] local.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.user_groups' doesn't exist in engine (Connection: mysql, SQL: select * from `user_groups` where `title` = MYUSER limit 1)","time":"Wed, 12 Apr 2023 23:12:40 +0200","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":793,"code":"42S02","version":"6.0.7","url":"http:\/\/localhost","userAgent":"Symfony","json":true,"method":"GET"}  
fireflyiii_1    | [2023-04-12 23:12:40] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.user_groups' doesn't exist in engine (Connection: mysql, SQL: select * from `user_groups` where `title` = MYUSER limit 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.user_groups' doesn't exist in engine (Connection: mysql, SQL: select * from `user_groups` where `title` = MYUSER limit 1) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:793)
fireflyiii_1    | [stacktrace]
fireflyiii_1    | #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback()
fireflyiii_1    | #1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\\Database\\Connection->run()
fireflyiii_1    | #2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2718): Illuminate\\Database\\Connection->select()
fireflyiii_1    | #3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect()
fireflyiii_1    | #4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
fireflyiii_1    | #5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Query\\Builder->onceWithColumns()
fireflyiii_1    | #6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(717): Illuminate\\Database\\Query\\Builder->get()
fireflyiii_1    | #7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(701): Illuminate\\Database\\Eloquent\\Builder->getModels()
fireflyiii_1    | #8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\\Database\\Eloquent\\Builder->get()
fireflyiii_1    | #9 /var/www/html/app/Console/Commands/Integrity/CreateGroupMemberships.php(96): Illuminate\\Database\\Eloquent\\Builder->first()
fireflyiii_1    | #10 /var/www/html/app/Console/Commands/Integrity/CreateGroupMemberships.php(82): FireflyIII\\Console\\Commands\\Integrity\\CreateGroupMemberships::createGroupMembership()
fireflyiii_1    | #11 /var/www/html/app/Console/Commands/Integrity/CreateGroupMemberships.php(64): FireflyIII\\Console\\Commands\\Integrity\\CreateGroupMemberships->createGroupMemberships()
fireflyiii_1    | #12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Integrity\\CreateGroupMemberships->handle()
fireflyiii_1    | #13 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
fireflyiii_1    | #14 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
fireflyiii_1    | #15 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
fireflyiii_1    | #16 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
fireflyiii_1    | #17 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
fireflyiii_1    | #18 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
fireflyiii_1    | #19 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
fireflyiii_1    | #20 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
fireflyiii_1    | #21 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
fireflyiii_1    | #22 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
fireflyiii_1    | #23 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(200): Symfony\\Component\\Console\\Application->run()
fireflyiii_1    | #24 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
fireflyiii_1    | #25 {main}
fireflyiii_1    | 
fireflyiii_1    | [previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.user_groups' doesn't exist in engine at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414)
fireflyiii_1    | [stacktrace]
fireflyiii_1    | #0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(414): PDO->prepare()
fireflyiii_1    | #1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(786): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
fireflyiii_1    | #2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(753): Illuminate\\Database\\Connection->runQueryCallback()
fireflyiii_1    | #3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(405): Illuminate\\Database\\Connection->run()
fireflyiii_1    | #4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2718): Illuminate\\Database\\Connection->select()
fireflyiii_1    | #5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2707): Illuminate\\Database\\Query\\Builder->runSelect()
fireflyiii_1    | #6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3248): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
fireflyiii_1    | #7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2706): Illuminate\\Database\\Query\\Builder->onceWithColumns()
fireflyiii_1    | #8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(717): Illuminate\\Database\\Query\\Builder->get()
fireflyiii_1    | #9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(701): Illuminate\\Database\\Eloquent\\Builder->getModels()
fireflyiii_1    | #10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php(296): Illuminate\\Database\\Eloquent\\Builder->get()
fireflyiii_1    | #11 /var/www/html/app/Console/Commands/Integrity/CreateGroupMemberships.php(96): Illuminate\\Database\\Eloquent\\Builder->first()
fireflyiii_1    | #12 /var/www/html/app/Console/Commands/Integrity/CreateGroupMemberships.php(82): FireflyIII\\Console\\Commands\\Integrity\\CreateGroupMemberships::createGroupMembership()
fireflyiii_1    | #13 /var/www/html/app/Console/Commands/Integrity/CreateGroupMemberships.php(64): FireflyIII\\Console\\Commands\\Integrity\\CreateGroupMemberships->createGroupMemberships()
fireflyiii_1    | #14 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Integrity\\CreateGroupMemberships->handle()
fireflyiii_1    | #15 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
fireflyiii_1    | #16 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
fireflyiii_1    | #17 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
fireflyiii_1    | #18 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
fireflyiii_1    | #19 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(194): Illuminate\\Container\\Container->call()
fireflyiii_1    | #20 /var/www/html/vendor/symfony/console/Command/Command.php(312): Illuminate\\Console\\Command->execute()
fireflyiii_1    | #21 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(163): Symfony\\Component\\Console\\Command\\Command->run()
fireflyiii_1    | #22 /var/www/html/vendor/symfony/console/Application.php(1040): Illuminate\\Console\\Command->run()
fireflyiii_1    | #23 /var/www/html/vendor/symfony/console/Application.php(314): Symfony\\Component\\Console\\Application->doRunCommand()
fireflyiii_1    | #24 /var/www/html/vendor/symfony/console/Application.php(168): Symfony\\Component\\Console\\Application->doRun()
fireflyiii_1    | #25 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(200): Symfony\\Component\\Console\\Application->run()
fireflyiii_1    | #26 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
fireflyiii_1    | #27 {main}
fireflyiii_1    | "} 
fireflyiii_1    | 
fireflyiii_1    |    Illuminate\Database\QueryException 
fireflyiii_1    | 
fireflyiii_1    |   SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.user_groups' doesn't exist in engine (Connection: mysql, SQL: select * from `user_groups` where `title` = MYUSER limit 1)
fireflyiii_1    | 
fireflyiii_1    |   at vendor/laravel/framework/src/Illuminate/Database/Connection.php:793
fireflyiii_1    |     789▕         // If an exception occurs when attempting to run a query, we'll format the error
fireflyiii_1    |     790▕         // message to include the bindings with SQL, which will make this exception a
fireflyiii_1    |     791▕         // lot more helpful to the developer instead of just the database's errors.
fireflyiii_1    |     792▕         catch (Exception $e) {
fireflyiii_1    |   ➜ 793▕             throw new QueryException(
fireflyiii_1    |     794▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
fireflyiii_1    |     795▕             );
fireflyiii_1    |     796▕         }
fireflyiii_1    |     797▕     }
fireflyiii_1    | 
fireflyiii_1    |   i   A table was not found: You might have forgotten to run your database migrations. 
fireflyiii_1    |       https://laravel.com/docs/master/migrations#running-migrations
fireflyiii_1    | 
fireflyiii_1    |       +12 vendor frames 
fireflyiii_1    | 
fireflyiii_1    |   13  app/Console/Commands/Integrity/CreateGroupMemberships.php:96
fireflyiii_1    |       Illuminate\Database\Eloquent\Builder::first()
fireflyiii_1    | 
fireflyiii_1    |   14  app/Console/Commands/Integrity/CreateGroupMemberships.php:82
fireflyiii_1    |       FireflyIII\Console\Commands\Integrity\CreateGroupMemberships::createGroupMembership()
fireflyiii_1    | 
fireflyiii_1    | User "MYUSER" has no group.
fireflyiii_1    | Running report commands...
fireflyiii_1    | User #1 (MYUSER) has tag #2 ("TAG") which has no transaction journals.
fireflyiii_1    | User #1 (MYUSER) has account #20 ("Account20") which has no transactions.
fireflyiii_1    | User #1 (MYUSER) has account #99 ("Account99") which has no transactions.
fireflyiii_1    | Report on empty objects finished in 0.09 seconds
fireflyiii_1    | Amount integrity OK for user #1
fireflyiii_1    | Report on total sum finished in 0.07 seconds
fireflyiii_1    | OAuth keys are OK
fireflyiii_1    | Generating new OAuth keys...
fireflyiii_1    | Encryption keys already exist. Use the --force option to overwrite them.
fireflyiii_1    | Personal access client created successfully.
fireflyiii_1    | Client ID: 239
fireflyiii_1    | Client secret: SECRET
fireflyiii_1    | Password grant client created successfully.
fireflyiii_1    | Client ID: 240
fireflyiii_1    | Client secret: SECRET
fireflyiii_1    | Updated version.
fireflyiii_1    | +------------------------------------------------------------------------------+
fireflyiii_1    | |                                                                              |
fireflyiii_1    | | Thank you for installing Firefly III, v6.0.7!                                |
fireflyiii_1    | |                                                                              |
fireflyiii_1    | |                                                                              |
fireflyiii_1    | +------------------------------------------------------------------------------+
fireflyiii_1    | You can safely ignore the error about the 'fully qualified domain name'.
fireflyiii_1    | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.31.0.3. Set the 'ServerName' directive globally to suppress this message
fireflyiii_1    | AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.31.0.3. Set the 'ServerName' directive globally to suppress this message
fireflyiii_1    | [Wed Apr 12 23:12:47.503867 2023] [mpm_prefork:notice] [pid 1] AH00163: Apache/2.4.56 (Debian) configured -- resuming normal operations
fireflyiii_1    | [Wed Apr 12 23:12:47.504261 2023] [core:notice] [pid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

Debug info

Debug information generated at 2023-04-12 23:20:03 Europe/Berlin for Firefly III version 5.7.9.

Scope	Version
Firefly III	5.7.9
Firefly III API	1.5.6
Build	196, 09-06-2022 18:30:26 CEST
DB version	18 (exp. 18)
PHP	8.0.17
Host	Linux

System info	Value
System TZ	Europe/Berlin
Browser TZ	Europe/Berlin
App environment	local
App debug mode	false
App cache driver	file
App logging	notice, stack
Display errors	Off
Error reporting	ALL errors
Interface	apache2handler
Default language	en_US
Default locale	equal
BCscale	24
DB drivers	mysql, pgsql, sqlite
Current driver	mysql
Trusted proxies (.env)	**

User info	Value
Login provider	eloquent
User guard	web
Headers	N/A, N/A
Stateful domains
Session start	2023-04-01 00:00:00
Session end	2023-04-30 23:59:59
Session first	2020-08-03 00:00:00
User ID	1
User language	de_DE
User locale	de_DE
Attempt at "de_DE.utf8"	'de_DE.utf8'
Attempt at "de_DE.UTF-8"	'de_DE.UTF-8'
User agent	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/111.0

[JC5]

It looks like your database is messed up, but I have no clue to the original cause. I'm working on some improved database migration checks but they may not be able to solve this one.

I see you're using mysql, is that correct?

[Azlond]

Yes, I am using mysql. I'll probably have to try a manual migration then?

[JC5]

I think so yes, the errors I see are a bit vague, as in: i havent seen them before.

[Azlond]

Alright, thanks for taking a look though! Anything I should watch out for when trying to migrate manually?

[JC5]

Make sure you have a backup, and see if you can do a new Firefly III run into a new database. Then you can either compare missing fields and create them manually in your own DB.