[Support] Corrupted database after updates? #9625

Dinth · 2025-01-05T10:54:48Z

Dinth
Jan 5, 2025

Hiya. Im not sure if this is a Firefly III bug/issue or something on my side, but because of a newborn baby we havent been able to use Firefly III for a several months (during that time it has received some updates which were automatically deployed using watchtower), but right now we just cant login.
Because we havent used Firefly III for long time, im not sure exactly when the problem has originally started and most likely the database backups were already overwritten, so i cant roll back.

When i start the container im getting the following in docker logs:

Now in entrypoint.sh for Firefly III

Script:            1.4.1 (2024-05-18)

User:              root

Group:             root

Working dir:       /var/www/html

Base build number: 92

Base build date:   01-11-2024 05:42:41 CET

Build number:      1160

Build date:        18-12-2024 16:40:39 CET

APACHE_RUN_GROUP:  

APACHE_RUN_USER:   

  [!] Environment variable MAIL_MAILER is empty.

  [!] Environment variable MAIL_FROM is empty.

Generating optimized autoload files

> Illuminate\Foundation\ComposerScripts::postAutoloadDump

Generated optimized autoload files containing 7737 classes

   INFO  Discovering packages.  

  diglactic/laravel-breadcrumbs ......................................... DONE

  genealabs/laravel-model-caching ....................................... DONE

  jc5/google2fa-laravel ................................................. DONE

  laravel-json-api/encoder-neomerx ...................................... DONE

  laravel-json-api/laravel .............................................. DONE

  laravel-json-api/spec ................................................. DONE

  laravel-json-api/validation ........................................... DONE

  laravel/passport ...................................................... DONE

  laravel/sanctum ....................................................... DONE

  laravel/slack-notification-channel .................................... DONE

  laravel/ui ............................................................ DONE

  mailersend/laravel-driver ............................................. DONE

  nesbot/carbon ......................................................... DONE

  nunomaduro/collision .................................................. DONE

  nunomaduro/termwind ................................................... DONE

  rcrowe/twigbridge ..................................................... DONE

  spatie/laravel-html ................................................... DONE

  spatie/laravel-ignition ............................................... DONE

  [i] Wait for the database. You may see an error about an 'aborted connection', this is normal.

wait-for-it.sh: waiting 60 seconds for 10.10.1.13:5432

wait-for-it.sh: 10.10.1.13:5432 is available after 0 seconds

  [✓] DB is up.

  [i] Wait another 10 seconds in case the DB needs to boot.

  [✓] Done waiting for the DB to boot.

  [i] Will run database commands.

  [i] CreateDB does not apply to "pgsql", skipped.

  [i] Will run upgrade commands.

   INFO  Running migrations.  

  2023_10_21_113213_add_currency_pivot_tables [2025-01-05 10:47:50] production.ERROR: Could not create table "transaction_currency_user": SQLSTATE[42501]: Insufficient privilege: 7 ERROR:  permission denied for schema public at character 14 (Connection: pgsql, SQL: create table "transaction_currency_user" ("id" bigserial not null primary key, "created_at" timestamp(0) without time zone null, "updated_at" timestamp(0) without time zone null, "user_id" integer not null, "transaction_currency_id" integer not null, "user_default" boolean not null default '0'))  

[2025-01-05 10:47:50] production.ERROR: If this table exists already (see the error message), this is not a problem. Other errors? Please open a discussion on GitHub.  

................... 18.22ms FAIL

[2025-01-05 10:47:50] production.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: select exists (select 1 from pg_class c, pg_namespace n where n.nspname = 'public' and c.relname = 'transaction_currency_user_group' and c.relkind in ('r', 'p') and n.oid = c.relnamespace))","time":"Sun, 05 Jan 2025 10:47:50 +0000","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":825,"code":"25P02","version":"6.1.25","url":"https:\/\/finance.wickhay.uk","userAgent":"Symfony","json":true,"method":"GET","post":""}  

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: select exists (select 1 from pg_class c, pg_namespace n where n.nspname = 'public' and c.relname = 'transaction_currency_user_group' and c.relkind in ('r', 'p') and n.oid = c.relnamespace)) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 25P02): SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: select exists (select 1 from pg_class c, pg_namespace n where n.nspname = 'public' and c.relname = 'transaction_currency_user_group' and c.relkind in ('r', 'p') and n.oid = c.relnamespace)) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)

�
[stacktrace]

#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()

#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()

#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(344): Illuminate\\Database\\Connection->select()

#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Illuminate\\Database\\Connection->selectOne()

#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/PostgresBuilder.php(52): Illuminate\\Database\\Connection->scalar()

#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\PostgresBuilder->hasTable()

#6 /var/www/html/database/migrations/2023_10_21_113213_add_currency_pivot_tables.php(57): Illuminate\\Support\\Facades\\Facade::__callStatic()

#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(476): Illuminate\\Database\\Migrations\\Migration@anonymous->up()

#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\\Database\\Migrations\\Migrator->runMethod()

#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(32): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()

#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Connection->transaction()

#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\\Database\\Migrations\\Migrator->runMigration()

#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()

#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(737): Illuminate\\Console\\View\\Components\\Task->render()

#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\\Database\\Migrations\\Migrator->write()

#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(180): Illuminate\\Database\\Migrations\\Migrator->runUp()

#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(123): Illuminate\\Database\\Migrations\\Migrator->runPending()

#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()

#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(616): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()

#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()

#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()

#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()

#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()

#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()

#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()

#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()

#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()

#27 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()

#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()

#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\\Console\\Command->run()

#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\\Console\\Command->runCommand()

#31 /var/www/html/app/Console/Commands/Upgrade/UpgradeDatabase.php(95): Illuminate\\Console\\Command->call()

#32 /var/www/html/app/Console/Commands/Upgrade/UpgradeDatabase.php(47): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->callInitialCommands()

#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->handle()

#34 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()

#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()

#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()

#37 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()

#38 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()

#39 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()

#40 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()

#41 /var/www/html/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()

#42 /var/www/html/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()

#43 /var/www/html/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()

#44 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()

#45 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()

#46 {main}

[previous exception] [object] (PDOException(code: 25P02): SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:412)

�
[stacktrace]

#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(412): PDOStatement->execute()

#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()

#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()

#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(398): Illuminate\\Database\\Connection->run()

#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(344): Illuminate\\Database\\Connection->select()

#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(361): Illuminate\\Database\\Connection->selectOne()

#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Schema/PostgresBuilder.php(52): Illuminate\\Database\\Connection->scalar()

#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\PostgresBuilder->hasTable()

#8 /var/www/html/database/migrations/2023_10_21_113213_add_currency_pivot_tables.php(57): Illuminate\\Support\\Facades\\Facade::__callStatic()

#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(476): Illuminate\\Database\\Migrations\\Migration@anonymous->up()

