"Something went wrong" and 500 server errors

Knupps · February 15, 2024, 1:48pm

Installed “latest” InvoiceNinja 5.8.24 in Docker on Synology.

Upon first launch, language and currency options are blank:

In control panel whenever I click, there is “Something went wrong”.

InvoiceNinja App container log:

192.168.0.42 -  15/Feb/2024:13:14:49 +0000 "GET /index.php" 500

InvoiceNinja Cache container log:

1:C 15 Feb 2024 11:41:37.906 # WARNING Memory overcommit must be enabled! Without it, a background save or replication may fail under low memory condition. Being disabled, it can also cause failures without low memory condition, see https://github.com/jemalloc/jemalloc/issues/1328. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.

Tilt! I am out. Any help would be very much appreciated.

hillel · February 15, 2024, 2:03pm

Hi,

Are there any details about the 500 error in storage/logs?

Nhassan · February 15, 2024, 2:14pm

Hi @hillel mine also same. after update to 5.8.24 from 5.8.23, the page is not loading. Flutter was by default during update.

Knupps · February 15, 2024, 3:08pm

I rebuilt the containers several times and restartet (because they seem to hang after initial launch). Here is the “/storage/logs/laravel.log”:

(..)
[previous exception] [object] (PDOException(code: 42S21): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'is_tax_exempt' at /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587)
[stacktrace]
#0 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(587): PDOStatement->execute()
#1 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(816): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}()
#2 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(783): Illuminate\\Database\\Connection->runQueryCallback()
#3 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Connection.php(576): Illuminate\\Database\\Connection->run()
#4 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(110): Illuminate\\Database\\Connection->statement()
#5 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(602): Illuminate\\Database\\Schema\\Blueprint->build()
#6 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(444): Illuminate\\Database\\Schema\\Builder->build()
#7 /var/www/app/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(355): Illuminate\\Database\\Schema\\Builder->table()
#8 /var/www/app/database/migrations/2023_03_24_054758_add_client_is_exempt_from_taxes.php(23): Illuminate\\Support\\Facades\\Facade::__callStatic()
#9 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(493): Illuminate\\Database\\Migrations\\Migration@anonymous->up()
#10 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\\Database\\Migrations\\Migrator->runMethod()
#11 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(419): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#12 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->runMigration()
#13 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(37): Illuminate\\Database\\Migrations\\Migrator->Illuminate\\Database\\Migrations\\{closure}()
#14 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(756): Illuminate\\Console\\View\\Components\\Task->render()
#15 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(216): Illuminate\\Database\\Migrations\\Migrator->write()
#16 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(181): Illuminate\\Database\\Migrations\\Migrator->runUp()
#17 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(124): Illuminate\\Database\\Migrations\\Migrator->runPending()
#18 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(90): Illuminate\\Database\\Migrations\\Migrator->run()
#19 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(633): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->Illuminate\\Database\\Console\\Migrations\\{closure}()
#20 /var/www/app/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(83): Illuminate\\Database\\Migrations\\Migrator->usingConnection()
#21 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Database\\Console\\Migrations\\MigrateCommand->handle()
#22 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()
#23 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure()
#24 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod()
#25 /var/www/app/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call()
#26 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call()
#27 /var/www/app/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute()
#28 /var/www/app/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run()
#29 /var/www/app/vendor/symfony/console/Application.php(1096): Illuminate\\Console\\Command->run()
#30 /var/www/app/vendor/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand()
#31 /var/www/app/vendor/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun()
#32 /var/www/app/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\\Component\\Console\\Application->run()
#33 /var/www/app/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle()
#34 {main}
"}

hillel · February 15, 2024, 3:15pm

It looks like this database migration may have failed:

database/migrations/2023_03_24_054758_add_client_is_exempt_from_taxes.php

Are there any errors earlier in the logs explaining why it failed?

Knupps · February 15, 2024, 4:40pm

Sorry, not that I am aware of. I am confused why it “migrated” anyway as I deleted the Docker containers, deleted all host volumes and rebuilt them from scratch.

It would be so cool if there would be a step-by-step instructions for a Synology/Docker install.

Knupps · February 16, 2024, 7:34am

Solution: Regardless if the four Docker containers show “healthy” or “running”, it takes an extra extreme(!) long time to let NinjaInvoice setup everything up on a mid-range Synology DS220+ with 10GB RAM. Let it run overnight and you are good to go.

Thank you for your assistance anyway. Very much appreciated.

Very good installation tutorial: https://www.youtube.com/watch?v=TcEI7pZTJZA (no affiliation, this guy explains it really well).