Wrong balance with layout V2 #4592

steakhutzeee · 2021-03-29T20:31:08Z

steakhutzeee
Mar 29, 2021

Bug description
I am running Firefly III version 5.5.1, and my problem is:

Something strange happened while using layout V2.

My dashboard was showing a wrong balance in the top left, it was also adding to the expenses the latest expense of the previous month. Tried to change the dates of the last two expenses of february to be sure it was behaving that way.

So in my dashboard the sum of the expenses for the month was different from the one present in the transactions page.

Reverted back to old layout seems to have fixed this.

EDIT: Actually i am not able to go back to layout V2. See no errors in the logs. Attached error screen.
Old layout works fine.

Also now on old layout i have the following error when adding new expenses (they are added anyway):

Errore! Internal Firefly III Exception: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'firefly_iii_db.webhooks' doesn't exist in engine (SQL: select `webhooks`.* from `webhooks` where `webhooks`.`user_id` = 1 and `webhooks`.`user_id` is not null and `active` = 1 and `trigger` = 100 and `webhooks`.`deleted_at` is null)

Restoring a backup of the entire config directory for the database did not solve the problem.

Debug information generated at 2021-03-30 00:01:29 Europe/Rome for Firefly III version 5.5.1.

Scope	Version
Firefly III	5.5.1
Firefly III API	1.5.0
PHP	8.0.3
Host	Linux

System info	Value
Installation ID	da25608d-8526-4fc7-92f1-93ac99fccdfa
Using docker?	true
Telemetry	false
Layout
App environment	local
App debug mode	false
App cache driver	file
App logging	notice, stack
Display errors	Off
Error reporting	ALL errors
Interface	apache2handler
Default language	it_IT
Default locale	equal
BCscale	12
DB drivers	mysql, pgsql, sqlite
Current driver	mysql
DB version	16 (exp. 16)
Login provider	eloquent
Trusted proxies (.env)

User info	Value
Session start	2021-03-01 00:00:00
Session end	2021-03-31 23:59:59
Session first	2021-02-01 00:00:00
User ID	1
User language	it_IT
User locale	it_IT
Attempt at "it_IT.utf8"	'it_IT.utf8'
Attempt at "it_IT.UTF-8"	'it_IT.UTF-8'
User agent	Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0

death2cupbots · 2021-03-30T01:31:10Z

death2cupbots
Mar 30, 2021

I actually just ran into this problem too. I think I had an error when I was installing 5.5.1. I ended up reinstalling 5.5.1 and now I'm not hitting that error anymore. I do seem to be stuck with the old favicon though...

EDIT: I have not used V2 at all.

0 replies

JC5 · 2021-03-30T04:15:31Z

JC5
Mar 30, 2021
Maintainer

So I see a number of issues:

I can't do much about bad amounts until I can replicate it. I haven't seen this issue myself so far but I'll check. Please use a screenshot to tell me exactly which amount is wrong.
Use v2, not V2.
If you don't run the database migrations it will never work. If the migrations failed due to an error similar to During boot up a migration fails with "Duplicatie column name". #4545, please use the develop branch or switch back to 5.4.6.
Clear your cache to see the new favicon.

0 replies

steakhutzeee · 2021-03-30T08:44:23Z

steakhutzeee
Mar 30, 2021
Author

So I see a number of issues:

* I can't do much about bad amounts until I can replicate it. I haven't seen this issue myself so far but I'll check. Please use a screenshot to tell me exactly which amount is wrong.

* Use `v2`, not `V2`.

* If you don't run the database migrations it will never work. If the migrations failed due to an error similar to #4545, please use the develop branch or switch back to 5.4.6.

* Clear your cache to see the new favicon.

-About the bad amounts i resolved deleting and adding again the expense for february.

-Switched back to v2, thanks for this.

-Don't know what you mean when you say "If you don't run the database migrations it will never work.". Anyway yes i'm still having that warning similar to #4545 and i'm on develop branch.

-Now i still have this error when i add an expense:

Internal Firefly III Exception: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'firefly_iii_db.webhook_messages' doesn't exist (SQL: select `webhook_messages`.* from `webhook_messages` where `webhook_messages`.`sent` = 0)

0 replies

JC5 · 2021-03-30T09:01:23Z

JC5
Mar 30, 2021
Maintainer

Make sure you pull develop again and restart the container. I pushed some changes this morning.

