HTTP 500 Internal Server Error

[FelipeGodoy96]

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

I am trying to install firefly natively on my Ubuntu VPS machine but I keep geting an 500 internal server error.
I am running NGINX as reverse proxy and apache as my web server.
I tried everything, reinstalling, refreshing cache, etc etc etc.
Here's the two log errors I keep getting
[2025-01-26 01:38:50] local.ERROR: Could not execute query (table "journal_meta", field "data"): SQLSTATE[42000]: Syntax error or access >[2025-01-26 01:38:50] local.ERROR: If the index already exists (see error), or if MySQL can't do it, this is not an problem. Otherwise, p>[2025-01-26 01:38:58] local.ERROR: Exception is: {"class":"Illuminate\\Database\\QueryException","errorMessage":"SQLSTATE[42S01]: Base ta>[2025-01-26 01:38:58] local.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists (Conn>

[2025-01-26 01:44:27] local.ERROR: Exception is: {"class":"Illuminate\\View\\ViewException","errorMessage":"Vite manifest not found at: \>[2025-01-26 01:44:27] local.ERROR: Vite manifest not found at: /var/www/firefly-iii/public/build/manifest.json {"view":{"view":"/var/www/>

Debug information

Also, I get another error while running the installation commands
81 packages you are using are looking for funding. Use the composer fund` command to find out more!

@php artisan firefly-iii:instructions install

Illuminate\Encryption\MissingAppKeyException

No application encryption key has been specified.

at vendor/laravel/framework/src/Illuminate/Encryption/EncryptionServiceProvider.php:83
79▕ protected function key(array $config)
80▕ {
81▕ return tap($config['key'], function ($key) {
82▕ if (empty($key)) {
➜ 83▕ throw new MissingAppKeyException;
84▕ }
85▕ });
86▕ }
87▕ }

  +27 vendor frames

28 app/Exceptions/Handler.php:208
Illuminate\Auth\AuthManager::__call()
+3 vendor frames

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

Script @php artisan firefly-iii:instructions install handling the post-install-cmd event returned with error code 1`

Expected behaviour

No response

Steps to reproduce

No response

Additional info

No response

[JC5]

Hi, thanks for starting a discussion.

Could you tell me a little bit more about your process? Did you download the zip file from the releases page?

[FelipeGodoy96]

Hello, I don't know exactly which version I download since I did everything using AI. Possibly from main branch. I have now took a look at releases page and changelog and I saw that the latest version (not released) is 6.20+ which is using PHP 8.4. When I download and tried to install it asked me to use PHP 8.4 so I guess I'm using a non released version. I will try again with this non released version and if I still have problems I change to the last stable version.

[FelipeGodoy96]

[SORRY FOR THE AWFUL FORMATTING]
Here is what I did now:

I started removing all the firefly files and clearing chace, and database
sudo rm -rf /var/www/firefly-iii composer clear-cache
DROP DATABASE firefly; CREATE DATABASE firefly; GRANT ALL PRIVILEGES ON firefly.* TO 'firefly'@'localhost'; FLUSH PRIVILEGES; exit

Then I download, extracted and changed permissions
cd /var/www sudo wget https://github.com/firefly-iii/firefly-iii/archive/refs/tags/v6.2.0-beta.1.zip sudo unzip v6.2.0-beta.1.zip sudo mv firefly-iii-6.2.0-beta.1 firefly-iii sudo rm v6.2.0-beta.1.zip cd firefly-iii sudo chown -R www-data:www-data storage bootstrap/cache sudo chmod -R 775 storage bootstrap/cache sudo chown -R www-data:www-data /var/www/firefly-iii sudo chmod -R 755 /var/www/firefly-iii sudo chmod -R 775 /var/www/firefly-iii/storage

Then I run composer install and got an error:

2016_06_01_000001_create_oauth_auth_codes_table ......................................................................... 13.79ms FAIL
[2025-01-26 14:02:23] local.ERROR: Exception is: {"class":"Illuminate\Database\QueryException","errorMessage":"SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists (Connection: mysql, SQL: create table oauth_auth_codes (id varchar(100) not null, user_id bigint unsigned not null, client_id bigint unsigned not null, scopes text null, revoked tinyint(1) not null, expires_at datetime null, primary key (id)) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)","time":"Sun, 26 Jan 2025 14:02:23 +0000","file":"/var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php","line":825,"code":"42S01","version":"6.2.0-beta.1","url":"https://firefly.godoynetworks.com","userAgent":"Symfony","json":true,"method":"GET","post":""}
[2025-01-26 14:02:23] local.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists (Connection: mysql, SQL: create table oauth_auth_codes (id varchar(100) not null, user_id bigint unsigned not null, client_id bigint unsigned not null, scopes text null, revoked tinyint(1) not null, expires_at datetime null, primary key (id)) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) {"exception":"[object] (Illuminate\Database\QueryException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists (Connection: mysql, SQL: create table oauth_auth_codes (id varchar(100) not null, user_id bigint unsigned not null, client_id bigint unsigned not null, scopes text null, revoked tinyint(1) not null, expires_at datetime null, primary key (id)) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB) at /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:825)
[stacktrace]
#0 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#1 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#2 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#3 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#4 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#5 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->create()
#6 /var/www/firefly-iii/database/migrations/2016_06_01_000001_create_oauth_auth_codes_table.php(14): Illuminate\Support\Facades\Facade::__callStatic()
#7 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(476): Illuminate\Database\Migrations\Migration@anonymous->up()
#8 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\Database\Migrations\Migrator->runMethod()
#9 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():397}()
#10 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\Database\Migrations\Migrator->runMigration()
#11 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():213}()
#12 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(737): Illuminate\Console\View\Components\Task->render()
#13 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\Database\Migrations\Migrator->write()
#14 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(180): Illuminate\Database\Migrations\Migrator->runUp()
#15 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(123): Illuminate\Database\Migrations\Migrator->runPending()
#16 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#17 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(616): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#18 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#19 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#20 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#21 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#22 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#23 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#24 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\Container\BoundMethod::call()
#25 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#26 /var/www/firefly-iii/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute()
#27 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#28 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\Console\Command->run()
#29 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\Console\Command->runCommand()
#30 /var/www/firefly-iii/vendor/laravel/passport/src/Console/InstallCommand.php(45): Illuminate\Console\Command->call()
#31 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Laravel\Passport\Console\InstallCommand->handle()
#32 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#33 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#34 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#35 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\Container\BoundMethod::call()
#36 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#37 /var/www/firefly-iii/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute()
#38 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#39 /var/www/firefly-iii/vendor/symfony/console/Application.php(1094): Illuminate\Console\Command->run()
#40 /var/www/firefly-iii/vendor/symfony/console/Application.php(342): Symfony\Component\Console\Application->doRunCommand()
#41 /var/www/firefly-iii/vendor/symfony/console/Application.php(193): Symfony\Component\Console\Application->doRun()
#42 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#43 /var/www/firefly-iii/artisan(35): Illuminate\Foundation\Console\Kernel->handle()
#44 {main}

[previous exception] [object] (PDOException(code: 42S01): SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists at /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php:571)
[stacktrace]
#0 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(571): PDOStatement->execute()
#1 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(812): Illuminate\Database\Connection->{closure:Illuminate\Database\Connection::statement():560}()
#2 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(779): Illuminate\Database\Connection->runQueryCallback()
#3 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Connection.php(560): Illuminate\Database\Connection->run()
#4 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Schema/Blueprint.php(118): Illuminate\Database\Connection->statement()
#5 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(564): Illuminate\Database\Schema\Blueprint->build()
#6 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php(418): Illuminate\Database\Schema\Builder->build()
#7 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(361): Illuminate\Database\Schema\Builder->create()
#8 /var/www/firefly-iii/database/migrations/2016_06_01_000001_create_oauth_auth_codes_table.php(14): Illuminate\Support\Facades\Facade::__callStatic()
#9 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(476): Illuminate\Database\Migrations\Migration@anonymous->up()
#10 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(401): Illuminate\Database\Migrations\Migrator->runMethod()
#11 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(410): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runMigration():397}()
#12 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\Database\Migrations\Migrator->runMigration()
#13 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/View/Components/Task.php(40): Illuminate\Database\Migrations\Migrator->{closure:Illuminate\Database\Migrations\Migrator::runUp():213}()
#14 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(737): Illuminate\Console\View\Components\Task->render()
#15 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(213): Illuminate\Database\Migrations\Migrator->write()
#16 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(180): Illuminate\Database\Migrations\Migrator->runUp()
#17 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(123): Illuminate\Database\Migrations\Migrator->runPending()
#18 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(116): Illuminate\Database\Migrations\Migrator->run()
#19 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Migrations/Migrator.php(616): Illuminate\Database\Console\Migrations\MigrateCommand->{closure:Illuminate\Database\Console\Migrations\MigrateCommand::runMigrations():109}()
#20 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(109): Illuminate\Database\Migrations\Migrator->usingConnection()
#21 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Database/Console/Migrations/MigrateCommand.php(88): Illuminate\Database\Console\Migrations\MigrateCommand->runMigrations()
#22 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\Database\Console\Migrations\MigrateCommand->handle()
#23 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#24 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#25 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#26 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\Container\BoundMethod::call()
#27 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#28 /var/www/firefly-iii/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute()
#29 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#30 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(68): Illuminate\Console\Command->run()
#31 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Concerns/CallsCommands.php(29): Illuminate\Console\Command->runCommand()
#32 /var/www/firefly-iii/vendor/laravel/passport/src/Console/InstallCommand.php(45): Illuminate\Console\Command->call()
#33 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Laravel\Passport\Console\InstallCommand->handle()
#34 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Util.php(43): Illuminate\Container\BoundMethod::{closure:Illuminate\Container\BoundMethod::call():35}()
#35 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(95): Illuminate\Container\Util::unwrapIfClosure()
#36 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\Container\BoundMethod::callBoundMethod()
#37 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Container/Container.php(694): Illuminate\Container\BoundMethod::call()
#38 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(213): Illuminate\Container\Container->call()
#39 /var/www/firefly-iii/vendor/symfony/console/Command/Command.php(279): Illuminate\Console\Command->execute()
#40 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Console/Command.php(182): Symfony\Component\Console\Command\Command->run()
#41 /var/www/firefly-iii/vendor/symfony/console/Application.php(1094): Illuminate\Console\Command->run()
#42 /var/www/firefly-iii/vendor/symfony/console/Application.php(342): Symfony\Component\Console\Application->doRunCommand()
#43 /var/www/firefly-iii/vendor/symfony/console/Application.php(193): Symfony\Component\Console\Application->doRun()
#44 /var/www/firefly-iii/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(198): Symfony\Component\Console\Application->run()
#45 /var/www/firefly-iii/artisan(35): Illuminate\Foundation\Console\Kernel->handle()
#46 {main}
"}

Illuminate\Database\QueryException

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists (Connection: mysql, SQL: create table oauth_auth_codes (id varchar(100) not null, user_id bigint unsigned not null, client_id bigint unsigned not null, scopes text null, revoked tinyint(1) not null, expires_at datetime null, primary key (id)) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB)

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/2016_06_01_000001_create_oauth_auth_codes_table.php:14
Illuminate\Support\Facades\Facade::__callStatic()
+36 vendor frames

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

Then to finish I configured .env

cp .env.example .env php artisan key:generate php artisan migrate --seed php artisan firefly-iii:upgrade-database php artisan passport:install php artisan cache:clear
In the storage/logs there are two files:

[2025-01-26 14:03:37] local.ERROR: Exception is: {"class":"Illuminate\View\ViewException","errorMessage":"Vite manifest not found at: >[2025-01-26 14:03:37] local.ERROR: Exception is: {"class":"ErrorException","errorMessage":"file_put_contents(/var/www/firefly-iii/sto>

[2025-01-26 14:02:13] local.ERROR: Could not execute query (table "journal_meta", field "data"): SQLSTATE[42000]: Syntax error or access >[2025-01-26 14:02:13] local.ERROR: If the index already exists (see error), or if MySQL can't do it, this is not an problem. Otherwise, p>[2025-01-26 14:02:23] local.ERROR: Exception is: {"class":"Illuminate\Database\QueryException","errorMessage":"SQLSTATE[42S01]: Base ta>[2025-01-26 14:02:23] local.ERROR: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'oauth_auth_codes' already exists (Conn>