[6.2.2] upgrade errors

[dudu7731]

Support guidelines

• I've read the support guidelines

I've found a bug and checked that ...

• ... the documentation does not mention anything about my problem
• ... there are no open or closed issues that are related to my problem
• ... it's definitely a Firefly III issue, not me

Description

Hello,

I have a bunch of errors when migrating from 6.1.25 to 6.2.2 :

== php artisan migrate --seed


                                                                            APPLICATION IN PRODUCTION.


 ┌ Are you sure you want to run this command? ──────────────────┐
 │ Yes                                                          │
 └──────────────────────────────────────────────────────────────┘

   INFO  Running migrations.

  2024_11_30_075826_multi_piggy ...................................................................................................... 997.81ms FAIL
[2025-02-03 14:46:14] production.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`)","time":"Mon, 03 Feb 2025 14:46:14 +0100","file":"\/var\/www\/prod\/firefly\/v6.2.2\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":825,"code":"42S21","version":"6.2.2","url":"http:\/\/127.0.0.1","userAgent":"Symfony","json":true,"method":"GET","post":""}
[2025-02-03 14:46:15] production.ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`) at /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#2 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\\Database\\Connection->statement()
#3 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#4 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()
#5 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->table()
#6 /var/www/prod/firefly/v6.2.2/database/migrations/2024_11_30_075826_multi_piggy.php(51): Illuminate\\Support\\Facades\\Facade::__callStatic()
#7 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(484): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#8 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#9 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runMigration():405}()
#10 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#11 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runUp():221}()
#12 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(764): Illuminate\\Console\\View\\Components\\Task->render()
#13 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->write()
#14 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(188): Illuminate\\Database\\Migrations\\Migrator->runUp()
#15 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(131): Illuminate\\Database\\Migrations\\Migrator->runPending()
#16 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\\Database\\Migrations\\Migrator->run()
#17 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(624): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():110}()
#18 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#19 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#20 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#21 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#22 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#23 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#24 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#25 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#26 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#27 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#28 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()
#29 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#30 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#31 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#32 /var/www/prod/firefly/v6.2.2/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#33 {main}