The webhook_messages table is created in the migrations. If a migration failed in the past it may not be picked up again. I'm curious to see some log files 👍

0 replies

steakhutzeee · 2021-03-30T09:03:13Z

steakhutzeee
Mar 30, 2021
Author

Make sure you pull develop again and restart the container. I pushed some changes this morning.

The webhook_messages table is created in the migrations. If a migration failed in the past it may not be picked up again. I'm curious to see some log files 👍

From my docker compose file:

version: '3.3'
services:
firefly_iii:
image: jc5x/firefly-iii:develop
container_name: firefly_iii
env_file: .env

Already installed the update from this morning but same issue.

You mean the logs when i start firefly iii container?

0 replies

death2cupbots · 2021-03-30T12:27:32Z

death2cupbots
Mar 30, 2021

The webhook_messages table is created in the migrations. If a migration failed in the past it may not be picked up again. I'm curious to see some log files

So like I said above, I was also running into this warning. I fixed it by just redoing the 5.5.1 install.

When I was installing 5.5.1 update initially, it did throw me some errors:

[2021-03-28 12:31:59] local.WARNING: Database entry exists. Update to latest version (16)
[2021-03-28 12:32:04] local.WARNING: Database entry exists. Update to latest version (16)
[2021-03-28 12:32:08] local.ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transaction_type_id' in 'field list' (SQL: update `recurrences_transactions` set `transaction_type_id` = 1, `recurrences_transactions`.`updated_at` = 2021-03-28 12:32:08 where `id` = 43) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transaction_type_id' in 'field list' (SQL: update `recurrences_transactions` set `transaction_type_id` = 1, `recurrences_transactions`.`updated_at` = 2021-03-28 12:32:08 where `id` = 43) at /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php:678)
[stacktrace]
#0 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\\Database\\Connection->runQueryCallback()
#1 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(503): Illuminate\\Database\\Connection->run()
#2 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(436): Illuminate\\Database\\Connection->affectingStatement()
#3 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2913): Illuminate\\Database\\Connection->update()
#4 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(841): Illuminate\\Database\\Query\\Builder->update()
#5 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(936): Illuminate\\Database\\Eloquent\\Builder->update()
#6 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(851): Illuminate\\Database\\Eloquent\\Model->performUpdate()
#7 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/MigrateRecurrenceType.php(111): Illuminate\\Database\\Eloquent\\Model->save()
#8 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/MigrateRecurrenceType.php(97): FireflyIII\\Console\\Commands\\Upgrade\\MigrateRecurrenceType->migrateRecurrence()
#9 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/MigrateRecurrenceType.php(65): FireflyIII\\Console\\Commands\\Upgrade\\MigrateRecurrenceType->migrateTypes()
#10 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\MigrateRecurrenceType->handle()
#11 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#12 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#13 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#14 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Container.php(611): Illuminate\\Container\\BoundMethod::call()
#15 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#16 /srv/firefly-iii-updated/vendor/symfony/console/Command/Command.php(256): Illuminate\\Console\\Command->execute()
#17 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#18 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run()
#19 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand()
#20 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun()
#21 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Application.php(92): Symfony\\Component\\Console\\Application->run()
#22 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Application.php(184): Illuminate\\Console\\Application->run()
#23 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(263): Illuminate\\Console\\Application->call()
#24 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Foundation\\Console\\Kernel->call()
#25 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/UpgradeDatabase.php(113): Illuminate\\Support\\Facades\\Facade::__callStatic()
#26 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->handle()
#27 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#28 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#29 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#30 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Container.php(611): Illuminate\\Container\\BoundMethod::call()
#31 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#32 /srv/firefly-iii-updated/vendor/symfony/console/Command/Command.php(256): Illuminate\\Console\\Command->execute()
#33 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#34 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run()
#35 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand()
#36 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun()
#37 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Application.php(92): Symfony\\Component\\Console\\Application->run()
#38 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run()
#39 /srv/firefly-iii-updated/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#40 {main}

