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'

Write a Reply...