#10 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\\Database\\Migrations\\Migrator->runMethod()

#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Concerns/ManagesTransactions.php(32): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()

#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Connection->transaction()

#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\\Database\\Migrations\\Migrator->runMigration()

#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()

#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(737): Illuminate\\Console\\View\\Components\\Task->render()

#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\\Database\\Migrations\\Migrator->write()

#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(180): Illuminate\\Database\\Migrations\\Migrator->runUp()

#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(123): Illuminate\\Database\\Migrations\\Migrator->runPending()

#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\\Database\\Migrations\\Migrator->run()

#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(616): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()

#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\\Database\\Migrations\\Migrator->usingConnection()

#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()

#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()

#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()

#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()

#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()

#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()

#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()

#29 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()

#30 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()

#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\\Console\\Command->run()

#32 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\\Console\\Command->runCommand()

#33 /var/www/html/app/Console/Commands/Upgrade/UpgradeDatabase.php(95): Illuminate\\Console\\Command->call()

#34 /var/www/html/app/Console/Commands/Upgrade/UpgradeDatabase.php(47): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->callInitialCommands()

#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->handle()

#36 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()

#37 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()

#38 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()

#39 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()

#40 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()

#41 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()

#42 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()

#43 /var/www/html/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()

#44 /var/www/html/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()

#45 /var/www/html/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()

#46 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()

#47 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()

#48 {main}

"} 

   Illuminate\Database\QueryException 

  SQLSTATE[25P02]: In failed sql transaction: 7 ERROR:  current transaction is aborted, commands ignored until end of transaction block (Connection: pgsql, SQL: select exists (select 1 from pg_class c, pg_namespace n where n.nspname = 'public' and c.relname = 'transaction_currency_user_group' and c.relkind in ('r', 'p') and n.oid = c.relnamespace))

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:825

    821▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e

    822▕                 );

    823▕             }

    824▕ 

  ➜ 825▕             throw new QueryException(

    826▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e

    827▕             );

    828▕         }

    829▕     }

      +9 vendor frames 

  10  database/migrations/2023_10_21_113213_add_currency_pivot_tables.php:57

      Illuminate\Support\Facades\Facade::__callStatic()

      +24 vendor frames 

  35  app/Console/Commands/Upgrade/UpgradeDatabase.php:95

      Illuminate\Console\Command::call()

  [i] Will run report commands.

      Now executing firefly-iii:add-timezones-to-dates

  [x]  Cannot add timezone information to field "date" of model "AccountBalance". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42P01]: Undefined table: 7 ERROR:  relation "account_balances" does not exist

LINE 1: select count(*) as aggregate from "account_balances" where "...

                                          ^ (Connection: pgsql, SQL: select count(*) as aggregate from "account_balances" where "date_tz" is null)  

  [✓] Timezone information is present in field "date" of model "AccountBalance".

  [x]  Cannot add timezone information to field "start_date" of model "AvailableBudget". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "start_date_tz" does not exist

LINE 1: ...nt(*) as aggregate from "available_budgets" where "start_dat...

                                                             ^

HINT:  Perhaps you meant to reference the column "available_budgets.start_date". (Connection: pgsql, SQL: select count(*) as aggregate from "available_budgets" where "start_date_tz" is null and "available_budgets"."deleted_at" is null)  

  [✓] Timezone information is present in field "start_date" of model "AvailableBudget".

  [x]  Cannot add timezone information to field "end_date" of model "AvailableBudget". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "end_date_tz" does not exist

LINE 1: ...nt(*) as aggregate from "available_budgets" where "end_date_...

                                                             ^

HINT:  Perhaps you meant to reference the column "available_budgets.end_date". (Connection: pgsql, SQL: select count(*) as aggregate from "available_budgets" where "end_date_tz" is null and "available_budgets"."deleted_at" is null)  

  [✓] Timezone information is present in field "end_date" of model "AvailableBudget".

  [x]  Cannot add timezone information to field "date" of model "Bill". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "date_tz" does not exist

LINE 1: select count(*) as aggregate from "bills" where "date_tz" is...

                                                        ^

HINT:  Perhaps you meant to reference the column "bills.date". (Connection: pgsql, SQL: select count(*) as aggregate from "bills" where "date_tz" is null and "bills"."deleted_at" is null)  

  [✓] Timezone information is present in field "date" of model "Bill".

  [x]  Cannot add timezone information to field "end_date" of model "Bill". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "end_date_tz" does not exist

LINE 1: select count(*) as aggregate from "bills" where "end_date_tz...

                                                        ^

HINT:  Perhaps you meant to reference the column "bills.end_date". (Connection: pgsql, SQL: select count(*) as aggregate from "bills" where "end_date_tz" is null and "bills"."deleted_at" is null)  

  [✓] Timezone information is present in field "end_date" of model "Bill".

  [x]  Cannot add timezone information to field "extension_date" of model "Bill". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "extension_date_tz" does not exist

LINE 1: select count(*) as aggregate from "bills" where "extension_d...

                                                        ^

HINT:  Perhaps you meant to reference the column "bills.extension_date". (Connection: pgsql, SQL: select count(*) as aggregate from "bills" where "extension_date_tz" is null and "bills"."deleted_at" is null)  

  [✓] Timezone information is present in field "extension_date" of model "Bill".

  [x]  Cannot add timezone information to field "start_date" of model "BudgetLimit". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "start_date_tz" does not exist

LINE 1: ... count(*) as aggregate from "budget_limits" where "start_dat...

                                                             ^

HINT:  Perhaps you meant to reference the column "budget_limits.start_date". (Connection: pgsql, SQL: select count(*) as aggregate from "budget_limits" where "start_date_tz" is null)  

  [✓] Timezone information is present in field "start_date" of model "BudgetLimit".

  [x]  Cannot add timezone information to field "end_date" of model "BudgetLimit". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "end_date_tz" does not exist

LINE 1: ... count(*) as aggregate from "budget_limits" where "end_date_...

                                                             ^

HINT:  Perhaps you meant to reference the column "budget_limits.end_date". (Connection: pgsql, SQL: select count(*) as aggregate from "budget_limits" where "end_date_tz" is null)  

  [✓] Timezone information is present in field "end_date" of model "BudgetLimit".

  [x]  Cannot add timezone information to field "date" of model "CurrencyExchangeRate". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "date_tz" does not exist

LINE 1: ...as aggregate from "currency_exchange_rates" where "date_tz" ...

                                                             ^

HINT:  Perhaps you meant to reference the column "currency_exchange_rates.date". (Connection: pgsql, SQL: select count(*) as aggregate from "currency_exchange_rates" where "date_tz" is null and "currency_exchange_rates"."deleted_at" is null)  

  [✓] Timezone information is present in field "date" of model "CurrencyExchangeRate".

  [x]  Cannot add timezone information to field "expires" of model "InvitedUser". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "expires_tz" does not exist