[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'transaction_type_id' in 'field list' at /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php:492)
[stacktrace]
#0 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(492): PDO->prepare()
#1 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(671): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\\Database\\Connection->runQueryCallback()
#3 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(503): Illuminate\\Database\\Connection->run()
#4 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Connection.php(436): Illuminate\\Database\\Connection->affectingStatement()
#5 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2913): Illuminate\\Database\\Connection->update()
#6 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(841): Illuminate\\Database\\Query\\Builder->update()
#7 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(936): Illuminate\\Database\\Eloquent\\Builder->update()
#8 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php(851): Illuminate\\Database\\Eloquent\\Model->performUpdate()
#9 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/MigrateRecurrenceType.php(111): Illuminate\\Database\\Eloquent\\Model->save()
#10 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/MigrateRecurrenceType.php(97): FireflyIII\\Console\\Commands\\Upgrade\\MigrateRecurrenceType->migrateRecurrence()
#11 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/MigrateRecurrenceType.php(65): FireflyIII\\Console\\Commands\\Upgrade\\MigrateRecurrenceType->migrateTypes()
#12 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\MigrateRecurrenceType->handle()
#13 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#14 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#15 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#16 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Container.php(611): Illuminate\\Container\\BoundMethod::call()
#17 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#18 /srv/firefly-iii-updated/vendor/symfony/console/Command/Command.php(256): Illuminate\\Console\\Command->execute()
#19 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#20 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run()
#21 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand()
#22 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun()
#23 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Application.php(92): Symfony\\Component\\Console\\Application->run()
#24 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Application.php(184): Illuminate\\Console\\Application->run()
#25 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(263): Illuminate\\Console\\Application->call()
#26 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(261): Illuminate\\Foundation\\Console\\Kernel->call()
#27 /srv/firefly-iii-updated/app/Console/Commands/Upgrade/UpgradeDatabase.php(113): Illuminate\\Support\\Facades\\Facade::__callStatic()
#28 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Upgrade\\UpgradeDatabase->handle()
#29 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#30 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#31 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#32 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Container/Container.php(611): Illuminate\\Container\\BoundMethod::call()
#33 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#34 /srv/firefly-iii-updated/vendor/symfony/console/Command/Command.php(256): Illuminate\\Console\\Command->execute()
#35 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#36 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run()
#37 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand()
#38 /srv/firefly-iii-updated/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun()
#39 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Console/Application.php(92): Symfony\\Component\\Console\\Application->run()
#40 /srv/firefly-iii-updated/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run()
#41 /srv/firefly-iii-updated/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#42 {main}
"}

When I went to the website after I finished the the update, it had some error message about still being 5.4.6 instead of 5.5.1, but I refreshed the page and got in just fine. I didn't have any transactions to enter on Sunday when I updated it, but I had a cron job fire Monday morning, and I guess it also got upset about the webhooks:

