I upgraded osTicket from ver. 1.10.4 to 1.11 on our test environment and I am now getting DB Error #1176 which says:
[SELECT ticket_id FROM ost_ticket T1 USE INDEX (status_id) INNER JOIN ost_ticket_status status
ON (status.id=T1.status_id AND status.state="open") LEFT JOIN ost_sla T2 ON (T1.sla_id=T2.id AND T2.flags & 1 = 1) WHERE isoverdue=0 AND ((reopened is NULL AND duedate is NULL AND TIME_TO_SEC(TIMEDIFF(NOW(),T1.created))>=T2.grace_period3600) OR (reopened is NOT NULL AND duedate is NULL AND TIME_TO_SEC(TIMEDIFF(NOW(),reopened))>=T2.grace_period3600) OR (duedate is NOT NULL AND duedate<NOW()) ) ORDER BY T1.created LIMIT 50]
Key 'status_id' doesn't exist in table 'T1'<br /> <br />
---- Pogled nazaj ----<br />
#0 C:\inetpub\wwwroot\OSTICKET\include\mysqli.php(199): osTicket->logDBError('DB Error #1176', '[SELECT ticket_...')<br />
#1 C:\inetpub\wwwroot\OSTICKET\include\class.ticket.php(4209): db_query('SELECT ticket_i...')<br />
#2 C:\inetpub\wwwroot\OSTICKET\include\class.cron.php(30): Ticket::checkOverdue()<br />
#3 C:\inetpub\wwwroot\OSTICKET\scp\autocron.php(62): Cron::TicketMonitor()<br />
#4 {main}
Is anyone familiar with this problem and already found a solution?
Our system:
osTicket verzija v1.11 (d4e240b)
Web Server software Microsoft-IIS/10.0
MySQL verzija 8.0.11
PHP verzija 7.2.2
