Internal 500 error after update

rlamb6412

Hello,

After updating my system i started getting an internal error 500. I have a snapshot backup that ive rolled back to. I can reproduce this error if i attempt to update the application.

Is there a way we can get it updated without rebuilding?

My ITFlow App version is 4f0e74520ceeac45771e946860d53499fa708701

The Apache log shows the following error:
[Fri Jan 03 10:12:34.673646 2025] [php:warn] [pid 586575:tid 586575] [client 10.100.101.53:61111] PHP Warning: Undefined variable $comments in /var/www/itflow. technologiksolutions.com/post/admin.php on line 1396, referer: https://itflow.te chnologiksolutions.com//admin_update.php

[Fri Jan 03 10:12:41.160587 2025] [php:warn] [pid 586575:tid 586575] [client 10.100.101.53:61111] PHP Warning: require_once(post/account.php): Failed to open stream: No such file or directory in /var/www/itflow.technologiksolutions.com/post.php on line 17, referer: https://itflow.technologiksolutions.com//admin_update.php

[Fri Jan 03 10:12:41.160831 2025] [php:error] [pid 586575:tid 586575] [client 10.100.101.53:61111] PHP Fatal error: Uncaught Error: Failed opening required 'post/account.php' (include_path='.:/usr/share/php') in /var/www/itflow.technologiksolutions.com/post.php:17\nStack trace:\n#0 {main}\n thrown in /var/www/itflow.technologiksolutions.com/post.php on line 17, referer: https://itflow.technologiksolutions.com//admin_update.php

[Fri Jan 03 10:12:41.244919 2025] [php:warn] [pid 586575:tid 586575] [client 10.100.101.53:61111] PHP Warning: Undefined array key "user_type" in /var/www/itflow.technologiksolutions.com/check_login.php on line 31, referer: https://itflow.technologiksolutions.com//admin_update.php

[Fri Jan 03 10:13:00.033304 2025] [php:error] [pid 586498:tid 586498] [client 10.100.101.53:61126] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_type' in 'where clause' in /var/www/itflow.technologiksolutions.com/login.php:106\nStack trace:\n#0 /var/www/itflow.technologiksolutions.com/login.php(106): mysqli_query()\n#1 {main}\n thrown in /var/www/itflow.technologiksolutions.com/login.php on line 106, referer: https://itflow.technologiksolutions.com/login.php

wrongecho

Hello,

You're over three months behind and a lot has changed!

I would suggest you update again to the latest version and fix the database. There is now a CLI database update tool in the root directory (/var/www/itflow.technolo….com/) which will take care of all the database changes you're missing.

It's here for reference: itflow-org/itflowblob/master/update_cli.php

Run it like:

sudo -u www-data php update_cli.php --update_db

rlamb6412

Thank you. I will give that a shot.

rlamb6412

Thanks that worked up to a specific point. Here is a new error i'm getting now when i try to update.

PHP Fatal error: Uncaught mysqli_sql_exception: Truncated incorrect INTEGER value: 'Assigned' in /var/www/itflow.technologiksolutions.com/database_updates.php:2117

Stack trace:

#0 /var/www/itflow.technologiksolutions.com/database_updates.php(2117): mysqli_query()

#1 /var/www/itflow.technologiksolutions.com/update_cli.php(117): require_once('...')

#2 {main}

thrown in /var/www/itflow.technologiksolutions.com/database_updates.php on line 2117

root@tek-itflow:/var/www/itflow.technologiksolutions.com# sudo -u www-data php update_cli.php --update_db

Column 'login_folder_id' already exists in the 'logins' table.PHP Fatal error: Uncaught mysqli_sql_exception: Truncated incorrect INTEGER value: 'Assigned' in /var/www/itflow.technologiksolutions.com/database_updates.php:2117

Stack trace:

#0 /var/www/itflow.technologiksolutions.com/database_updates.php(2117): mysqli_query()

#1 /var/www/itflow.technologiksolutions.com/update_cli.php(117): require_once('...')

#2 {main}

thrown in /var/www/itflow.technologiksolutions.com/database_updates.php on line 2117

root@tek-itflow:/var/www/itflow.technologiksolutions.com#

wrongecho

rlamb6412

This would be due to custom ticket states. They should all be numbers now but it seems you have some text instead.

See https://forum.itflow.org/d/1248-bug-unable-to-update-database/26

rlamb6412

i'll delete the tickets, we were testing this but did not use it. I'll report back and let you know if that does it.

rlamb6412

Deleting was not an option or I couldn't find it. So instead, i marked all of the tickets as resolved and i was able to update the app. Thank you for your assistance.

wrongecho

You're welcome, nice work!