2021-03-29 01:00:04] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fireflyiii.webhooks' doesn't exist (SQL: select `webhooks`.* from `webhooks` where `webhooks`.`user_id` = 1 and `webhooks`.`user_id` is not null and `active` = 1 and `trigger` = 100 and `webhooks`.`deleted_at` is null) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fireflyiii.webhooks' doesn't exist (SQL: select `webhooks`.* from `webhooks` where `webhooks`.`user_id` = 1 and `webhooks`.`user_id` is not null and `active` = 1 and `trigger` = 100 and `webhooks`.`deleted_at` is null) at /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:678)
[stacktrace]
#0 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\\Database\\Connection->runQueryCallback()
#1 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(346): Illuminate\\Database\\Connection->run()
#2 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2313): Illuminate\\Database\\Connection->select()
#3 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2301): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2796): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2302): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(588): Illuminate\\Database\\Query\\Builder->get()
#7 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(572): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(188): Illuminate\\Database\\Eloquent\\Builder->get()
#9 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(105): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()
#10 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(59): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->getWebhooks()
#11 /srv/firefly-iii/app/Handlers/Events/StoredGroupEventHandler.php(98): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->generateMessages()
#12 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(412): FireflyIII\\Handlers\\Events\\StoredGroupEventHandler->triggerWebhooks()
#13 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(237): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}()
#14 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(432): Illuminate\\Events\\Dispatcher->dispatch()
#15 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(393): event()
#16 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(335): FireflyIII\\Jobs\\CreateRecurringTransactions->handleOccurrence()
#17 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(314): FireflyIII\\Jobs\\CreateRecurringTransactions->handleOccurrences()
#18 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(120): FireflyIII\\Jobs\\CreateRecurringTransactions->handleRepetitions()
#19 /srv/firefly-iii/app/Support/Cronjobs/RecurringCronjob.php(90): FireflyIII\\Jobs\\CreateRecurringTransactions->handle()
#20 /srv/firefly-iii/app/Support/Cronjobs/RecurringCronjob.php(75): FireflyIII\\Support\\Cronjobs\\RecurringCronjob->fireRecurring()
#21 /srv/firefly-iii/app/Console/Commands/Tools/Cron.php(130): FireflyIII\\Support\\Cronjobs\\RecurringCronjob->fire()
#22 /srv/firefly-iii/app/Console/Commands/Tools/Cron.php(78): FireflyIII\\Console\\Commands\\Tools\\Cron->recurringCronJob()
#23 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Tools\\Cron->handle()
#24 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#25 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#26 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#27 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Container.php(611): Illuminate\\Container\\BoundMethod::call()
#28 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#29 /srv/firefly-iii/vendor/symfony/console/Command/Command.php(256): Illuminate\\Console\\Command->execute()
#30 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#31 /srv/firefly-iii/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run()
#32 /srv/firefly-iii/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand()
#33 /srv/firefly-iii/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun()
#34 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Application.php(92): Symfony\\Component\\Console\\Application->run()
#35 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run()
#36 /srv/firefly-iii/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#37 {main}

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fireflyiii.webhooks' doesn't exist at /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:338>
[stacktrace]
#0 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): PDO->prepare()
#1 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(671): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\\Database\\Connection->runQueryCallback()
#3 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(346): Illuminate\\Database\\Connection->run()
#4 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2313): Illuminate\\Database\\Connection->select()
#5 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2301): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2796): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2302): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(588): Illuminate\\Database\\Query\\Builder->get()
#9 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(572): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(188): Illuminate\\Database\\Eloquent\\Builder->get()
#11 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(105): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()
#12 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(59): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->getWebhooks()
#13 /srv/firefly-iii/app/Handlers/Events/StoredGroupEventHandler.php(98): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->generateMessages()
#14 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(412): FireflyIII\\Handlers\\Events\\StoredGroupEventHandler->triggerWebhooks()
#15 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(237): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}()
#16 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(432): Illuminate\\Events\\Dispatcher->dispatch()
#17 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(393): event()
#18 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(335): FireflyIII\\Jobs\\CreateRecurringTransactions->handleOccurrence()
#19 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(314): FireflyIII\\Jobs\\CreateRecurringTransactions->handleOccurrences()
#20 /srv/firefly-iii/app/Jobs/CreateRecurringTransactions.php(120): FireflyIII\\Jobs\\CreateRecurringTransactions->handleRepetitions()
#21 /srv/firefly-iii/app/Support/Cronjobs/RecurringCronjob.php(90): FireflyIII\\Jobs\\CreateRecurringTransactions->handle()
#22 /srv/firefly-iii/app/Support/Cronjobs/RecurringCronjob.php(75): FireflyIII\\Support\\Cronjobs\\RecurringCronjob->fireRecurring()
#23 /srv/firefly-iii/app/Console/Commands/Tools/Cron.php(130): FireflyIII\\Support\\Cronjobs\\RecurringCronjob->fire()
#24 /srv/firefly-iii/app/Console/Commands/Tools/Cron.php(78): FireflyIII\\Console\\Commands\\Tools\\Cron->recurringCronJob()
#25 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): FireflyIII\\Console\\Commands\\Tools\\Cron->handle()
#26 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Util.php(40): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#27 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#28 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(37): Illuminate\\Container\\BoundMethod::callBoundMethod()
#29 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Container.php(611): Illuminate\\Container\\BoundMethod::call()
#30 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(136): Illuminate\\Container\\Container->call()
#31 /srv/firefly-iii/vendor/symfony/console/Command/Command.php(256): Illuminate\\Console\\Command->execute()
#32 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(121): Symfony\\Component\\Console\\Command\\Command->run()
#33 /srv/firefly-iii/vendor/symfony/console/Application.php(971): Illuminate\\Console\\Command->run()
#34 /srv/firefly-iii/vendor/symfony/console/Application.php(290): Symfony\\Component\\Console\\Application->doRunCommand()
#35 /srv/firefly-iii/vendor/symfony/console/Application.php(166): Symfony\\Component\\Console\\Application->doRun()
#36 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Application.php(92): Symfony\\Component\\Console\\Application->run()
#37 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(129): Illuminate\\Console\\Application->run()
#38 /srv/firefly-iii/artisan(37): Illuminate\\Foundation\\Console\\Kernel->handle()
#39 {main}
"}

I didn't realize this was an issue because when I looked at the site Monday morning, everything seemed fine. When I went to enter a new transfer, it gave me the webhook error and wouldn't go past the screen, but it did save the transaction.

