Migration Error when upgrading from `6.0.26` to `6.1.13` #8762

cachho · 2024-04-07T15:34:14Z

cachho
Apr 7, 2024

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

Had trouble upgrading from 6.0.26 before, tried again with the latest version, still getting errors. Deleting the database and starting over really isn't an option in my case. But I have a couple issues with 6.0.26 and before I report them, I want to make sure they aren't fixed in the latest version. Thanks for your help.

Debug information

Can't get to the debug page.

Expected behaviour

No response

Steps to reproduce

php artisan migrate --seed
php artisan firefly-iii:decrypt-all
php artisan cache:clear
php artisan firefly-iii:upgrade-database <--------- error here
php artisan firefly-iii:laravel-passport-keys
php artisan cache:clear

Additional info

root@app:/var/www/html# php artisan firefly:upgrade-database

   INFO  Nothing to migrate.

   INFO  Seeding database.

  Database\Seeders\AccountTypeSeeder ................................. RUNNING
  Database\Seeders\AccountTypeSeeder .............................. 21 ms DONE

  Database\Seeders\TransactionCurrencySeeder ......................... RUNNING
  Database\Seeders\TransactionCurrencySeeder ...................... 20 ms DONE

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

  Database\Seeders\PermissionSeeder .................................. RUNNING
  Database\Seeders\PermissionSeeder ................................ 4 ms DONE

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

  Database\Seeders\ConfigSeeder ...................................... RUNNING
  Database\Seeders\ConfigSeeder .................................... 4 ms DONE

  Database\Seeders\UserRoleSeeder .................................... RUNNING
  Database\Seeders\UserRoleSeeder ................................. 11 ms DONE

  Database\Seeders\ExchangeRateSeeder ................................ RUNNING
  Database\Seeders\ExchangeRateSeeder ............................. 44 ms DONE

  [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] Expression engine is not enabled. Nothing to do.
      Now executing firefly-iii:restore-oauth-keys
  [✓] OAuth keys are OK
      Now executing firefly-iii:create-group-memberships
  [✓] Validated group memberships
      Now executing firefly-iii:upgrade-group-information
      Now executing firefly-iii:upgrade-currency-preferences
[2024-04-07 17:26:49] local.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.transaction_currency_user_group' doesn't exist in engine (Connection: mysql, SQL: select * from `transaction_currency_user_group` where `transaction_currency_user_group`.`user_group_id` = 1)","time":"Sun, 07 Apr 2024 17:26:49 +0200","file":"\/var\/www\/html\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php","line":813,"code":"42S02","version":"6.1.13","url":"http:\/\/localhost","userAgent":"Symfony","json":true,"method":"GET","post":""}
[2024-04-07 17:26:49] local.WARNING: [Bcc] Could not email or log the error. Please validate your email settings, use the .env.example file as a guide.
[2024-04-07 17:26:49] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.transaction_currency_user_group' doesn't exist in engine (Connection: mysql, SQL: select * from `transaction_currency_user_group` where `transaction_currency_user_group`.`user_group_id` = 1) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.transaction_currency_user_group' doesn't exist in engine (Connection: mysql, SQL: select * from `transaction_currency_user_group` where `transaction_currency_user_group`.`user_group_id` = 1) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:813)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): 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/Query/Builder.php(2899): Illuminate\\Database\\Connection->select()
#3 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2884): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3468): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2883): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Concerns/InteractsWithPivotTable.php(500): Illuminate\\Database\\Query\\Builder->get()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Concerns/InteractsWithPivotTable.php(93): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->getCurrentlyAttachedPivots()
#8 /var/www/html/app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php(105): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->sync()
#9 /var/www/html/app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php(83): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeCurrencyPreferences->upgradeGroupPreferences()
#10 /var/www/html/app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php(58): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeCurrencyPreferences->runUpgrade()
#11 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeCurrencyPreferences->handle()
#12 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(212): Illuminate\\Container\\Container->call()
#17 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\\Component\\Console\\Command\\Command->run()
#19 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\\Console\\Command->runCommand()
#21 /var/www/html/app/Console/Commands/Upgrade/UpgradeDatabase.php(79): Illuminate\\Console\\Command->call()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->handle()
#23 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(212): Illuminate\\Container\\Container->call()
#28 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\\Component\\Console\\Command\\Command->run()
#30 /var/www/html/vendor/symfony/console/Application.php(1049): Illuminate\\Console\\Command->run()
#31 /var/www/html/vendor/symfony/console/Application.php(318): Symfony\\Component\\Console\\Application->doRunCommand()
#32 /var/www/html/vendor/symfony/console/Application.php(169): Symfony\\Component\\Console\\Application->doRun()
#33 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(196): Symfony\\Component\\Console\\Application->run()
#34 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#35 {main}

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.transaction_currency_user_group' doesn't exist in engine at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407)
[stacktrace]
#0 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(407): PDO->prepare()
#1 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(800): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php(767): 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/Query/Builder.php(2899): Illuminate\\Database\\Connection->select()
#5 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2884): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(3468): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2883): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Concerns/InteractsWithPivotTable.php(500): Illuminate\\Database\\Query\\Builder->get()
#9 /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Concerns/InteractsWithPivotTable.php(93): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->getCurrentlyAttachedPivots()
#10 /var/www/html/app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php(105): Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany->sync()
#11 /var/www/html/app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php(83): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeCurrencyPreferences->upgradeGroupPreferences()
#12 /var/www/html/app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php(58): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeCurrencyPreferences->runUpgrade()
#13 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeCurrencyPreferences->handle()
#14 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#15 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#16 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#17 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#18 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(212): Illuminate\\Container\\Container->call()
#19 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#20 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\\Component\\Console\\Command\\Command->run()
#21 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(67): Illuminate\\Console\\Command->run()
#22 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(28): Illuminate\\Console\\Command->runCommand()
#23 /var/www/html/app/Console/Commands/Upgrade/UpgradeDatabase.php(79): Illuminate\\Console\\Command->call()
#24 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->handle()
#25 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#26 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#27 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#28 /var/www/html/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#29 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(212): Illuminate\\Container\\Container->call()
#30 /var/www/html/vendor/symfony/console/Command/Command.php(279): Illuminate\\Console\\Command->execute()
#31 /var/www/html/vendor/laravel/framework/src/Illuminate/Console/Command.php(181): Symfony\\Component\\Console\\Command\\Command->run()
#32 /var/www/html/vendor/symfony/console/Application.php(1049): Illuminate\\Console\\Command->run()
#33 /var/www/html/vendor/symfony/console/Application.php(318): Symfony\\Component\\Console\\Application->doRunCommand()
#34 /var/www/html/vendor/symfony/console/Application.php(169): Symfony\\Component\\Console\\Application->doRun()
#35 /var/www/html/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(196): Symfony\\Component\\Console\\Application->run()
#36 /var/www/html/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#37 {main}
"}

   Illuminate\Database\QueryException

  SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly.transaction_currency_user_group' doesn't exist in engine (Connection: mysql, SQL: select * from `transaction_currency_user_group` where `transaction_currency_user_group`.`user_group_id` = 1)

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:813
    809▕                     $this->getName(), $query, $this->prepareBindings($bindings), $e
    810▕                 );
    811▕             }
    812▕
  ➜ 813▕             throw new QueryException(
    814▕                 $this->getName(), $query, $this->prepareBindings($bindings), $e
    815▕             );
    816▕         }
    817▕     }

  i   A table was not found: You might have forgotten to run your database migrations.
      https://laravel.com/docs/master/migrations#running-migrations

      +11 vendor frames

  12  app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php:105
      Illuminate\Database\Eloquent\Relations\BelongsToMany::sync()

  13  app/Console/Commands/Upgrade/UpgradeCurrencyPreferences.php:83
      FireflyIII\Console\Commands\Upgrade\UpgradeCurrencyPreferences::upgradeGroupPreferences()

