Hi,
We are currently trying to Update our osTicket to a newer version in our company.
Current Specifications:
osTicket-Version: v1.10.1
Server-Software: Apache/2.4.46 (Ubuntu)
MySQL-Version: 5.7.33
PHP Version: 5.6.40-43+ubuntu18.04.1+deb.sury.org+1
Every time we try to update it, using the update manuel,
we recive the Error attached:
osticket "add recipients field and collaboration flags" error upgrade
php fatal error inconsitentmodel exception osticket
Error SQL:
SELECT A1.id, A1.parent_id, A1.columns_id, A1.sort_id, A1.flags, A1.staff_id, A1.sort, A1.title, A1.config, A1.filter, A1.root, A1.path, A1.created, A1.updated, A2.id, A2.parent_id, A2.columns_id, A2.sort_id, A2.flags, A2.staff_id, A2.sort, A2.title, A2.config, A2.filter, A2.root, A2.path, A2.created, A2.updated FROM ost_queue A1 LEFT JOIN ost_queue A2 ON (A1.parent_id = A2.id) LEFT JOIN QUEUE_SORT_TABLE A3 ON (A1.sort_id = A3.id) WHERE A1.id = 1 ORDER BY A1.sort ASC LIMIT 0, 2
This happens while updating to version 14 and it also happens while trying to update to version 11.
Does anyone knows how to get rid of this error?
Thanks.
