I recently upgraded my osTicket from 1.17.2 to 1.18.1. After the upgrade my Open queue is completely empty, and doesn't display properly.
If I navigate to Closed tickets all of my tickets are present. This also allows me to see the Open menu properly, when I can select a saved search and see the results correctly, though I still can't see any results under the open queue itself.
I also tried an upgrade to 1.17.5 and encountered the same exact issue. I've tried everything I can find from the boards but haven't had any luck. Below is the error I receive in my logs any time I try to load the open queue:
[Sat Jun 08 09:28:03.494270 2024] [php:error] [pid 55200] [client 10.222.30.196:65286] PHP Fatal error: Uncaught InconsistentModelException: Unable to prepare query: Got error 'repetition-operator operand invalid' from regexp SELECT A1.numberASnumber, A1.ticket_idASticket_id, A1.sourceASsource, A1.lastupdateASlastupdate, B4.subjectAScdatasubject, A1.isoverdueASisoverdue, B6.nameASusername, A2.idASstatusid, B7.firstnameASstafffirstname, B7.lastnameASstafflastname, B8.nameASteamname, A1.team_idASteam_id, B4.priorityREGEXP '\\"?(?<![0-9])3(\\"|,|$)|\\"?(?<![0-9])4(\\"|,|$)' ASs5ovbjX, A1.topic_id= 26 ASWGrFZrb, A1.sourceREGEXP '\\"?(?<![0-9])Web(\\"|,|$)' ASRxIBMem, A2.idIN (2) ASuMqZh7R, A1.topic_id= 28 ASGZbSBVH, A1.isanswered= '0' AS2GkBZxz, (SELECT COUNT(R0.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) WHERE Q8.ticket_id= A1.ticket_idAND NOT R0.flags& 4 != 0) AS _thread_count, (SELECT COUNT(R1.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_entryR0 ON (Q7.id= R0.thread_id) LEFT JOINost_attachmentR1 ON (R1.type= 'H' AND R0.id= R1.object_id) WHERE Q8.ticket_id= A1.ticket_idAND R1.inline= 0) AS _att_count, C0.expire> NOW() AND NOT C0.staff_id= 2 AS_locked, (SELECT COUNT(R0.id) AScountFROMost_threadQ7 JOINost_ticketQ8 ON (Q7.object_type= 'T' AND Q7.object_id= Q8.ticket_id) LEFT JOINost_thread_collaboratorR0 ON (Q7.id= R0.thread_id) WHERE Q8.ticket_id= A1.ticket_id) AS _collabs, COALESCE(B7.firstname, B7.lastname, B8.name, 'zzz') ASassigneeFROMost_ticketA1 JOINost_ticket_statusA2 ON (A1.status_id= A2.id) LEFT JOINost_threadA3 ON (A3.object_type= 'T' AND A1.ticket_id= A3.object_id) LEFT JOINost_thread_referralA4 ON (A3.id= A4.thread_id) LEFT JOINost_staffA5 ON (A4.object_type= 'S' AND A4.object_id= A5.staff_id) LEFT JOINost_threadA6 ON (A1.ticket_id= A6.object_idAND A6.object_type= 'C') LEFT JOINost_thread_referralA7 ON (A6.id= A7.thread_id) LEFT JOINost_staffA8 ON (A7.object_type= 'S' AND A7.object_id= A8.staff_id) LEFT JOINost_teamB0 ON (A4.object_type= 'E' AND A4.object_id= B0.team_id) LEFT JOINost_teamB1 ON (A7.object_type= 'E' AND A7.object_id= B1.team_id) LEFT JOINost_departmentB2 ON (A4.object_type= 'D' AND A4.object_id= B2.id) LEFT JOINost_departmentB3 ON (A7.object_type= 'D' AND A7.object_id= B3.id) LEFT JOINost_ticket__cdataB4 ON (A1.ticket_id= B4.ticket_id) LEFT JOINost_ticket_priorityB5 ON (B4.priority= B5.priority_id) LEFT JOINost_userB6 ON (A1.user_id= B6.id) LEFT JOINost_staffB7 ON (A1.staff_id= B7.staff_id) LEFT JOINost_teamB8 ON (A1.team_id= B8.team_id) LEFT JOINost_lockC0 ON (A1.lock_id= C0.lock_id) WHERE A2.state= 'open' AND A2.state= 'open' AND A1.isanswered= '0' AND ((A2.state= 'open' AND (A1.staff_id= 2 OR A5.staff_id= 2 OR A6.object_type= 'C' AND A8.staff_id= 2 OR A1.team_idIN (1, 2, 5) OR B0.team_idIN (1, 2, 5) OR A6.object_type= 'C' AND B1.team_idIN (1, 2, 5))) OR A1.dept_idIN (1, 2) OR B2.idIN (1, 2) OR A6.object_type= 'C' AND B3.idIN (1, 2)) AND (A1.ticket_pidIS NULL OR A1.flags& 8 != 0) GROUP BY A1.ticket_idORDER BY B5.priority_urgencyASC, A1.lastupdateDESC LIMIT 25 in /var/www/html/helpdesknew/include/class.orm.php:3483\nStack trace:\n#0 /var/www/html/helpdesknew/include/class.orm.php(3529): MySqlExecutor->execute()\n#1 /var/www/html/helpdesknew/include/class.orm.php(2104): MySqlExecutor->getArray()\n#2 /var/www/html/helpdesknew/include/class.orm.php(2054): HashArrayIterator->{closure}()\n#3 /var/www/html/helpdesknew/include/class.orm.php(2033): CallbackSimpleIterator->next()\n#4 /var/www/html/helpdesknew/include/class.orm.php(2042): CallbackSimpleIterator->rewind()\n#5 /var/www/html/helpdesknew/include/class.orm.php(1713): CallbackSimpleIterator->valid()\n#6 /var/www/html/helpdesknew/include/class.orm.php(1723): CachedResultSet->fillTo()\n#7 /var/www/html/helpdesknew/include/class.orm.php(1739): CachedResultSet->asArray()\n#8 /var/www/html/helpdesknew/include/staff/templates/queue-tickets.tmpl.php(258): CachedResultSet->getIterator()\n#9 /var/www/html/helpdesknew/scp/tickets.php(569): require_once('...')\n#10 /var/www/html/helpdesknew/scp/index.php(17): require('...')\n#11 {main}\n thrown in /var/www/html/helpdesknew/include/class.orm.php on line 3483, referer: https://server/helpdesknew/scp/index.php
Any help would be appreciated.