[2021-03-29 21:10:33] local.ERROR: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fireflyiii.webhooks' doesn't exist (SQL: select `webhooks`.* from `webhooks` where `webhooks`.`user_id` = 1 and `webhooks`.`user_id` is not null and `active` = 1 and `trigger` = 100 and `webhooks`.`deleted_at` is null) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fireflyiii.webhooks' doesn't exist (SQL: select `webhooks`.* from `webhooks` where `webhooks`.`user_id` = 1 and `webhooks`.`user_id` is not null and `active` = 1 and `trigger` = 100 and `webhooks`.`deleted_at` is null) at /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:678)
[stacktrace]
#0 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\\Database\\Connection->runQueryCallback()
#1 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(346): Illuminate\\Database\\Connection->run()
#2 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2313): Illuminate\\Database\\Connection->select()
#3 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2301): Illuminate\\Database\\Query\\Builder->runSelect()
#4 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2796): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#5 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2302): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#6 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(588): Illuminate\\Database\\Query\\Builder->get()
#7 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(572): Illuminate\\Database\\Eloquent\\Builder->getModels()
#8 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(188): Illuminate\\Database\\Eloquent\\Builder->get()
#9 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(105): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()
#10 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(59): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->getWebhooks()
#11 /srv/firefly-iii/app/Handlers/Events/StoredGroupEventHandler.php(98): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->generateMessages()
#12 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(412): FireflyIII\\Handlers\\Events\\StoredGroupEventHandler->triggerWebhooks()
#13 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(237): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}()
#14 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(432): Illuminate\\Events\\Dispatcher->dispatch()
#15 /srv/firefly-iii/app/Api/V1/Controllers/Models/Transaction/StoreController.php(106): event()
#16 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): FireflyIII\\Api\\V1\\Controllers\\Models\\Transaction\\StoreController->store()
#17 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#18 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Route.php(254): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#19 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Route.php(197): Illuminate\\Routing\\Route->runController()
#20 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(693): Illuminate\\Routing\\Route->run()
#21 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#22 /srv/firefly-iii/app/Api/V1/Controllers/Models/Transaction/StoreController.php(68): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#23 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): FireflyIII\\Api\\V1\\Controllers\\Models\\Transaction\\StoreController->FireflyIII\\Api\\V1\\Controllers\\Models\\Transaction\\{closure}()
#24 /srv/firefly-iii/app/Api/V1/Controllers/Controller.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#25 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): FireflyIII\\Api\\V1\\Controllers\\Controller->FireflyIII\\Api\\V1\\Controllers\\{closure}()
#26 /srv/firefly-iii/app/Http/Middleware/Binder.php(79): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\Binder->handle()
#28 /srv/firefly-iii/app/Http/Middleware/Authenticate.php(74): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\Authenticate->handle()
#30 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(695): Illuminate\\Pipeline\\Pipeline->then()
#32 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(670): Illuminate\\Routing\\Router->runRouteWithinStack()
#33 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(636): Illuminate\\Routing\\Router->runRoute()
#34 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->dispatchToRoute()
#35 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(166): Illuminate\\Routing\\Router->dispatch()
#36 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#37 /srv/firefly-iii/app/Http/Middleware/InstallationId.php(54): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#38 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\InstallationId->handle()
#39 /srv/firefly-iii/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#41 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#43 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#45 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#46 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#47 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#48 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#49 /srv/firefly-iii/app/Http/Middleware/SecureHeaders.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\SecureHeaders->handle()
#51 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#52 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(141): Illuminate\\Pipeline\\Pipeline->then()
#53 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#54 /srv/firefly-iii/public/index.php(76): Illuminate\\Foundation\\Http\\Kernel->handle()
#55 {main}