LINE 1: ... count(*) as aggregate from "invited_users" where "expires_t...

                                                             ^

HINT:  Perhaps you meant to reference the column "invited_users.expires". (Connection: pgsql, SQL: select count(*) as aggregate from "invited_users" where "expires_tz" is null)  

  [✓] Timezone information is present in field "expires" of model "InvitedUser".

  [x]  Cannot add timezone information to field "date" of model "PiggyBankEvent". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "date_tz" does not exist

LINE 1: ...nt(*) as aggregate from "piggy_bank_events" where "date_tz" ...

                                                             ^

HINT:  Perhaps you meant to reference the column "piggy_bank_events.date". (Connection: pgsql, SQL: select count(*) as aggregate from "piggy_bank_events" where "date_tz" is null)  

  [✓] Timezone information is present in field "date" of model "PiggyBankEvent".

  [x]  Cannot add timezone information to field "startdate" of model "PiggyBankRepetition". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "startdate_tz" does not exist

LINE 1: ... as aggregate from "piggy_bank_repetitions" where "startdate...

                                                             ^

HINT:  Perhaps you meant to reference the column "piggy_bank_repetitions.startdate". (Connection: pgsql, SQL: select count(*) as aggregate from "piggy_bank_repetitions" where "startdate_tz" is null)  

  [✓] Timezone information is present in field "startdate" of model "PiggyBankRepetition".

  [x]  Cannot add timezone information to field "targetdate" of model "PiggyBankRepetition". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "targetdate_tz" does not exist

LINE 1: ... as aggregate from "piggy_bank_repetitions" where "targetdat...

                                                             ^

HINT:  Perhaps you meant to reference the column "piggy_bank_repetitions.targetdate". (Connection: pgsql, SQL: select count(*) as aggregate from "piggy_bank_repetitions" where "targetdate_tz" is null)  

  [✓] Timezone information is present in field "targetdate" of model "PiggyBankRepetition".

  [x]  Cannot add timezone information to field "startdate" of model "PiggyBank". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "startdate_tz" does not exist

LINE 1: ...ct count(*) as aggregate from "piggy_banks" where "startdate...

                                                             ^

HINT:  Perhaps you meant to reference the column "piggy_banks.startdate". (Connection: pgsql, SQL: select count(*) as aggregate from "piggy_banks" where "startdate_tz" is null and "piggy_banks"."deleted_at" is null)  

  [✓] Timezone information is present in field "startdate" of model "PiggyBank".

  [x]  Cannot add timezone information to field "targetdate" of model "PiggyBank". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "targetdate_tz" does not exist

LINE 1: ...ct count(*) as aggregate from "piggy_banks" where "targetdat...

                                                             ^

HINT:  Perhaps you meant to reference the column "piggy_banks.targetdate". (Connection: pgsql, SQL: select count(*) as aggregate from "piggy_banks" where "targetdate_tz" is null and "piggy_banks"."deleted_at" is null)  

  [✓] Timezone information is present in field "targetdate" of model "PiggyBank".

  [x]  Cannot add timezone information to field "first_date" of model "Recurrence". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "first_date_tz" does not exist

LINE 1: ...ct count(*) as aggregate from "recurrences" where "first_dat...

                                                             ^

HINT:  Perhaps you meant to reference the column "recurrences.first_date". (Connection: pgsql, SQL: select count(*) as aggregate from "recurrences" where "first_date_tz" is null and "recurrences"."deleted_at" is null)  

  [✓] Timezone information is present in field "first_date" of model "Recurrence".

  [x]  Cannot add timezone information to field "repeat_until" of model "Recurrence". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "repeat_until_tz" does not exist

LINE 1: ...ct count(*) as aggregate from "recurrences" where "repeat_un...

                                                             ^

HINT:  Perhaps you meant to reference the column "recurrences.repeat_until". (Connection: pgsql, SQL: select count(*) as aggregate from "recurrences" where "repeat_until_tz" is null and "recurrences"."deleted_at" is null)  

  [✓] Timezone information is present in field "repeat_until" of model "Recurrence".

  [x]  Cannot add timezone information to field "latest_date" of model "Recurrence". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "latest_date_tz" does not exist

LINE 1: ...ct count(*) as aggregate from "recurrences" where "latest_da...

                                                             ^

HINT:  Perhaps you meant to reference the column "recurrences.latest_date". (Connection: pgsql, SQL: select count(*) as aggregate from "recurrences" where "latest_date_tz" is null and "recurrences"."deleted_at" is null)  

  [✓] Timezone information is present in field "latest_date" of model "Recurrence".

  [x]  Cannot add timezone information to field "date" of model "Tag". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "date_tz" does not exist

LINE 1: select count(*) as aggregate from "tags" where "date_tz" is ...

                                                       ^

HINT:  Perhaps you meant to reference the column "tags.date". (Connection: pgsql, SQL: select count(*) as aggregate from "tags" where "date_tz" is null and "tags"."deleted_at" is null)  

  [✓] Timezone information is present in field "date" of model "Tag".

  [x]  Cannot add timezone information to field "date" of model "TransactionJournal". Field does not exist.

[2025-01-05 10:47:50] production.ERROR: SQLSTATE[42703]: Undefined column: 7 ERROR:  column "date_tz" does not exist

LINE 1: ...*) as aggregate from "transaction_journals" where "date_tz" ...

                                                             ^

HINT:  Perhaps you meant to reference the column "transaction_journals.date". (Connection: pgsql, SQL: select count(*) as aggregate from "transaction_journals" where "date_tz" is null and "transaction_journals"."deleted_at" is null)  

  [✓] Timezone information is present in field "date" of model "TransactionJournal".

      Now executing firefly-iii:create-group-memberships

  [✓] Validated group memberships

      Now executing firefly-iii:report-empty-objects

  [!] User #3 (xxx@xxx) has budget #3 ("Main Budget") which has no transaction journals.
[and here a long list of transactions without journals]

Help please, i remember that after i have originally set up Firefly III, we've spend many weeks adding rules, categories, tags to each bank transaction within the last few years, and i really dont want to loose all that work

Dinth · 2025-01-05T11:36:01Z

Dinth
Jan 5, 2025
Author

So i have done:
ALTER DATABASE fireflyiii OWNER TO fireflyiii;
And now the log looks much better, also i am able to log in to Firefly. But it doesnt load any data. Here's the log:

172.17.0.1 - - [05/Jan/2025:11:31:27 +0000] "GET /reports/audit/231,1,3,4,12,210,234,236/20200101/currentMonthEnd HTTP/1.1" 200 51527 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36"

Now in entrypoint.sh for Firefly III

Script:            1.4.1 (2024-05-18)

User:              root

Group:             root

Working dir:       /var/www/html

Base build number: 92

Base build date:   01-11-2024 05:42:41 CET

