Greetings,
we’re running Invoice Ninja 5.3 on a virtual Debian server, Stretch 9.13, with latest updates/patches, PHP 7.4, MariaDB. Invoice Ninja 5.3.10 was running flawlessly until I updated to 5.3.15 today. Since then I get 500: Server Error on Login. There is no error in Apache2’s error log, nothing in laravel.log, but Google Chrome’s Console shows exceptions even when I tab between email and password fields.
Clicking on login comes 500: Server Error on Login and the errors in the js (main.foss.dart.js?v=5.3.15:73970; iL:function(a,b){return a.send(b)},), see at the snapshot.
I chowned the permissions for www-data again, executed php artisan optimize, chowned permissions again, nothing works… Any idea?
Hello,
I have the same issue with Error500 after update to 5.3.15. I had to rollback to 5.3.10.
How can I run the command artisan migrate --force on a shared hosting without ssh access? Is there a preconfigured route?
@SchiffersHaar yes, my host ran all of the commands. I also just tried downloading a fresh copy of the files and uploading, still didn’t fix it… currently entirely broken.
Updated from 5.3.9 to 5.3.15 and also got an error after the update, after completing the “sudo -u www-data php artisan optimize”
Debug was turned on and got the following message after update, at first log in
The entire log message: 500: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘invoiceninja.recurring_expenses’ doesn’t exist (SQL: select * from recurring_expenses where recurring_expenses.company_id = 1 and recurring_expenses.company_id is not null)
Was able to correct the issue by running the modified command “sudo -u www-data php artisan migrate --force”
For reference, my production and test environment is Debian 10 server, PHP 8.0.10, MariaDB (current update), Apache 2 (current update)
The system now shows 5.3.16, not sure if this is the correct version number being displayed, logs show 5.3.15 is the current release ( at invoiceninja/storage/logs/laravel.log)
500: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bbcomputing_invnin.recurring_expenses' doesn't exist (SQL: select * from `recurring_expenses` where `recurring_expenses`.`company_id` = 1 and `recurring_expenses`.`company_id` is not null)
I’m unable to get the update to work either (500 server error).
For what it’s worth, I encountered a similar issue when I upgraded from 5.1.0 to 5.1.6. Manually running php artisan migrate as suggested above (but without --force in my case) worked.
worked for me too…smh…this thing is NOT STABE AT ALL…just glancing through invoice design causes error 500 and you cant safe any invoice or view in pdf format…
