[billing@saad logs]$ tail -f invoiceninja.log
[2022-11-17 06:00:02] production.INFO: 0 partial invoices to auto bill
[2022-11-17 06:00:02] production.INFO: 0 full invoices to auto bill
[2022-11-17 06:00:03] production.INFO: Sending invoice reminders 2022-11-17 06:00:03
after update I run this command:
php artisan optimize
php artisan migrate
composer install -o --no-dev
88 packages you are using are looking for funding.
Use the composer fund command to find out more!
[billing@saad logs]$ tail -f invoiceninja.log
[2022-11-17 06:00:02] production.INFO: 0 partial invoices to auto bill
[2022-11-17 06:00:02] production.INFO: 0 full invoices to auto bill
[2022-11-17 06:00:03] production.INFO: Sending invoice reminders 2022-11-17 06:00:03
Could this be the reason?
When the installation is on a subdomain like business.example.com it is neccessary to adjust the .htaccess-Files after the update. I have had also this Error 500 and fixed it with that…
<IfModule mod_rewrite.c>
<IfModule mod_negotiation.c>
Options -MultiViews -Indexes
</IfModule>
RewriteEngine On
# Make InvoiceNinja work with subdomains:
# If you want to access InvoiceNinja via a subdomain and
# this rule is missing the browser will see a `500 internal server error`.
RewriteBase /
# Handle Authorization Header
RewriteCond %{HTTP:Authorization} .
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]
# Redirect Trailing Slashes If Not A Folder...
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} (.+)/$
RewriteRule ^ %1 [L,R=301]
# Handle Front Controller...
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION billing.json_unquote does not exist (SQL: select json_unquote(json_extract(settings, ‘$.“currency_id”’)) as id from clients)