Build number:      1160

Build date:        18-12-2024 16:40:39 CET

APACHE_RUN_GROUP:  

APACHE_RUN_USER:   

  [!] Environment variable MAIL_MAILER is empty.

  [!] Environment variable MAIL_FROM is empty.

Generating optimized autoload files

> Illuminate\Foundation\ComposerScripts::postAutoloadDump

Generated optimized autoload files containing 7737 classes

   INFO  Discovering packages.  

  diglactic/laravel-breadcrumbs ......................................... DONE

  genealabs/laravel-model-caching ....................................... DONE

  jc5/google2fa-laravel ................................................. DONE

  laravel-json-api/encoder-neomerx ...................................... DONE

  laravel-json-api/laravel .............................................. DONE

  laravel-json-api/spec ................................................. DONE

  laravel-json-api/validation ........................................... DONE

  laravel/passport ...................................................... DONE

  laravel/sanctum ....................................................... DONE

  laravel/slack-notification-channel .................................... DONE

  laravel/ui ............................................................ DONE

  mailersend/laravel-driver ............................................. DONE

  nesbot/carbon ......................................................... DONE

  nunomaduro/collision .................................................. DONE

  nunomaduro/termwind ................................................... DONE

  rcrowe/twigbridge ..................................................... DONE

  spatie/laravel-html ................................................... DONE

  spatie/laravel-ignition ............................................... DONE

  [i] Wait for the database. You may see an error about an 'aborted connection', this is normal.

wait-for-it.sh: waiting 60 seconds for 10.10.1.13:5432

