I have been on v5.3.71-W85 for quite sometime now and I have had issued with updates in the past so I figured I would wait for a while before upgrading to ensure that the updates are a bit more stable.
However, my production instance ran into trouble once again today when I upgraded from v5.3.71-W85 to v5.4.4 (through the prompt in the app), after which the app stopped working or responding, so I closed it and reopened it and it just kept loading. I then opened a web browser and visited the site and logged in. As soon as I hit enter, I see the â500: Server Errorâ error, as seen below:
Hi hillel,
Thanks for the super fast response!
Iâm afraid there are only two files in the logs folder, being .gitignore and laravel.log, and on inspecting laravel.log, the only two lines pertaining to todayâs date (date of update) are:
[2022-06-20 00:00:04] production.INFO: updating currencies
[2022-06-20 06:00:03] production.INFO: Performing Autobilling 2022-06-20 06:00:03
Have the same problem.
With debug set to true, the login page now displays the following error below the Secret (Optional) field:
500: SQLSTATE[42S02]: Base table or view not found: 1146 Table âninja.purchase_ordersâ doesnât exist (SQL: select * from purchase_orders where purchase_orders.company_id in (2) and created_at >= 1970-01-01 00:00:00)
The laravel.log doesnât show anything additional to âUpdating currenciesâ and âPerforming Autobillingâ
I wrote a little update bash script a while back that basically replaces all the files with new ones and then just runs php artisan optimize, which worked up to this point.
Wasnât aware of the migrate command, which Iâve now added to my script.