[previous exception] [object] (PDOException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' at /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571)
[stacktrace]
#0 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->{closure:Illuminate\\Database\\Connection::statement():560}()
#2 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#4 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\\Database\\Connection->statement()
#5 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#6 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()
#7 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->table()
#8 /var/www/prod/firefly/v6.2.2/database/migrations/2024_11_30_075826_multi_piggy.php(51): Illuminate\\Support\\Facades\\Facade::__callStatic()
#9 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(484): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#10 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#11 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runMigration():405}()
#12 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#13 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runUp():221}()
#14 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(764): Illuminate\\Console\\View\\Components\\Task->render()
#15 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->write()
#16 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(188): Illuminate\\Database\\Migrations\\Migrator->runUp()
#17 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(131): Illuminate\\Database\\Migrations\\Migrator->runPending()
#18 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\\Database\\Migrations\\Migrator->run()
#19 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(624): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():110}()
#20 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#21 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#22 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#23 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#24 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#25 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#26 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#27 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#28 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#29 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#30 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()
#31 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#32 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#33 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#34 /var/www/prod/firefly/v6.2.2/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#35 {main}
"}

   Illuminate\Database\QueryException

  SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`)

  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/2024_11_30_075826_multi_piggy.php:51
      Illuminate\Support\Facades\Facade::__callStatic()
      +25 vendor frames

  36  artisan:35
      Illuminate\Foundation\Console\Kernel::handle()

== php artisan firefly-iii:decrypt-all
[2025-02-03 14:46:16] production.ERROR: Exception is: {"class":"Symfony\\Component\\Console\\Exception\\CommandNotFoundException","errorMessage":"Command \"firefly-iii:decrypt-all\" is not defined.\n\nDid you mean one of these?\n    firefly-iii:apply-rules\n    firefly-iii:correct-database\n    firefly-iii:create-database\n    firefly-iii:cron\n    firefly-iii:export-data\n    firefly-iii:force-decimal-size\n    firefly-iii:force-migrations\n    firefly-iii:instructions\n    firefly-iii:laravel-passport-keys\n    firefly-iii:output-version\n    firefly-iii:report-integrity\n    firefly-iii:scan-attachments\n    firefly-iii:set-latest-version\n    firefly-iii:upgrade-database\n    firefly-iii:verify-security-alerts\n    upgrade:480-decrypt-all","time":"Mon, 03 Feb 2025 14:46:16 +0100","file":"\/var\/www\/prod\/firefly\/v6.2.2\/vendor\/symfony\/console\/Application.php","line":726,"code":0,"version":"6.2.2","url":"http:\/\/127.0.0.1","userAgent":"Symfony","json":true,"method":"GET","post":""}

== artisan cache:clear

   INFO  Application cache cleared successfully.

== php artisan view:clear

   INFO  Compiled views cleared successfully.

== php artisan firefly-iii:upgrade-database

   INFO  Running migrations.

  2024_11_30_075826_multi_piggy ............................................................................................................ 1s FAIL
[2025-02-03 14:46:20] production.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`)","time":"Mon, 03 Feb 2025 14:46:20 +0100","file":"\/var\/www\/prod\/firefly\/v6.2.2\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":825,"code":"42S21","version":"6.2.2","url":"http:\/\/127.0.0.1","userAgent":"Symfony","json":true,"method":"GET","post":""}
[2025-02-03 14:46:21] production.ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`) at /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#1 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#2 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\\Database\\Connection->statement()
#3 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#4 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()
#5 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->table()
#6 /var/www/prod/firefly/v6.2.2/database/migrations/2024_11_30_075826_multi_piggy.php(51): Illuminate\\Support\\Facades\\Facade::__callStatic()
#7 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(484): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#8 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#9 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runMigration():405}()
#10 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#11 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runUp():221}()
#12 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(764): Illuminate\\Console\\View\\Components\\Task->render()
#13 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->write()
#14 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(188): Illuminate\\Database\\Migrations\\Migrator->runUp()
#15 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(131): Illuminate\\Database\\Migrations\\Migrator->runPending()
#16 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\\Database\\Migrations\\Migrator->run()
#17 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(624): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():110}()
#18 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#19 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#20 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#21 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#22 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#23 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#24 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#25 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#26 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#27 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#28 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\\Console\\Command->run()
#29 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\\Console\\Command->runCommand()
#30 /var/www/prod/firefly/v6.2.2/app/Console/Commands/Upgrade/UpgradesDatabase.php(89): Illuminate\\Console\\Command->call()
#31 /var/www/prod/firefly/v6.2.2/app/Console/Commands/Upgrade/UpgradesDatabase.php(44): FireflyIII\\Console\\Commands\\Upgrade\\UpgradesDatabase->callInitialCommands()
#32 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradesDatabase->handle()
#33 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#34 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#35 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#36 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#37 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#38 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#39 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#40 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()
#41 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#42 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#43 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#44 /var/www/prod/firefly/v6.2.2/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#45 {main}

[previous exception] [object] (PDOException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' at /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571)
[stacktrace]
#0 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\\Database\\Connection->{closure:Illuminate\\Database\\Connection::statement():560}()
#2 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\\Database\\Connection->run()
#4 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\\Database\\Connection->statement()
#5 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\\Database\\Schema\\Blueprint->build()
#6 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(406): Illuminate\\Database\\Schema\\Builder->build()
#7 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\\Database\\Schema\\Builder->table()
#8 /var/www/prod/firefly/v6.2.2/database/migrations/2024_11_30_075826_multi_piggy.php(51): Illuminate\\Support\\Facades\\Facade::__callStatic()
#9 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(484): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#10 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(409): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#11 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(418): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runMigration():405}()
#12 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#13 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\\Database\\Migrations\\Migrator->{closure:Illuminate\\Database\\Migrations\\Migrator::runUp():221}()
#14 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(764): Illuminate\\Console\\View\\Components\\Task->render()
#15 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(221): Illuminate\\Database\\Migrations\\Migrator->write()
#16 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(188): Illuminate\\Database\\Migrations\\Migrator->runUp()
#17 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(131): Illuminate\\Database\\Migrations\\Migrator->runPending()
#18 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(117): Illuminate\\Database\\Migrations\\Migrator->run()
#19 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(624): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->{closure:Illuminate\\Database\\Console\\Migrations\\MigrateCommand::runMigrations():110}()
#20 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(110): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#21 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(89): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->runMigrations()
#22 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#23 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#24 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#25 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#26 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#27 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#28 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#29 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#30 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\\Console\\Command->run()
#31 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\\Console\\Command->runCommand()
#32 /var/www/prod/firefly/v6.2.2/app/Console/Commands/Upgrade/UpgradesDatabase.php(89): Illuminate\\Console\\Command->call()
#33 /var/www/prod/firefly/v6.2.2/app/Console/Commands/Upgrade/UpgradesDatabase.php(44): FireflyIII\\Console\\Commands\\Upgrade\\UpgradesDatabase->callInitialCommands()
#34 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradesDatabase->handle()
#35 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\\Container\\BoundMethod::{closure:Illuminate\\Container\\BoundMethod::call():35}()
#36 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\\Container\\Util::unwrapIfClosure()
#37 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#38 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\\Container\\BoundMethod::call()
#39 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\\Container\\Container->call()
#40 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#41 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\\Component\\Console\\Command\\Command->run()
#42 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(1094): Illuminate\\Console\\Command->run()
#43 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(342): Symfony\\Component\\Console\\Application->doRunCommand()
#44 /var/www/prod/firefly/v6.2.2/vendor/symfony/console/Application.php(193): Symfony\\Component\\Console\\Application->doRun()
#45 /var/www/prod/firefly/v6.2.2/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\\Component\\Console\\Application->run()
#46 /var/www/prod/firefly/v6.2.2/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#47 {main}
"}

   Illuminate\Database\QueryException

  SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'transaction_currency_id' (Connection: mysql, SQL: alter table `piggy_banks` add `transaction_currency_id` int unsigned null after `account_id`)

  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/2024_11_30_075826_multi_piggy.php:51
      Illuminate\Support\Facades\Facade::__callStatic()
      +23 vendor frames

  34  app/Console/Commands/Upgrade/UpgradesDatabase.php:89
      Illuminate\Console\Command::call()

== artisan firefly-iii:laravel-passport-keys
  [i] Encryption keys exist already.
`