[previous exception] [object] (PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fireflyiii.webhooks' doesn't exist at /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:338>
[stacktrace]
#0 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(338): PDO->prepare()
#1 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(671): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(638): Illuminate\\Database\\Connection->runQueryCallback()
#3 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(346): Illuminate\\Database\\Connection->run()
#4 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2313): Illuminate\\Database\\Connection->select()
#5 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2301): Illuminate\\Database\\Query\\Builder->runSelect()
#6 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2796): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}()
#7 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(2302): Illuminate\\Database\\Query\\Builder->onceWithColumns()
#8 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(588): Illuminate\\Database\\Query\\Builder->get()
#9 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(572): Illuminate\\Database\\Eloquent\\Builder->getModels()
#10 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/Relation.php(188): Illuminate\\Database\\Eloquent\\Builder->get()
#11 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(105): Illuminate\\Database\\Eloquent\\Relations\\Relation->get()
#12 /srv/firefly-iii/app/Generator/Webhook/StandardMessageGenerator.php(59): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->getWebhooks()
#13 /srv/firefly-iii/app/Handlers/Events/StoredGroupEventHandler.php(98): FireflyIII\\Generator\\Webhook\\StandardMessageGenerator->generateMessages()
#14 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(412): FireflyIII\\Handlers\\Events\\StoredGroupEventHandler->triggerWebhooks()
#15 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(237): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}()
#16 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/helpers.php(432): Illuminate\\Events\\Dispatcher->dispatch()
#17 /srv/firefly-iii/app/Api/V1/Controllers/Models/Transaction/StoreController.php(106): event()
#18 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): FireflyIII\\Api\\V1\\Controllers\\Models\\Transaction\\StoreController->store()
#19 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction()
#20 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Route.php(254): Illuminate\\Routing\\ControllerDispatcher->dispatch()
#21 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Route.php(197): Illuminate\\Routing\\Route->runController()
#22 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(693): Illuminate\\Routing\\Route->run()
#23 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}()
#24 /srv/firefly-iii/app/Api/V1/Controllers/Models/Transaction/StoreController.php(68): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#25 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): FireflyIII\\Api\\V1\\Controllers\\Models\\Transaction\\StoreController->FireflyIII\\Api\\V1\\Controllers\\Models\\Transaction\\{closure}()
#26 /srv/firefly-iii/app/Api/V1/Controllers/Controller.php(64): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#27 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(149): FireflyIII\\Api\\V1\\Controllers\\Controller->FireflyIII\\Api\\V1\\Controllers\\{closure}()
#28 /srv/firefly-iii/app/Http/Middleware/Binder.php(79): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#29 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\Binder->handle()
#30 /srv/firefly-iii/app/Http/Middleware/Authenticate.php(74): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#31 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\Authenticate->handle()
#32 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#33 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(695): Illuminate\\Pipeline\\Pipeline->then()
#34 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(670): Illuminate\\Routing\\Router->runRouteWithinStack()
#35 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(636): Illuminate\\Routing\\Router->runRoute()
#36 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Routing/Router.php(625): Illuminate\\Routing\\Router->dispatchToRoute()
#37 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(166): Illuminate\\Routing\\Router->dispatch()
#38 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}()
#39 /srv/firefly-iii/app/Http/Middleware/InstallationId.php(54): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#40 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\InstallationId->handle()
#41 /srv/firefly-iii/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#42 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Fideloper\\Proxy\\TrustProxies->handle()
#43 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#44 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#45 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#46 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle()
#47 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#48 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle()
#49 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#50 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle()
#51 /srv/firefly-iii/app/Http/Middleware/SecureHeaders.php(51): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#52 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(167): FireflyIII\\Http\\Middleware\\SecureHeaders->handle()
#53 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}()
#54 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(141): Illuminate\\Pipeline\\Pipeline->then()
#55 /srv/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter()
#56 /srv/firefly-iii/public/index.php(76): Illuminate\\Foundation\\Http\\Kernel->handle()
#57 {main}
"}

@steakhutzeee I'm not sure about the Docker files, but my logs were:
firefly-iii/storage/logs/ff3-cli-2021-03-28.log for the install
firefly-iii/storage/logs/ff3-cli-2021-03-29.log for the cron job
firefly-iii/storage/logs/ff3-fpm-fcgi-2021-03-29.log for the website error

Again, I'm not running on docker and I haven't used V2 yet, but I did get the same exact problem with entering transactions.

0 replies

JC5 · 2021-03-30T12:55:39Z

JC5
Mar 30, 2021
Maintainer

Well at least its consistent about explaining about the tables. I still have no clue why it won't run the migrations.

0 replies

steakhutzeee · 2021-03-30T17:59:38Z

steakhutzeee
Mar 30, 2021
Author

So with develop branch the issues persit,

Moved back to version 5.4.6 and no issues. Everything works fine.

0 replies

death2cupbots · 2021-03-30T18:23:02Z

death2cupbots
Mar 30, 2021

Moved back to version 5.4.6 and no issues. Everything works fine.

I rolled back to 5.4.6 initially too and had no issues. I redid the 5.5.1 upgrade and it upgraded fine that time. Maybe try it again?

0 replies

steakhutzeee · 2021-03-30T18:57:18Z

steakhutzeee
Mar 30, 2021
Author

Moved back to version 5.4.6 and no issues. Everything works fine.

I rolled back to 5.4.6 initially too and had no issues. I redid the 5.5.1 upgrade and it upgraded fine that time. Maybe try it again?

No luck for me, tried:

5.4.6 -> latest
5.4.6 -> develop

Same issues.

It's related to #4549 #4545

0 replies

death2cupbots · 2021-03-30T20:26:55Z

death2cupbots
Mar 30, 2021

The weird thing is everyone else is getting duplicate column errors and the one I got was unknown column.

0 replies

JC5 · 2021-04-03T05:41:56Z

JC5
Apr 3, 2021
Maintainer

5.5.2 is released.

0 replies

steakhutzeee · 2021-04-03T09:44:37Z

steakhutzeee
Apr 3, 2021
Author

5.5.2 is released.

Updated to latest, I still get:

today at 11:40  Database "firefly_iii_db" exists.
today at 11:40  Migrating: 2020_11_12_070604_changes_for_v550
today at 11:40  [2021-04-03 11:40:35] local.ERROR: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'budget_limit_id' (SQL: alter table `budget_transaction_journal` add `budget_limit_id` int unsigned null after `budget_id`) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'budget_limit_id' (SQL: alter table `budget_transaction_journal` add `budget_limit_id` int unsigned null after `budget_id`) at /var/www/html/vendor/laravel/framework/src/Illuminate/Database/Connection.php:678)
today at 11:40  [stacktrace]

