Web Server Software | Microsoft-IIS/8.5
MySQL | 10.3.14
PHP | 7.3.19
just moved from v1.10.7 to latest version 1.14.2
i'm testing all the stuff after the upgrade, now i'm unable to assign a ticket assigned to me to another operator
if a claim an unassigned ticket , i can assign it to other operators ... the problem seems only for ticket already assigned to me before the upgrade
problem is present for all operators , not only my account ...
this is the system log error entry
if i manually run the query on the db :
select * from ost_ticket WHERE 'ost_ticket'.'ticket_id' = 356716 LIMIT 1
i get the correct result with no erorrs
if i manually run the query
UPDATE ost_ticket SET staff_id = 2, updated = NOW() WHERE ost_ticket.ticket_id = 356716 LIMIT 1
got same error #1054
also many other #1054 errors are present in system logs, all updates that fails with "Unknow column 'state' in where clause'