HTTP 500 Error Post Update - PHP Fatal error: Uncaught mysqli_sql_exception:

Doubleclic32

Following an update of the ITFLOW application, we can no longer connect after typing the username and password on ITFLOW. Here is the PHP error message:

PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where clause' in /var/www/itflow.double-clic.eu/login.php:106\nStack trace:\n#0 /var/www/itflow.double-clic.eu/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/itflow.double-clic.eu/login.php on line 106, referer: https://itflow.double-clic.eu/login.php

Anyone have any ideas please?

wrongecho

Doubleclic32

You're missing the latest database update.

Replace login.php with this version and so you can login and run DB updates. Then do a git pull to sync yourself up afterwards.

Doubleclic32

Thank you very much for the help, at the dashboard level I can no longer access anything (see screenshot)

wrongecho

Can you navigate directly to /admin_update.php ?

Doubleclic32

the same thing no access

johnny

hey @Doubleclic32 can you restore from last known good backup (VM Snapshot)

Then Update then update the database don't logout