Firefly III: A personal finances manager
-
@timbo Yes, I was just updating the package adding the popular locales.
-
-
@timbo The locales have to be installed in the app package and not on the server. I just pushed the update now (package version 1.1.0). Can you try on that? Just install a new ff to get the latest package or updates -> check for updates.
-
@girish It seems there is still an error in this app.
After adding a recurring transaction, the UI shows the following warning:
Message: It seems the cron job that is necessary to support recurring transactions has never run. This is of course normal when you have just installed Firefly III, but this should be something to set up as soon as possible. Please check out the help-pages using the (?)-icon in the top right corner of the page.
After looking into it, I found that the cron job is added in the
CloudronManifest.json
file. But looking in the application logs, showed nothing about that task actually being run.So I opened the console, and ran the command manually:
sudo -u www-data php /app/code/artisan firefly-iii:cron
This resulted in an error. Instead of pasting the gigantic stack trace, let me summarize it:
[2020-02-08 00:24:14] local.ERROR: SQLSTATE[08006] [7] invalid port number: "${CLOUDRON_POSTGRESQL_PORT}" (SQL: select * from "recurrences" where "recurrences"."deleted_at" is null order by "active" desc, "title" asc) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 7): SQLSTATE[08006] [7] invalid port number: \"${CLOUDRON_POSTGRESQL_PORT}\" (SQL: select * from \"recurrences\" where \"recurrences\".\"deleted_at\" is null order by \"active\" desc, \"title\" asc) at /app/code/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669) [stacktrace cut] [previous exception] [object] (Doctrine\\DBAL\\Driver\\PDOException(code: 7): SQLSTATE[08006] [7] invalid port number: \"${CLOUDRON_POSTGRESQL_PORT}\" at /app/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:31) [stacktrace cut] [previous exception] [object] (PDOException(code: 7): SQLSTATE[08006] [7] invalid port number: \"${CLOUDRON_POSTGRESQL_PORT}\" at /app/code/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:27) [stacktrace cut]
Any idea why this fails?
-
Looks like the sudo is missing
-E
. I will update the package. -
@jk Pushed an update now to fix it.
-
@timbo Not yet, can you create an issue at https://git.cloudron.io/cloudron/firefly-iii-app ?
-