Answered by cachho

Apr 10, 2024

I figured it out!

Created a clean copy with a separate docker volume and exported the creation schema of the table that's missing according to the error message with mysqldump -u firefly -p --skip-column-statistics firefly transaction_currency_user_group > transaction_currency_user_group.sql. For this I first had to use apt-get update && apt-get install mysql-client, because mysqldump was not found.
Use docker cp to copy the .sql file to the bugged container.
Tried to import it with mariadb -u firefly -p firefly < /db_import/transaction_currency_user_group.sql but of course that wouldn't work due to the error ERROR 1005 (HY000) at line 25: Can't create table `firefly`.`transaction_curren…

View full answer

JC5 · 2024-04-07T15:42:33Z

JC5
Apr 7, 2024
Maintainer

I’m surprised that it says that there are no migrations to be performed, and yet it crashes because a table can’t be found. Are you aware of any previous errrors?

12 replies

cachho Apr 8, 2024
Author

Thanks for your quick answers. I'm attempting the import/export route.

An import/export should work, although you may lose some meta data. If you make sure you recreate your asset accounts first, it should work as expected.

Will it automatically create expense and revenue accounts? I only created asset accounts with the same names.

I'm asking because I tried and it mysteriously failed, but I don't see an error in the logs for the importer. It really didn't import anything in FF3. (I can guess you probably would rather have this in the importer repo).

Web error:

Browser console error:

Importer Console errror:

[2024-04-09 00:25:13] local.INFO: Done converting 1038 line(s) into transactions.  
[2024-04-09 00:25:13] local.DEBUG: Conversion routine "file" was started successfully.  
[2024-04-09 00:25:13] local.DEBUG: Conversion routine "file" yielded 1038 transaction(s).  
[2024-04-09 00:25:13] local.DEBUG: Transactions are stored on disk "jobs" in file "conversion-6F3ahlO6y5um.json"  
[2024-04-09 00:25:13] local.DEBUG: Now in setConversionStatus(conv_done)  
[2024-04-09 00:25:13] local.DEBUG: Found "conversion-6F3ahlO6y5um" in the session  
[2024-04-09 00:25:13] local.DEBUG: Now in startOrFindConversion(conversion-6F3ahlO6y5um)  
[2024-04-09 00:25:13] local.DEBUG: Conversion status is "conv_running"  
[2024-04-09 00:25:13] local.DEBUG: Now in storeConversionStatus(conversion-6F3ahlO6y5um): conv_done  
[2024-04-09 00:25:13] local.DEBUG: Messages: 0, warnings: 0, errors: 0  
[2024-04-09 00:25:13] local.DEBUG: Set conversion as complete.

This is my config:

What strikes me is that it wants to use internal reference as an index type, when I sporadically used it to store invoice numbers

{
    "version": 3,
    "source": "ff3-importer-1.4.5",
    "created_at": "2024-04-09T00:23:02+02:00",
    "date": "Y-m-d",
    "default_account": 12,
    "delimiter": "comma",
    "headers": true,
    "rules": false,
    "skip_form": false,
    "add_import_tag": false,
    "roles": [
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "amount_negated",
        "_ignore",
        "currency-code",
        "foreign-currency-code",
        "description",
        "date_transaction",
        "account-name",
        "_ignore",
        "_ignore",
        "opposing-name",
        "_ignore",
        "_ignore",
        "_ignore",
        "category-name",
        "_ignore",
        "_ignore",
        "tags-comma",
        "note",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "internal_reference",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore",
        "_ignore"
    ],
    "do_mapping": [
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false,
        false
    ],
    "mapping": [],
    "duplicate_detection_method": "classic",
    "ignore_duplicate_lines": true,
    "unique_column_index": 0,
    "unique_column_type": "internal_reference",
    "flow": "file",
    "content_type": "csv",
    "custom_tag": "",
    "identifier": "0",
    "connection": "0",
    "ignore_spectre_categories": false,
    "grouped_transaction_handling": "",
    "use_entire_opposing_address": false,
    "map_all_data": false,
    "accounts": [],
    "date_range": "",
    "date_range_number": 30,
    "date_range_unit": "d",
    "date_not_before": "",
    "date_not_after": "",
    "nordigen_country": "",
    "nordigen_bank": "",
    "nordigen_requisitions": [],
    "nordigen_max_days": "90",
    "conversion": true,
    "ignore_duplicate_transactions": true
}

cachho Apr 9, 2024
Author

@JC5 sorry to bother, but do you have any idea what I might be doing wrong? I mean there should be a fairly straightforward and reproducible way to export and import. If it wasn't 1000+ transactions I'd just start over :)

JC5 Apr 10, 2024
Maintainer

I'm sorry, the database is the import/export mechanism that's fairly straight-forward.

I was already out of ideas when you showed me you emptied the "migrations" table, but Firefly III insisted no migrations were necessary. Either the table isn't actually empty, or something fundamentally broke in Firefly III, but I wasn't able to replicate it.

I see no errors in the logs you've shared, are there any others?

cachho Apr 10, 2024
Author

I figured it out!

Created a clean copy with a separate docker volume and exported the creation schema of the table that's missing according to the error message with mysqldump -u firefly -p --skip-column-statistics firefly transaction_currency_user_group > transaction_currency_user_group.sql. For this I first had to use apt-get update && apt-get install mysql-client, because mysqldump was not found.
Use docker cp to copy the .sql file to the bugged container.
Tried to import it with mariadb -u firefly -p firefly < /db_import/transaction_currency_user_group.sql but of course that wouldn't work due to the error ERROR 1005 (HY000) at line 25: Can't create table `firefly`.`transaction_currency_user_group` (errno: 184 "Tablespace already exists")
I can't explain why this worked, but the issue was /var/lib/mysql/firefly/transaction_currency_user_group.ibd. Unlike other tables it didn't have a .frm and .ibd file in the /var/lib/mysql/firefly folder, only the .ibd. So I deleted that file.
Run mariadb -u firefly -p firefly < /db_import/transaction_currency_user_group.sql and now it worked
Refresh the page

Answer selected by cachho

JC5 Apr 11, 2024
Maintainer

Wow! What a solution! I had not expected that. Thanks for sharing this, I'll be sure to refer to it when other users run into similar issues.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Firefly III

Migration Error when upgrading from `6.0.26` to `6.1.13` #8762

{{title}}

Replies: 1 comment 12 replies

{{title}}

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

Select a reply

Firefly III

Migration Error when upgrading from 6.0.26 to 6.1.13 #8762

cachho Apr 7, 2024

Support guidelines

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

Description

Debug information

Expected behaviour

Steps to reproduce

Additional info

Replies: 1 comment · 12 replies

JC5 Apr 7, 2024 Maintainer

cachho Apr 8, 2024 Author

cachho Apr 9, 2024 Author

JC5 Apr 10, 2024 Maintainer

cachho Apr 10, 2024 Author

JC5 Apr 11, 2024 Maintainer

Migration Error when upgrading from `6.0.26` to `6.1.13` #8762

cachho
Apr 7, 2024

Replies: 1 comment 12 replies

JC5
Apr 7, 2024
Maintainer

cachho Apr 8, 2024
Author

cachho Apr 9, 2024
Author

JC5 Apr 10, 2024
Maintainer

cachho Apr 10, 2024
Author

JC5 Apr 11, 2024
Maintainer