wait-for-it.sh: 10.10.1.13:5432 is available after 0 seconds

  [✓] DB is up.

  [i] Wait another 10 seconds in case the DB needs to boot.

  [✓] Done waiting for the DB to boot.

  [i] Will run database commands.

  [i] CreateDB does not apply to "pgsql", skipped.

  [i] Will run upgrade commands.

   INFO  Nothing to migrate.  

   INFO  Seeding database.  

  Database\Seeders\AccountTypeSeeder ................................. RUNNING  

  Database\Seeders\AccountTypeSeeder .............................. 29 ms DONE  

  Database\Seeders\TransactionCurrencySeeder ......................... RUNNING  

  Database\Seeders\TransactionCurrencySeeder ...................... 28 ms DONE  

  Database\Seeders\TransactionTypeSeeder ............................. RUNNING  

  Database\Seeders\TransactionTypeSeeder ........................... 8 ms DONE  

  Database\Seeders\PermissionSeeder .................................. RUNNING  

  Database\Seeders\PermissionSeeder ................................ 3 ms DONE  

  Database\Seeders\LinkTypeSeeder .................................... RUNNING  

  Database\Seeders\LinkTypeSeeder .................................. 5 ms DONE  

  Database\Seeders\ConfigSeeder ...................................... RUNNING  

  Database\Seeders\ConfigSeeder .................................... 3 ms DONE  

  Database\Seeders\UserRoleSeeder .................................... RUNNING  

  Database\Seeders\UserRoleSeeder ................................. 23 ms DONE  

  Database\Seeders\ExchangeRateSeeder ................................ RUNNING  

  Database\Seeders\ExchangeRateSeeder ............................ 114 ms DONE  

      Going to verify PostgreSQL table sequences.

      Checking the next id sequence for table "2fa_tokens".

  [i] nextval is NULL for table "2fa_tokens", go to next table.

      Checking the next id sequence for table "account_meta".

  [✓] Table "account_meta" autoincrement is correct.

      Checking the next id sequence for table "account_types".

  [✓] Table "account_types" autoincrement is correct.

      Checking the next id sequence for table "accounts".

  [✓] Table "accounts" autoincrement is correct.

      Checking the next id sequence for table "attachments".

  [i] nextval is NULL for table "attachments", go to next table.

      Checking the next id sequence for table "auto_budgets".

  [i] nextval is NULL for table "auto_budgets", go to next table.

      Checking the next id sequence for table "available_budgets".

  [✓] Table "available_budgets" autoincrement is correct.

      Checking the next id sequence for table "bills".

  [✓] Table "bills" autoincrement is correct.

      Checking the next id sequence for table "budget_limits".

  [✓] Table "budget_limits" autoincrement is correct.

      Checking the next id sequence for table "budget_transaction".

  [i] nextval is NULL for table "budget_transaction", go to next table.

      Checking the next id sequence for table "budget_transaction_journal".

  [i] nextval is NULL for table "budget_transaction_journal", go to next table.

      Checking the next id sequence for table "budgets".

  [✓] Table "budgets" autoincrement is correct.

      Checking the next id sequence for table "categories".

  [✓] Table "categories" autoincrement is correct.

      Checking the next id sequence for table "category_transaction".

  [i] nextval is NULL for table "category_transaction", go to next table.

      Checking the next id sequence for table "category_transaction_journal".

  [✓] Table "category_transaction_journal" autoincrement is correct.

      Checking the next id sequence for table "configuration".

  [✓] Table "configuration" autoincrement is correct.

      Checking the next id sequence for table "currency_exchange_rates".

  [✓] Table "currency_exchange_rates" autoincrement is correct.

      Checking the next id sequence for table "failed_jobs".

  [i] nextval is NULL for table "failed_jobs", go to next table.

      Checking the next id sequence for table "group_journals".

  [i] nextval is NULL for table "group_journals", go to next table.

      Checking the next id sequence for table "jobs".

  [i] nextval is NULL for table "jobs", go to next table.

      Checking the next id sequence for table "journal_links".

  [i] nextval is NULL for table "journal_links", go to next table.

      Checking the next id sequence for table "journal_meta".

  [✓] Table "journal_meta" autoincrement is correct.

      Checking the next id sequence for table "link_types".

  [✓] Table "link_types" autoincrement is correct.

      Checking the next id sequence for table "locations".

  [i] nextval is NULL for table "locations", go to next table.

      Checking the next id sequence for table "migrations".

  [✓] Table "migrations" autoincrement is correct.

      Checking the next id sequence for table "notes".

  [✓] Table "notes" autoincrement is correct.

      Checking the next id sequence for table "oauth_clients".

  [✓] Table "oauth_clients" autoincrement is correct.

      Checking the next id sequence for table "oauth_personal_access_clients".

  [✓] Table "oauth_personal_access_clients" autoincrement is correct.

      Checking the next id sequence for table "object_groups".

  [i] nextval is NULL for table "object_groups", go to next table.

      Checking the next id sequence for table "permissions".

  [i] nextval is NULL for table "permissions", go to next table.

      Checking the next id sequence for table "piggy_bank_events".

  [i] nextval is NULL for table "piggy_bank_events", go to next table.

      Checking the next id sequence for table "piggy_bank_repetitions".

  [i] nextval is NULL for table "piggy_bank_repetitions", go to next table.

      Checking the next id sequence for table "piggy_banks".

  [i] nextval is NULL for table "piggy_banks", go to next table.

      Checking the next id sequence for table "preferences".

  [✓] Table "preferences" autoincrement is correct.

      Checking the next id sequence for table "recurrences".

  [i] nextval is NULL for table "recurrences", go to next table.

      Checking the next id sequence for table "recurrences_meta".

  [i] nextval is NULL for table "recurrences_meta", go to next table.

      Checking the next id sequence for table "recurrences_repetitions".

  [i] nextval is NULL for table "recurrences_repetitions", go to next table.

      Checking the next id sequence for table "recurrences_transactions".

  [i] nextval is NULL for table "recurrences_transactions", go to next table.

      Checking the next id sequence for table "roles".

  [✓] Table "roles" autoincrement is correct.

      Checking the next id sequence for table "rt_meta".

  [i] nextval is NULL for table "rt_meta", go to next table.

      Checking the next id sequence for table "rule_actions".

  [✓] Table "rule_actions" autoincrement is correct.

      Checking the next id sequence for table "rule_groups".

  [✓] Table "rule_groups" autoincrement is correct.

      Checking the next id sequence for table "rule_triggers".

  [✓] Table "rule_triggers" autoincrement is correct.

      Checking the next id sequence for table "rules".

  [✓] Table "rules" autoincrement is correct.

      Checking the next id sequence for table "tag_transaction_journal".

  [✓] Table "tag_transaction_journal" autoincrement is correct.

      Checking the next id sequence for table "tags".

  [✓] Table "tags" autoincrement is correct.

      Checking the next id sequence for table "transaction_currencies".

  [✓] Table "transaction_currencies" autoincrement is correct.

      Checking the next id sequence for table "transaction_groups".

  [✓] Table "transaction_groups" autoincrement is correct.

      Checking the next id sequence for table "transaction_journals".

  [✓] Table "transaction_journals" autoincrement is correct.

      Checking the next id sequence for table "transaction_types".

  [✓] Table "transaction_types" autoincrement is correct.

      Checking the next id sequence for table "transactions".

  [✓] Table "transactions" autoincrement is correct.

      Checking the next id sequence for table "users".

  [✓] Table "users" autoincrement is correct.

      Checking the next id sequence for table "webhook_attempts".

  [i] nextval is NULL for table "webhook_attempts", go to next table.

      Checking the next id sequence for table "webhook_messages".

  [i] nextval is NULL for table "webhook_messages", go to next table.

      Checking the next id sequence for table "webhooks".

  [i] nextval is NULL for table "webhooks", go to next table.

  [i] No decryption required for table "accounts".

  [i] No decryption required for table "attachments".

  [i] No decryption required for table "bills".

  [i] No decryption required for table "budgets".

  [i] No decryption required for table "categories".

  [i] No decryption required for table "piggy_banks".

  [i] No decryption required for table "preferences".

  [i] No decryption required for table "tags".

  [i] No decryption required for table "transaction_journals".

  [i] No decryption required for table "transactions".

  [i] No decryption required for table "journal_links".

      Now executing firefly-iii:transaction-identifiers

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-to-groups

  [i] Database is already migrated.

      Now executing firefly-iii:account-currencies

  [i] This command has already been executed.

      Now executing firefly-iii:transfer-currencies

  [i] This command has already been executed.

      Now executing firefly-iii:other-currencies

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-notes

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-attachments

  [i] This command has already been executed.

      Now executing firefly-iii:bills-to-rules

  [i] This command has already been executed.

      Now executing firefly-iii:bl-currency

  [i] This command has already been executed.

      Now executing firefly-iii:cc-liabilities

  [i] This command has already been executed.

      Now executing firefly-iii:back-to-journals

  [i] This command has already been executed.

      Now executing firefly-iii:rename-account-meta

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-recurrence-meta

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-tag-locations

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-recurrence-type

  [i] This command has already been executed.

      Now executing firefly-iii:upgrade-liabilities

  [i] This command has already been executed.

      Now executing firefly-iii:liabilities-600

  [i] This command has already been executed.

      Now executing firefly-iii:budget-limit-periods

  [i] This command has already been executed.

      Now executing firefly-iii:migrate-rule-actions

  [i] This command has already been executed.

      Now executing firefly-iii:restore-oauth-keys

  [✓] OAuth keys are OK

      Now executing firefly-iii:correct-account-balance

  [!] This command has been disabled.

      Now executing firefly-iii:add-timezones-to-dates

  [✓] Timezone information is present in field "date" of model "AccountBalance".

  [✓] Timezone information is present in field "start_date" of model "AvailableBudget".

  [✓] Timezone information is present in field "end_date" of model "AvailableBudget".

  [✓] Timezone information is present in field "date" of model "Bill".

  [✓] Timezone information is present in field "end_date" of model "Bill".

  [✓] Timezone information is present in field "extension_date" of model "Bill".

  [✓] Timezone information is present in field "start_date" of model "BudgetLimit".

  [✓] Timezone information is present in field "end_date" of model "BudgetLimit".

  [✓] Timezone information is present in field "date" of model "CurrencyExchangeRate".

  [✓] Timezone information is present in field "expires" of model "InvitedUser".

  [✓] Timezone information is present in field "date" of model "PiggyBankEvent".

  [✓] Timezone information is present in field "startdate" of model "PiggyBankRepetition".

  [✓] Timezone information is present in field "targetdate" of model "PiggyBankRepetition".

  [✓] Timezone information is present in field "startdate" of model "PiggyBank".

  [✓] Timezone information is present in field "targetdate" of model "PiggyBank".

  [✓] Timezone information is present in field "first_date" of model "Recurrence".

  [✓] Timezone information is present in field "repeat_until" of model "Recurrence".

  [✓] Timezone information is present in field "latest_date" of model "Recurrence".

  [✓] Timezone information is present in field "date" of model "Tag".

  [✓] Timezone information is present in field "date" of model "TransactionJournal".

      Now executing firefly-iii:create-group-memberships

  [✓] Validated group memberships

      Now executing firefly-iii:upgrade-group-information

      Now executing firefly-iii:upgrade-currency-preferences

  [i] This command has already been executed.

      Now executing firefly-iii:correct-database

      Now executing command "firefly-iii:fix-piggies"

  [✓] All piggy bank events are OK.

      Now executing command "firefly-iii:create-link-types"

  [✓] All link types are OK

      Now executing command "firefly-iii:create-access-tokens"

  [✓] Verified access tokens.

      Now executing command "firefly-iii:remove-bills"

  [✓] All bills and journals are OK

      Now executing command "firefly-iii:fix-amount-pos-neg"

  [✓] All auto budget amounts are positive.

  [✓] All available budget amounts are positive.

  [✓] All bill amounts are positive.

  [✓] All budget limit amounts are positive.

  [✓] All currency exchange rates are positive.

  [✓] All piggy bank repetition amounts are positive.

  [✓] All piggy bank amounts are positive.

  [✓] All recurring transaction amounts are positive.

  [✓] All rule trigger amounts are positive.

      Now executing command "firefly-iii:enable-currencies"

      Now executing command "firefly-iii:fix-transfer-budgets"

  [✓] No invalid budget/journal entries.

      Now executing command "firefly-iii:fix-uneven-amount"

  [✓] No "old style" foreign currency transfers.

  [✓] Database amount integrity is OK

  [✓] Journal currency integrity is OK

      Now executing command "firefly-iii:delete-zero-amount"

  [✓] No zero-amount transaction journals.

      Now executing command "firefly-iii:delete-orphaned-transactions"

  [✓] No orphaned journals.

  [✓] No orphaned transactions.

  [✓] No orphaned accounts.

      Now executing command "firefly-iii:delete-empty-journals"

  [✓] No uneven transaction journals.

  [✓] No empty transaction journals.

      Now executing command "firefly-iii:delete-empty-groups"

  [i] Verified there are no empty groups.

      Now executing command "firefly-iii:fix-account-types"

  [✓] All account types are OK

      Now executing command "firefly-iii:fix-ibans"

  [✓] All IBANs are valid.

      Now executing command "firefly-iii:fix-account-order"

  [✓] All accounts are ordered correctly

      Now executing command "firefly-iii:rename-meta-fields"

  [✓] All meta fields are correct.

      Now executing command "firefly-iii:fix-ob-currencies"

  [✓] There was nothing to fix in the opening balance transactions.

      Now executing command "firefly-iii:fix-long-descriptions"

  [✓] All transaction group and journal title lengths are within bounds.

      Now executing command "firefly-iii:fix-recurring-transactions"

  [✓] All recurring transactions are OK.

      Now executing command "firefly-iii:upgrade-group-information"

      Now executing command "firefly-iii:fix-transaction-types"

  [✓] All transaction journals are of the correct transaction type

      Now executing command "firefly-iii:fix-frontpage-accounts"

  [✓] Account preferences are OK

      Now executing command "firefly-iii:unify-group-accounts"

  [✓] Updated possible inconsistent transaction groups.

      Now executing command "firefly-iii:trigger-credit-recalculation"

      Now executing command "firefly-iii:migrate-preferences"