and after upgrade this error occurs
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'source.native_amount' in 'field list' (Connection: mysql, SQL: select transaction_groups.idastransaction_group_id, transaction_groups.user_idasuser_id, transaction_groups.user_group_idasuser_group_id, transaction_groups.created_atascreated_at, transaction_groups.updated_atasupdated_at, transaction_groups.titleastransaction_group_title, transaction_groups.created_atasgroup_created_at, transaction_groups.updated_atasgroup_updated_at, transaction_journals.idastransaction_journal_id, transaction_journals.transaction_type_id, transaction_journals.description, transaction_journals.date, transaction_journals.date_tz, transaction_journals.order, transaction_types.typeastransaction_type_type, source.idassource_transaction_id, source.account_idassource_account_id, source.reconciled, source.amountasamount, source.native_amountasnative_amount, source.transaction_currency_idascurrency_id, currency.codeascurrency_code, currency.nameascurrency_name, currency.symbolascurrency_symbol, currency.decimal_placesascurrency_decimal_places, source.foreign_amountasforeign_amount, source.native_foreign_amountasnative_foreign_amount, source.foreign_currency_idasforeign_currency_id, foreign_currency.codeasforeign_currency_code, foreign_currency.nameasforeign_currency_name, foreign_currency.symbolasforeign_currency_symbol, foreign_currency.decimal_placesasforeign_currency_decimal_places, destination.account_idasdestination_account_id, source_account.nameassource_account_name, source_account.ibanassource_account_iban, source_account_type.typeassource_account_type, dest_account.nameasdestination_account_name, dest_account.ibanasdestination_account_iban, dest_account_type.typeasdestination_account_typefromtransaction_journalsleft jointransaction_groupsontransaction_journals.transaction_group_id=transaction_groups.idleft jointransactionsassourceonsource.transaction_journal_id=transaction_journals.idandsource.amount< 0 left jointransactionsasdestinationondestination.transaction_journal_id=transaction_journals.idanddestination.amount> 0 left jointransaction_typesontransaction_types.id=transaction_journals.transaction_type_idleft jointransaction_currenciesascurrencyoncurrency.id=source.transaction_currency_idleft jointransaction_currenciesasforeign_currencyonforeign_currency.id=source.foreign_currency_idleft joinaccountsassource_accountonsource_account.id=source.account_idleft joinaccount_typesassource_account_typeonsource_account_type.id=source_account.account_type_idleft joinaccountsasdest_accountondest_account.id=destination.account_idleft joinaccount_typesasdest_account_typeondest_account_type.id=dest_account.account_type_idwheretransaction_journals.user_id= 1 andtransaction_journals.user_idis not null andtransaction_groups.deleted_atis null andtransaction_journals.deleted_atis null andsource.deleted_atis null andtransaction_groups.idis not null anddestination.deleted_at is null and (source.account_idin (97) ordestination.account_idin (97)) andtransaction_journals.date>= 2025-02-01 00:00:00 andtransaction_journals.date<= 2025-02-28 23:59:59 andtransaction_journals.deleted_atis null order bytransaction_journals.datedesc,transaction_journals.orderasc,transaction_journals.iddesc,transaction_journals.descriptiondesc,source.amountdesc)

