Update Seemingly fails - HTTP 500

ruachta

Hello,

I let my system run out of date for some time. The oldest is 2b2840a4 in the update list. In the past I have not had issues running updates.

When I hit the update button, I am brought to the login page, and get the 500 code when I try and login. I reverted to a checkpoint and attempted the force update app button with the same result.

It's an install on Ubuntu which used the installation script. Not sure what logs would be most beneficial to troubleshoot this. Some details from the debug page.

Operating System: Linux homeitflow 5.15.0-133-generic #144-Ubuntu SMP Fri Feb 7 20:47:38 UTC 2025 x86_64

App Version: 4963f2f3853475b9caa4a4266ccedd96244ee648

PHP version: 8.1.2-1ubuntu2.20

Database Version: 5.5.5-10.6.18-MariaDB-0ubuntu0.22.04.1 / 100618

ruachta

Found the reference to troubleshooting in the docs. This is the last line of the tail output

[Wed Feb 26 01:54:51.574445 2025] [php:warn] [pid 834] [client 192.168.0.97:62359] PHP Warning: Undefined variable $largest_income_month in /var/www/itflow.mydomain.com/dashboard.php on line 871, referer: https://itflow.mydomain.com/

[Wed Feb 26 02:19:53.840288 2025] [php:warn] [pid 837] [client 192.168.0.97:49202] PHP Warning: Undefined array key "last_visited" in /var/www/itflow.mydomain.com/login.php on line 222, referer: https://itflow.mydomain.com/login.php

[Wed Feb 26 02:21:10.785676 2025] [mpm_prefork:notice] [pid 785] AH00170: caught SIGWINCH, shutting down gracefully

[Wed Feb 26 02:22:05.342582 2025] [mpm_prefork:notice] [pid 790] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations

[Wed Feb 26 02:22:05.344910 2025] [core:notice] [pid 790] AH00094: Command line: '/usr/sbin/apache2'

[Wed Feb 26 02:24:27.982305 2025] [php:warn] [pid 803] [client 192.168.0.97:49445] PHP Warning: Undefined variable $largest_income_month in /var/www/itflow.mydomain.com/dashboard.php on line 871, referer: https://itflow.mydomain.com/

Updating files: 100% (5089/5089), done.

[Wed Feb 26 02:42:22.787024 2025] [php:warn] [pid 802] [client 192.168.0.97:50066] PHP Warning: Undefined variable $comments in /var/www/itflow.mydomain.com/post/admin_update.php on line 206, referer: https://itflow.mydomain.com/admin_update.php

[Wed Feb 26 02:42:24.255186 2025] [php:warn] [pid 802] [client 192.168.0.97:50066] PHP Warning: Undefined array key "user_type" in /var/www/itflow.mydomain.com/check_login.php on line 31, referer: https://itflow.mydomain.com/admin_update.php

[Wed Feb 26 02:42:34.249327 2025] [php:error] [pid 1165] [client 192.168.0.97:50079] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where clause' in /var/www/itflow.mydomain.com/login.php:106\nStack trace:\n#0 /var/www/itflow.mydomain.com/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/itflow.mydomain.com/login.php on line 106, referer: https://itflow.mydomain.com/login.php

ruachta

Fresh logs after a reboot and attempting to log on

[Wed Feb 26 02:59:10.897229 2025] [mpm_prefork:notice] [pid 790] AH00170: caught SIGWINCH, shutting down gracefully

[Wed Feb 26 02:59:11.178508 2025] [mpm_prefork:notice] [pid 2097] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations

[Wed Feb 26 02:59:11.178622 2025] [core:notice] [pid 2097] AH00094: Command line: '/usr/sbin/apache2'

[Wed Feb 26 02:59:25.604323 2025] [php:warn] [pid 2099] [client 192.168.0.97:50708] PHP Warning: Undefined array key "user_type" in /var/www/itflow.mydomain.com/check_login.php on line 31

[Wed Feb 26 02:59:27.111376 2025] [php:error] [pid 2099] [client 192.168.0.97:50708] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where clause' in /var/www/itflow.mydomain.com/login.php:106\nStack trace:\n#0 /var/www/itflow.mydomain.com/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/itflow.mydomain.com/login.php on line 106, referer: https://itflow.mydomain.com/login.php

[Wed Feb 26 02:59:35.943580 2025] [mpm_prefork:notice] [pid 2097] AH00170: caught SIGWINCH, shutting down gracefully

[Wed Feb 26 03:00:20.486601 2025] [mpm_prefork:notice] [pid 789] AH00163: Apache/2.4.52 (Ubuntu) OpenSSL/3.0.2 configured -- resuming normal operations

[Wed Feb 26 03:00:20.488947 2025] [core:notice] [pid 789] AH00094: Command line: '/usr/sbin/apache2'

[Wed Feb 26 03:02:11.367605 2025] [php:error] [pid 803] [client 192.168.0.97:50820] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where clause' in /var/www/itflow.mydomain.com/login.php:106\nStack trace:\n#0 /var/www/itflow.mydomain.com/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/itflow.mydomain.com/login.php on line 106, referer: https://itflow.mydomain.com/login.php

Bigbug

Run the CLI update script, I think it is in the /scripts dir

ruachta

Bigbug

Thanks, I am really not well versed in the CLI side of this setup. Where would I find and run the script. I see on the update guide it indicates "at the CLI using update_cli.php" unfortunately I am not familiar with running .php scripts.

ruachta

Figured it out ran update_cli.php using sudo -u www-data php update_cli.php and get

Already up to date.

ruachta

When I revert my checkpoint, I no longer have a scripts directory. Is the cli update in a different directory on the older versions?

Bigbug

ruachta Is the cli update in a different directory on the older versions?

cli update is a new thing

johnny

once you run sudo -u www-data php update_cli.php you then need to run sudo -u www-data php updatecli.php --update_db Keep running it until theres no more database updates left

ruachta

johnny Thanks this worked. I am now updated and able to login.

Thanks for everything you do!

johnny

Note in the next major update, I will combine them so it will be a one command to update from the cli instead of 2