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?

    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 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 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!

            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.

              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)

                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.

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

                  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.

                    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 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

                        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.

                          AMConsulting

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

                            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