HTTP 500 Error After Update

AMConsulting

I ran an update from the GUI. Immediately thereafter, I lost the ability to login with an HTTP 500 Error. I've attempted to follow some of the other instructions in the forum but without success. I also can't SSH in via Putty. I'm hosting with OVH.

On the KVM, I'm seeing a number of uncaught mysqlisqlexception: Unknown column 'user_type' in 'where clause' in /var/www/…../login.php(106)

Could the update have corrupted something? Is there a way to roll back?

Bigbug

AMConsulting I'm also using OVH (cheers!) I'm using their VPS and you should be able to login via their integrated VNC/KVM or SSH, unless you use shared hosting or something like that which is NOT recommended

johnny

Try to request shell access from your hosting provider and run update_cli.php from the command line.

You are absolutely going to need shell access for the future for some updates

AMConsulting

johnny I have KVM access. Where do I find the update_cli.php file? The KVM screen with OVH is very small (I don't see an option change the size.

Thanks!

AMConsulting

Bigbug Thanks for the reply. I opened a ticket with them and was able to find the KVM. I can't find the file referenced above for update_cli.php.

wrongecho

To clarify, ITFlow won't be affecting your SSH access. ITFlow is just a PHP application running on Apache/Nginx.

The updatecli.php will be in the web root at /var/www/itflow.example.com (soon to be moved to the scripts sub-directory)

AMConsulting

wrongecho

When I run it, it tells me "Already up to date".

bc417b7c..0cb3cdc2 develop origin/develop

new branch new-admin-check origin/new-admin-check

new branch stripe-autopay origin/stripe-autopay

Same 500 error.

wrongecho

Run it again with the --update_db flag as well?

AMConsulting

Thanks! That solved the problem. I was on version 1.4.4. I had to repeat that for each version until 1.7.5.

I appreciate all the help here. I'm a Windows guy and this is a good learning experience. I also will try to backup more frequently.

Bigbug

AMConsulting I was also a total noob around here being a Windows guy… by the time i got the hang of it

tip: i learned linux (Debian) mostly from chatgpt… you just throw it any problem you have and it gives you the right code/answers right away

Alan

AMConsulting

Don't worry, you're not the only guy googling every Linux command…

wrongecho

Happy to help!

We've moved to monthly-ish release cycles now so just try and check around the start of each month to see what's changed, but I totally get it's never high on the list of things to do 🙂

AMConsulting

Bigbug I don't know about that. Last time ChatGPT and I spoke, it told me to find a kid named John Conner and terminate him. :-D

Thanks for the advice. Next time I'm stuck I'll try it.

magixnetworks

I use Linux commands on a pretty daily basis and still find the need to whip out some Google-Fu quite often. Don't need to retain this information when it's so easy to just find online