Migrated 2 preference(s) for user #1 ("[email protected]").

Migrated 1 preference(s) for user #3 ("[email protected]").

  [i] Will run report commands.

      Now executing firefly-iii:add-timezones-to-dates

  [✓] Timezone information is present in field "date" of model "AccountBalance".

  [✓] Timezone information is present in field "start_date" of model "AvailableBudget".

  [✓] Timezone information is present in field "end_date" of model "AvailableBudget".

  [✓] Timezone information is present in field "date" of model "Bill".

  [✓] Timezone information is present in field "end_date" of model "Bill".

  [✓] Timezone information is present in field "extension_date" of model "Bill".

  [✓] Timezone information is present in field "start_date" of model "BudgetLimit".

  [✓] Timezone information is present in field "end_date" of model "BudgetLimit".

  [✓] Timezone information is present in field "date" of model "CurrencyExchangeRate".

  [✓] Timezone information is present in field "expires" of model "InvitedUser".

  [✓] Timezone information is present in field "date" of model "PiggyBankEvent".

  [✓] Timezone information is present in field "startdate" of model "PiggyBankRepetition".

  [✓] Timezone information is present in field "targetdate" of model "PiggyBankRepetition".

  [✓] Timezone information is present in field "startdate" of model "PiggyBank".

  [✓] Timezone information is present in field "targetdate" of model "PiggyBank".

  [✓] Timezone information is present in field "first_date" of model "Recurrence".

  [✓] Timezone information is present in field "repeat_until" of model "Recurrence".

  [✓] Timezone information is present in field "latest_date" of model "Recurrence".

  [✓] Timezone information is present in field "date" of model "Tag".

  [✓] Timezone information is present in field "date" of model "TransactionJournal".

      Now executing firefly-iii:create-group-memberships

  [✓] Validated group memberships

      Now executing firefly-iii:report-empty-objects

  [!] User #3 ([email protected]) has budget #3 ("Main Budget") which has no transaction journals.

  [!] User #3 ([email protected]) has category #54 ("Petrol") which has no transaction journals.

  [!] User #1 ([email protected]) has category #112 ("Emilia toys") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #90 ("Data Import on 2023-07-26 @ 06:02") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #96 ("Data Import on 2023-07-27 @ 22:05") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #130 ("Data Import on 2023-08-05 @ 06:02") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #166 ("Data Import on 2023-08-07 @ 06:02") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #169 ("Tata") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #194 ("Data Import on 2023-08-09 @ 06:00") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #196 ("Data Import on 2023-08-10 @ 06:00") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #301 ("Data Import on 2023-09-10 @ 06:01") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #308 ("Data Import on 2023-09-12 @ 06:05") which has no transaction journals.

  [!] User #1 ([email protected]) has tag #315 ("Data Import on 2023-09-14 @ 06:04") which has no transaction journals.

  [!] User #1 ([email protected]) has account #187 ("eBay O*19-09613-75582") which has no transactions.

  [!] User #1 ([email protected]) has account #175 ("eBay O*21-09685-22730") which has no transactions.

  [!] User #1 ([email protected]) has account #169 ("eBay O*03-09728-77416") which has no transactions.

  [!] User #1 ([email protected]) has account #95 ("eBay O*11-10061-71241") which has no transactions.

  [!] User #1 ([email protected]) has account #108 ("eBay O*05-09979-68652") which has no transactions.

  [!] User #1 ([email protected]) has account #90 ("eBay O*07-10072-48562") which has no transactions.

  [!] User #3 ([email protected]) has account #495 ("MICHAL GAWRONSKI") which has no transactions.

  [!] User #3 ([email protected]) has account #409 ("Nationwide") which has no transactions.

  [!] User #1 ([email protected]) has account #537 ("eBay O*18-10610-94855") which has no transactions.

  [!] User #1 ([email protected]) has account #207 ("eBay O*10-09568-42822") which has no transactions.

  [!] User #1 ([email protected]) has account #34 ("eBay O*27-10194-37550") which has no transactions.

  [!] User #3 ([email protected]) has account #376 ("LIDL BSL-MAYFLOWER") which has no transactions.

  [!] User #1 ([email protected]) has account #475 ("eBay O*02-10497-10558") which has no transactions.

  [!] User #1 ([email protected]) has account #4 ("Cash wallet") which has no transactions.

  [!] User #1 ([email protected]) has account #533 ("eBay O*16-10602-22365") which has no transactions.

  [!] User #1 ([email protected]) has account #177 ("eBay O*10-09689-97151") which has no transactions.

  [!] User #1 ([email protected]) has account #143 ("eBay O*11-09881-12373") which has no transactions.

  [!] User #1 ([email protected]) has account #204 ("eBay O*08-09578-39689") which has no transactions.

  [!] User #1 ([email protected]) has account #536 ("eBay O*12-10609-88497") which has no transactions.

  [!] User #1 ([email protected]) has account #188 ("eBay O*13-09612-38404") which has no transactions.

  [!] User #1 ([email protected]) has account #113 ("eBay O*06-09954-50993") which has no transactions.

  [!] User #1 ([email protected]) has account #178 ("eBay O*16-09687-74643") which has no transactions.

  [!] User #1 ([email protected]) has account #3 ("Santander savings account") which has no transactions.

  [!] User #1 ([email protected]) has account #552 ("TESCO PETROL FILLING STATION FAST") which has no transactions.

  [!] User #1 ([email protected]) has account #209 ("eBay O*19-09558-17145") which has no transactions.

  [!] User #1 ([email protected]) has account #29 ("eBay O*15-10209-38991") which has no transactions.

  [!] User #3 ([email protected]) has account #274 ("LIDL GB BASILDON") which has no transactions.

  [!] User #1 ([email protected]) has account #156 ("eBay O*19-09810-70432") which has no transactions.

  [!] User #1 ([email protected]) has account #198 ("eBay O*18-09587-13621") which has no transactions.

  [!] User #1 ([email protected]) has account #149 ("eBay O*07-09857-68779") which has no transactions.

  [!] User #1 ([email protected]) has account #168 ("eBay O*25-09727-09138") which has no transactions.

  [!] User #1 ([email protected]) has account #476 ("eBay O*09-10492-93002") which has no transactions.

  [!] User #1 ([email protected]) has account #523 ("eBay O*27-10592-80814") which has no transactions.

  [!] User #1 ([email protected]) has account #50 ("eBay O*27-10127-61256") which has no transactions.

  [!] User #3 ([email protected]) has account #279 ("LIDL GB PITSEA") which has no transactions.

  [!] User #1 ([email protected]) has account #452 ("eBay O*15-10446-45966") which has no transactions.

  [!] User #1 ([email protected]) has account #32 ("eBay O*01-10206-66453") which has no transactions.

  [!] User #1 ([email protected]) has account #155 ("eBay O*15-09827-35388") which has no transactions.

  [!] User #1 ([email protected]) has account #43 ("eBay O*14-10156-08574") which has no transactions.

  [!] User #3 ([email protected]) has account #317 ("LIDL BSL-MAYFLOWER RETAIL PARK") which has no transactions.

  [!] User #3 ([email protected]) has account #313 ("LIDL GB HADLEIGH") which has no transactions.

  [!] User #1 ([email protected]) has account #180 ("eBay O*22-09686-62772") which has no transactions.

  [!] User #1 ([email protected]) has account #460 ("eBay O*02-10469-75090") which has no transactions.

  [!] User #1 ([email protected]) has account #118 ("eBay O*26-09932-12587") which has no transactions.

  [!] User #1 ([email protected]) has account #478 ("EBAY COMMERCE UK LTD") which has no transactions.

  [!] User #1 ([email protected]) has account #508 ("eBay O*06-10560-93597") which has no transactions.

  [!] User #1 ([email protected]) has account #224 ("TESCO PAY AT PUMP 3987") which has no transactions.

  [!] User #1 ([email protected]) has account #144 ("eBay O*27-09874-47144") which has no transactions.

  [!] User #1 ([email protected]) has account #170 ("eBay O*16-09723-34321") which has no transactions.

  [!] User #1 ([email protected]) has account #135 ("eBay O*20-09895-13096") which has no transactions.

  [!] User #1 ([email protected]) has account #160 ("eBay O*16-09801-19436") which has no transactions.

  [!] User #1 ([email protected]) has account #534 ("eBay O*19-10601-32650") which has no transactions.

  [!] User #1 ([email protected]) has account #136 ("eBay O*01-09904-60233") which has no transactions.

  [!] User #1 ([email protected]) has account #152 ("eBay O*20-09848-49661") which has no transactions.

  [!] User #1 ([email protected]) has account #202 ("eBay O*22-09577-89906") which has no transactions.

  [!] User #1 ([email protected]) has account #56 ("eBay O*09-10114-06937") which has no transactions.

  [!] User #1 ([email protected]) has account #23 ("eBay O*04-10230-05626") which has no transactions.

  [!] User #1 ([email protected]) has account #509 ("eBay O*23-10551-00130") which has no transactions.

  [!] User #1 ([email protected]) has account #179 ("eBay O*16-09687-74644") which has no transactions.

  [!] User #1 ([email protected]) has account #235 ("Cash account") which has no transactions.

  [!] User #1 ([email protected]) has account #201 ("eBay O*21-09578-31680") which has no transactions.

  [!] User #1 ([email protected]) has account #93 ("eBay O*07-10067-81189") which has no transactions.

  [!] User #3 ([email protected]) has account #8 ("Nationwide savings account") which has no transactions.

  [!] User #1 ([email protected]) has account #120 ("eBay O*19-09930-51416") which has no transactions.

  [!] User #1 ([email protected]) has account #126 ("eBay O*08-09921-41525") which has no transactions.

  [!] User #1 ([email protected]) has account #48 ("eBay O*21-10141-36515") which has no transactions.

  [!] User #1 ([email protected]) has account #176 ("eBay O*06-09692-67443") which has no transactions.

  [!] User #1 ([email protected]) has account #28 ("eBay O*20-10210-16165") which has no transactions.

  [!] User #1 ([email protected]) has account #146 ("eBay O*11-09860-40839") which has no transactions.

  [!] User #1 ([email protected]) has account #138 ("eBay O*18-09889-22298") which has no transactions.

  [!] User #1 ([email protected]) has account #94 ("eBay O*22-10054-78176") which has no transactions.

  [!] User #1 ([email protected]) has account #157 ("eBay O*19-09808-02180") which has no transactions.

  [!] User #1 ([email protected]) has account #27 ("eBay O*10-10214-64208") which has no transactions.

  [!] User #1 ([email protected]) has account #195 ("eBay O*26-09594-98159") which has no transactions.

  [!] User #1 ([email protected]) has account #260 ("TESCO PETROL FILLING STATIONS FAST") which has no transactions.

  [!] User #1 ([email protected]) has account #89 ("eBay O*13-10075-08861") which has no transactions.

  [!] User #1 ([email protected]) has account #47 ("eBay O*07-10152-99370") which has no transactions.

  [!] User #1 ([email protected]) has account #132 ("eBay O*12-09912-28654") which has no transactions.

  [!] User #1 ([email protected]) has account #451 ("eBay O*01-10454-17031") which has no transactions.

  [!] User #1 ([email protected]) has account #206 ("eBay O*25-09568-77278") which has no transactions.

  [!] User #1 ([email protected]) has account #125 ("eBay O*19-09918-32012") which has no transactions.

  [!] User #1 ([email protected]) has account #530 ("eBay O*12-10604-08731") which has no transactions.

  [!] User #1 ([email protected]) has account #139 ("eBay O*23-09882-52135") which has no transactions.

  [!] User #1 ([email protected]) has account #33 ("eBay O*04-10204-52927") which has no transactions.

  [!] User #1 ([email protected]) has account #49 ("eBay O*01-10149-68619") which has no transactions.

  [!] User #1 ([email protected]) has account #532 ("eBay O*15-10603-68728") which has no transactions.

  [!] User #1 ([email protected]) has account #182 ("eBay O*23-09627-85792") which has no transactions.

  [!] User #1 ([email protected]) has account #479 ("eBay O*26-10484-92502") which has no transactions.

  [!] User #1 ([email protected]) has account #477 ("eBay O*21-10486-16419") which has no transactions.

  [!] User #1 ([email protected]) has account #44 ("eBay O*07-10156-99542") which has no transactions.

  [!] User #1 ([email protected]) has account #194 ("eBay O*19-09601-12735") which has no transactions.

  [!] User #1 ([email protected]) has account #107 ("eBay O*08-09980-59171") which has no transactions.

  [!] User #1 ([email protected]) has account #393 ("EBAY COMMERCE UK LTD") which has no transactions.

  [!] User #1 ([email protected]) has account #137 ("eBay O*27-09893-35950") which has no transactions.

  [!] User #1 ([email protected]) has account #88 ("eBay O*22-10077-22748") which has no transactions.

  [!] User #1 ([email protected]) has account #192 ("eBay O*16-09607-90990") which has no transactions.

  [!] User #1 ([email protected]) has account #147 ("eBay O*23-09854-40821") which has no transactions.

  [!] User #1 ([email protected]) has account #531 ("eBay O*10-10606-63981") which has no transactions.

  [!] User #1 ([email protected]) has account #87 ("eBay O*02-10087-10137") which has no transactions.

  [!] User #1 ([email protected]) has account #205 ("eBay O*02-09577-88967") which has no transactions.

  [!] User #3 ([email protected]) has account #9 ("Cash wallet") which has no transactions.

  [!] User #3 ([email protected]) has account #335 ("Cash account") which has no transactions.

  [!] User #1 ([email protected]) has account #117 ("eBay O*18-09937-95114") which has no transactions.

  [!] User #1 ([email protected]) has account #186 ("eBay O*17-09614-97048") which has no transactions.

  [!] User #1 ([email protected]) has account #200 ("eBay O*27-09579-28401") which has no transactions.

  [!] User #1 ([email protected]) has account #184 ("eBay O*13-09620-22909") which has no transactions.

  [!] User #1 ([email protected]) has account #134 ("eBay O*09-09907-19902") which has no transactions.

  [!] User #1 ([email protected]) has account #484 ("eBay O*06-10508-12435") which has no transactions.

  [!] User #1 ([email protected]) has account #196 ("eBay O*14-09592-24168") which has no transactions.

      Now executing firefly-iii:report-sum

  [x]  Error: Transactions for user #3 ([email protected]) have an invalid sum ("").

  [x]  Error: Transactions for user #1 ([email protected]) have an invalid sum ("").

      Now executing firefly-iii:upgrade-group-information

  [i] Encryption keys exist already.

  [i] Updated version.

  [✓] No security alerts for version 6.1.25

              ______ _           __ _            _____ _____ _____  

             |  ____(_)         / _| |          |_   _|_   _|_   _| 

             | |__   _ _ __ ___| |_| |_   _       | |   | |   | |   

             |  __| | | '__/ _ \  _| | | | |      | |   | |   | |   

             | |    | | | |  __/ | | | |_| |     _| |_ _| |_ _| |_  

             |_|    |_|_|  \___|_| |_|\__, |    |_____|_____|_____| 

                                       __/ |                        

                                      |___/                         

