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.

    Im not sure when they made it a requirement, but version 1.14 definitely requires PHP ver 7

    I did check the changelogs in advance and according to the changelogs both osTicket 11 and 14 support php 5.6

    Thought I saw where 14 it was a requirement. My mistake.

    nilmue
    you need to look at details of errors in PHP what's "error inconsitentmodel exception osticket" once you find that out, then you can fix that then try the upgrade again

    It could be PHP or a field you customized

    You can try to take a full backup of the current installation directory and database try upgrading PHP, then do an upgrade

      Write a Reply...