Multiple SQL issues after update causing error 500 pages

litechforce

How did you "roll back"?

johnny

Typically through a Virtual Machine Snapshot of backup.

We use Proxmox as our hypervisor Before we update we take a snapshot which takes roughly a few seconds. This can be done with other hypervisors as well XCP-NG, Hyper V and VMWare.

Excellent write up @Wikiphil

litechforce

johnny

I use proxmox as well. I just restored the VM again, and re-ran the update_cli

and the updatecli --updatedb again until it said there were no more updates.

Still having the same problem

litechforce

This is the php error I am currently getting while trying to assign a ticket:

[Sun Mar 30 17:38:01.919900 2025] [php:error] [pid 1057] [client 192.168.4.5:59075] PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'user_settings.user_role' in 'where clause' in /var/www/portal.litechforce.com/post/user/ticket.php:579\nStack trace:\n#0 /var/www/portal.litechforce.com/post/user/ticket.php(579): mysqli_query()\n#1 /var/www/portal.litechforce.com/post.php(49): require_once('...')\n#2 {main}\n thrown in /var/www/portal.litechforce.com/post/user/ticket.php on line 579, referer: https://portal.litechforce.com/ticket.php?ticket_id=69

johnny

ah I see Its when you assign a tech, i was able to replicate thanks for that info I just pushed out a fix to the develop branch will push out a hotfix tommarow

litechforce

johnny

Thank you! I was worried I really fouled something up!

johnny

hahaha nope it woulda helped if I read further because you did mention assigning your self a ticket.

qduchenne

Nearly on time for an April fool ! xD
The command update did the trick for me 🙂

litechforce

Just tried to do the php update_cli.php command again. Here is the output:

root@portal:/var/www/portal.litechforce.com/scripts# sudo -u www-data php update_cli.php
From https://github.com/itflow-org/itflow
 * [new branch]        fix-users          -> origin/fix-users
 * [new branch]        recurring-invoices -> origin/recurring-invoices
Already up to date.
root@portal:/var/www/portal.litechforce.com/scripts# sudo -u www-data php update_cli.php --update_db
Database is already at the latest version (2.1.2). No updates were applied.
root@portal:/var/www/portal.litechforce.com/scripts#

Tried assigning a ticket to myself again - same problem

johnny

@litechforce we fixed the bug to assign tickets in develop will be out soon

litechforce

johnny

Thank you so much!

litechforce

johnny

Just curious, when will the hotfix go out?

PatrickM

Thanks I was just about to report assigning a tech having an issue, if as a tech I create the ticket I am good.

Otherwise upgrade went good thanks for your efforts.

Lee

Would there perhaps be a fix without restoring a backup? I currently don't have one and did the upgrade via GUI yesterday.

johnny

@litechforce possibly today or tomorrow, we got a few more fixes on the way reported from users.

@Lee try the command line anyway see if it works.

johnny

We just released a hot fix that fixes these issues:

https://forum.itflow.org/d/1703-25033-hotfix-release

Lee

Thanks the cli worked for me.

First ran "sudo -u www-data php update_cli.php" then "sudo -u www-data php updatecli.php --update_db" until it was at the latest version. All working now.

« Previous Page