+------------------------------------------------------------------------------+

|                                                                              |

| Thank you for installing Firefly III, v6.1.25!                               |

| This version of Firefly III requires PHP8.3.                                 |

|                                                                              |

+------------------------------------------------------------------------------+

  [!] You can safely ignore the error about the 'fully qualified domain name'.

AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.14. Set the 'ServerName' directive globally to suppress this message

AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 172.17.0.14. Set the 'ServerName' directive globally to suppress this message

[Sun Jan 05 11:32:46.777084 2025] [mpm_prefork:notice] [pid 1:tid 1] AH00163: Apache/2.4.62 (Debian) configured -- resuming normal operations

[Sun Jan 05 11:32:46.777158 2025] [core:notice] [pid 1:tid 1] AH00094: Command line: 'apache2 -D FOREGROUND'

127.0.0.1 - - [05/Jan/2025:11:32:50 +0000] "GET /health HTTP/1.1" 200 1741 "-" "User-Agent: Firefly III Health Checker/2.3"

127.0.0.1 - - [05/Jan/2025:11:33:51 +0000] "GET /health HTTP/1.1" 200 1741 "-" "User-Agent: Firefly III Health Checker/2.3"

0 replies

Dinth · 2025-01-05T11:38:37Z

Dinth
Jan 5, 2025
Author