today at 11:40  In Connection.php line 678:
today at 11:40                                                                                 
today at 11:40    SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'budget_  
today at 11:40    limit_id' (SQL: alter table `budget_transaction_journal` add `budget_limit_  
today at 11:40    id` int unsigned null after `budget_id`)                                     
today at 11:40                                                                                 
today at 11:40  
today at 11:40  In Connection.php line 471:
today at 11:40                                                                                 
today at 11:40    SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'budget_  
today at 11:40    limit_id'                                                                    
today at 11:40

0 replies

JC5 · 2021-04-03T10:34:22Z

JC5
Apr 3, 2021
Maintainer

Mmm. I can put everything into if/then clauses but this feels more fundamental. What's the content of the migrations table?

0 replies

steakhutzeee · 2021-04-03T10:37:43Z

steakhutzeee
Apr 3, 2021
Author

Mmm. I can put everything into if/then clauses but this feels more fundamental. What's the content of the migrations table?

Can you point me on the right direction? I have no clue how to find the migration table's content.

14 replies

steakhutzeee Apr 4, 2021
Author

Glad to hear it almost works! Pretty sure the "no name" is a bug on my end. Thanks for your patience!

Oh you say 'almost', you think something else needs to be fixed?

It's me that need to thank you for your time and patience!

JC5 Apr 4, 2021
Maintainer

Only the "no name" thing, but that's on me! 👍

steakhutzeee Apr 4, 2021
Author

Thank you very much for al your support!

steakhutzeee Apr 6, 2021
Author

Quick question, is it ok to have this warning in the logs?

today at 21:05  Nothing to migrate.
today at 21:05  Seeding: Database\Seeders\AccountTypeSeeder
today at 21:05  Seeded:  Database\Seeders\AccountTypeSeeder (520.08ms)
today at 21:05  Seeding: Database\Seeders\TransactionCurrencySeeder
today at 21:05  Seeded:  Database\Seeders\TransactionCurrencySeeder (1,194.85ms)
today at 21:05  Seeding: Database\Seeders\TransactionTypeSeeder
today at 21:05  Seeded:  Database\Seeders\TransactionTypeSeeder (300.67ms)
today at 21:05  Seeding: Database\Seeders\PermissionSeeder
today at 21:05  Seeded:  Database\Seeders\PermissionSeeder (99.57ms)
today at 21:05  Seeding: Database\Seeders\LinkTypeSeeder
today at 21:05  Seeded:  Database\Seeders\LinkTypeSeeder (199.90ms)
today at 21:05  Seeding: Database\Seeders\ConfigSeeder
today at 21:05  [2021-04-06 21:05:14] local.WARNING: Database entry exists. Update to latest version (16)  
today at 21:05  Seeded:  Database\Seeders\ConfigSeeder (15.53ms)
today at 21:05  Database seeding completed successfully.

JC5 Apr 7, 2021
Maintainer

Yes that's not an issue!

M-Paladin · 2021-04-03T13:01:25Z

M-Paladin
Apr 3, 2021

Before doing the upgrade, the first time I executed
php artisan migrate --seed
I had a message and if I executed once again I had the same message as yours

maybe have a look at this
#4543 (comment)
I restore my machine to previous state and start over again and it worked.

0 replies

steakhutzeee · 2021-04-03T13:44:02Z

steakhutzeee
Apr 3, 2021
Author

Before doing the upgrade, the first time I executed
php artisan migrate --seed
I had a message and if I executed once again I had the same message as yours

maybe have a look at this
#4543 (comment)
I restore my machine to previous state and start over again and it worked.

I'm not sure I understand properly, your advice is to use the commands you used in the link you posted while I'm on 5.4.6? Or later after the upgrade to 5.5.2?

0 replies

M-Paladin · 2021-04-03T14:21:13Z

M-Paladin
Apr 3, 2021

Upgrade system
Use commands
Upgrade Firefly from 5.4.6 to 5.5.2

0 replies

steakhutzeee · 2021-04-03T16:39:24Z

steakhutzeee
Apr 3, 2021
Author

Upgrade system
Use commands
Upgrade Firefly from 5.4.6 to 5.5.2

Nope, same issue.

Had a look at the commands but I'm not so in depth with databases, should I revert these changes back or it's ok this way?

0 replies

M-Paladin · 2021-04-03T19:38:49Z

M-Paladin
Apr 3, 2021

As it solves my case, I don't think keeping these parameters is a problem
All that said, you do what you want. I'm not a database expert either.

0 replies

Wrong balance with layout V2 #4592

Uh oh!

Uh oh!

Replies: 20 comments · 14 replies

Uh oh!

Uh oh!

Uh oh!

Uh oh!

JC5 Mar 30, 2021 Maintainer

Uh oh!

Uh oh!

steakhutzeee Mar 30, 2021 Author

Uh oh!

JC5 Mar 30, 2021 Maintainer

Uh oh!

steakhutzeee Mar 30, 2021 Author

Uh oh!

Uh oh!

JC5 Mar 30, 2021 Maintainer

Uh oh!

steakhutzeee Mar 30, 2021 Author

Uh oh!

Uh oh!

Uh oh!

steakhutzeee Mar 30, 2021 Author

Uh oh!

Uh oh!

JC5 Apr 3, 2021 Maintainer

Uh oh!

Uh oh!

steakhutzeee Apr 3, 2021 Author

Uh oh!

JC5 Apr 3, 2021 Maintainer

Uh oh!

steakhutzeee Apr 3, 2021 Author

Uh oh!

steakhutzeee Apr 4, 2021 Author

Uh oh!

JC5 Apr 4, 2021 Maintainer

Uh oh!

steakhutzeee Apr 4, 2021 Author

Uh oh!

Uh oh!

steakhutzeee Apr 6, 2021 Author

Uh oh!

JC5 Apr 7, 2021 Maintainer

Uh oh!

Uh oh!

Uh oh!

steakhutzeee Apr 3, 2021 Author

Uh oh!

Uh oh!

Uh oh!

steakhutzeee Apr 3, 2021 Author

Uh oh!

Replies: 20 comments 14 replies

JC5
Mar 30, 2021
Maintainer

steakhutzeee
Mar 30, 2021
Author

JC5
Mar 30, 2021
Maintainer

steakhutzeee
Mar 30, 2021
Author

JC5
Mar 30, 2021
Maintainer

steakhutzeee
Mar 30, 2021
Author

steakhutzeee
Mar 30, 2021
Author

JC5
Apr 3, 2021
Maintainer

steakhutzeee
Apr 3, 2021
Author

JC5
Apr 3, 2021
Maintainer

steakhutzeee
Apr 3, 2021
Author

steakhutzeee Apr 4, 2021
Author

JC5 Apr 4, 2021
Maintainer

steakhutzeee Apr 4, 2021
Author

steakhutzeee Apr 6, 2021
Author

JC5 Apr 7, 2021
Maintainer

steakhutzeee
Apr 3, 2021
Author

steakhutzeee
Apr 3, 2021
Author