Debug information

Debug information generated at 2025-02-03 16:26:20 for Firefly III version v6.2.2.

System information
Item	Value
Firefly III	v6.2.2 / #25 (expects #25)
PHP version	8.4.3 (64bits) / fpm-fcgi / Linux x86_64
BCscale	12
Error reporting	Display: Off, reporting: ALL errors
Max upload	2097152 (2 MB)
Database drivers	*mysql*,

Firefly III information
Item	Value
Timezone	Europe/Paris + Europe/Paris
App environment	production, debug: false
Layout	v1
Logging	info, stack / (empty)
Cache driver, session driver	redis, redis
Default language and locale	en_US + equal
Trusted proxies	**
Login provider & user guard	eloquent / web
Login headers	N/A + N/A
Stateful domains
Last cron job	2025-01-31 08:11:50 (3 days ago)
Mailer	smtp
Exchange rates	Disabled, downloads disabled
RB-column	Disabled

User-specific information
Item	Value
User	#1 of 1
User flags	🔧 📑 📧
Native currency	EUR
Convert to native currency?	Disabled
Session start	2025-02-01 00:00:00
Session end	2025-02-28 23:59:59
View range	1M
User language	fr_FR
User locale	fr_FR
Locale(s) supported	fr_FR.utf8: ✅ fr_FR.UTF-8: ✅
User agent	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36 Edg/132.0.0.0

Expected behaviour

No response

Steps to reproduce

No response

Additional info

php -v
PHP 8.4.3 (cli) (built: Jan 19 2025 18:22:53) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.4.3, Copyright (c) Zend Technologies
with Zend OPcache v8.4.3, Copyright (c), by Zend Technologies

i rolled back my VM and DB twice and redone upgrade procedure to check if i made a mistake, but sql srcipts failed all the time

[JC5]

Hey, thanks for opening an issue!

It looks like you ran the upgrade commands but it failed to store the entries in the migrations table. There's not really something I can do about that. All I can try is add more try/catch blocks around the queries, but that doesn't solve the original issue.

I'll pick this up for 6.2.3, and I hope it leaves your database in a more usable state :)

Cheers, James

[dudu7731]

Ok i roll back to 6.1.25 and wait for further version

[dudu7731]

don't mind this issue, my sql dumps lacks of drop statements,

[JC5]

Ah, so it works as expected now? Thanks for the feedback! I appreciate it :)

[dudu7731]

yes, after droping DB and reimported my sql dump, the migration process works with no error on my three firefly instances.

after upgrade, I did a few steps to test duplicated imports meanwhile :

• reimported a 6.1.25 dump from 1 week ago,
• upgraded to 6.2.2
• run Gocardless imports with
  "date_range": "partial",
  "date_range_number": 7,
  "date_range_unit": "d",
  "date_not_before": "2025-01-28",

I only had duplicate with 2025-01-27 transactions date (deleted by hand), i'll check after my automatic import today if there is duplicates.