0 replies

JC5 · 2025-01-08T10:18:34Z

JC5
Jan 8, 2025
Maintainer

Mmm, it's a little hard for me to diagnose this. I see some errors but it's the first time I've encountered this after an upgrade.

2 replies

Dinth Jan 8, 2025
Author

is there anything i can do to help troubleshooting this? I mean i could even send the database privately to you, i am really desperate to get my data back :(

JC5 Jan 10, 2025
Maintainer

I think the database is fine, but I notced this line:

 Insufficient privilege: 7 ERROR:  permission denied for schema public at character 14

Could this be a permissions issue?

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Firefly III

[Support] Corrupted database after updates? #9625

{{title}}

{{editor}}'s edit

{{editor}}'s edit

Replies: 3 comments 2 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

Select a reply

Firefly III

[Support] Corrupted database after updates? #9625

Dinth Jan 5, 2025

Replies: 3 comments · 2 replies

Dinth Jan 5, 2025 Author

Dinth Jan 5, 2025 Author

JC5 Jan 8, 2025 Maintainer

Dinth Jan 8, 2025 Author

JC5 Jan 10, 2025 Maintainer

Dinth
Jan 5, 2025

Replies: 3 comments 2 replies

Dinth
Jan 5, 2025
Author

Dinth
Jan 5, 2025
Author

JC5
Jan 8, 2025
Maintainer

Dinth Jan 8, 2025
Author

JC5 Jan 10, 2025
Maintainer