I can't login

AlexSela

Hi everyone, I don’t understand. This morning, I tried to log in to ITFLOW. I entered my username and password, and immediately I got a 500 error… Any idea what’s going on?

AlexSela

PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where clause' in /var/www/

Bigbug

give us more info like how you installed itflow and what OS you're running and any relevant details so we can try to troubleshoot

AlexSela

Bigbug Sorry, it’s true that the information is a bit short. I’m running Ubuntu 22.04 LTS on a VPS hosted by IONOS. Until yesterday, everything was working perfectly. Today, I simply tried to connect, and while I do get the login page, I then encounter a 505 error. The only log I’ve found so far is the one I’ve already shared with you. Could you let me know how I can provide you with more relevant details?

wrongecho

AlexSela

It sounds to me like you ran file updates without the database updates.

Try temporarily replacing login.php with this version and seeing if that let's you login enough to run updates: itflow-org/itflowblob/19dc33a836bf64a0efa4fca971b71089ff478828/login.php

AlexSela

wrongecho Cool, I replaced it, but when I enter my credentials and password, the page refreshes, and the fields become empty again. Normally, the MFA process kicks in at this point. Do you need to check the Apache logs? Or alternatively, is it possible to restore a full backup and start fresh?

wrongecho

Check out this post, you need to temporarily replace check_login.php too until you run the database updates in Settings > Update:

https://forum.itflow.org/d/1338-login-error-after-update/4

Alternatively you could try restoring the file system from a backup, assuming you took one prior to updating.

AlexSela

wrongecho So, I removed the login check, but I made a mistake—I forgot to back it up beforehand and ended up overwriting the file. Any idea how I can restore what I had set up?

wrongecho

The latest will be here: itflow-org/itflowblob/master/check_login.php

Or you can force a git pull after the database updates and it'll download the latest

AlexSela

wrongecho I tested and replaced the check login file. But when I do that, I encounter the same issue as before: the page refreshes, and the fields are empty.

wrongecho

Did you update your database when you were able to login using the old file version?

AlexSela

wrongecho Yes sir !

wrongecho

To what version?

AlexSela

wrongecho I deleted the check login file to try logging in again… it still doesn’t work. I managed to back up the database, so I think I’ll start from scratch—it will probably save me time.