Hi support,

osTicket v1.16.3 (e148727)
PHP 8.0.22
MySQL 5.5.62

I've installed osTicket v1.16 on a preproduction vm for testing and i'm encountering multiple error before making any customization.

This one is the most common:

[SELECT A1.`number` AS `number`,  A1.`ticket_id` AS `ticket_id`,  A1.`source` AS `source`,  A1.`lastupdate` AS `lastupdate`,  B2.`subject` AS `cdata__subject`,  A1.`isoverdue` AS `isoverdue`,  B4.`name` AS `user__name`,  B2.`priority` AS `cdata__priority`,  B5.`firstname` AS `staff__firstname`,  B5.`lastname` AS `staff__lastname`,  B6.`name` AS `team__name`,  A1.`team_id` AS `team_id`,  A1.`isanswered` = '0' AS `2GkBZxz`,  (SELECT COUNT(R0.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND NOT R0.`flags` & 4 != 0) AS _thread_count,  (SELECT COUNT(R1.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_entry` R0 ON (Q7.`id` = R0.`thread_id`) LEFT JOIN `ost_attachment` R1 ON (R1.`type` = 'H' AND R0.`id` = R1.`object_id`) WHERE Q8.`ticket_id` = A1.`ticket_id` AND R1.`inline` = 0) AS _att_count,  B7.`expire` > NOW() AND NOT B7.`staff_id` = 1 AS `_locked`,  (SELECT COUNT(R0.`id`) AS `count` FROM `ost_thread` Q7 JOIN `ost_ticket` Q8 ON (Q7.`object_type` = 'T' AND Q7.`object_id` = Q8.`ticket_id`) LEFT JOIN `ost_thread_collaborator` R0 ON (Q7.`id` = R0.`thread_id`) WHERE Q8.`ticket_id` = A1.`ticket_id`) AS _collabs,  COALESCE(B5.`firstname`,  B5.`lastname`,  B6.`name`,  'zzz') AS `assignee` FROM `ost_ticket` A1 JOIN `ost_ticket_status` A2 ON (A1.`status_id` = A2.`id`) LEFT JOIN `ost_thread` A3 ON (A3.`object_type` = 'T' AND A1.`ticket_id` = A3.`object_id`) LEFT JOIN `ost_thread_referral` A4 ON (A3.`id` = A4.`thread_id`) LEFT JOIN `ost_staff` A5 ON (A4.`object_type` = 'S' AND A4.`object_id` = A5.`staff_id`) LEFT JOIN `ost_thread` A6 ON (A1.`ticket_id` = A6.`object_id` AND A6.`object_type` = 'C') LEFT JOIN `ost_thread_referral` A7 ON (A6.`id` = A7.`thread_id`) LEFT JOIN `ost_staff` A8 ON (A7.`object_type` = 'S' AND A7.`object_id` = A8.`staff_id`) LEFT JOIN `ost_department` B0 ON (A4.`object_type` = 'D' AND A4.`object_id` = B0.`id`) LEFT JOIN `ost_department` B1 ON (A7.`object_type` = 'D' AND A7.`object_id` = B1.`id`) LEFT JOIN `ost_ticket__cdata` B2 ON (A1.`ticket_id` = B2.`ticket_id`) LEFT JOIN `ost_ticket_priority` B3 ON (B2.`priority` = B3.`priority_id`) LEFT JOIN `ost_user` B4 ON (A1.`user_id` = B4.`id`) LEFT JOIN `ost_staff` B5 ON (A1.`staff_id` = B5.`staff_id`) LEFT JOIN `ost_team` B6 ON (A1.`team_id` = B6.`team_id`) LEFT JOIN `ost_lock` B7 ON (A1.`lock_id` = B7.`lock_id`) WHERE A2.`state` = 'open' AND ((A2.`state` = 'open' AND (A1.`staff_id` = 1 OR A5.`staff_id` = 1 OR A6.`object_type` = 'C' AND A8.`staff_id` = 1)) OR A1.`dept_id` IN (1,  3) OR B0.`id` IN (1,  3) OR A6.`object_type` = 'C' AND B1.`id` IN (1,  3)) AND (A1.`ticket_pid` IS NULL OR A1.`flags` & 8 != 0) GROUP BY A1.`ticket_id` ORDER BY B3.`priority_urgency` ASC,  A1.`lastupdate` DESC LIMIT 25] 

Unknown column 'B2.priority' in 'field list'<br /> <br /> ---- Backtrace ----<br /> #0 C:\inetpub\wwwroot\osticket\include\mysqli.php(201): osTicket->logDBError('DB Error #1054',  '[SELECT A1.`num...')<br /> 

#1 C:\inetpub\wwwroot\osticket\include\class.orm.php(3468): db_query('SELECT A1.`numb...',  true,  true)<br /> 
#2 C:\inetpub\wwwroot\osticket\include\class.orm.php(3515): MySqlExecutor->execute()<br /> 
#3 C:\inetpub\wwwroot\osticket\include\class.orm.php(2095): MySqlExecutor->getArray()<br /> 
#4 C:\inetpub\wwwroot\osticket\include\class.orm.php(2045): HashArrayIterator->{closure}()<br /> 
#5 C:\inetpub\wwwroot\osticket\include\class.orm.php(2024): CallbackSimpleIterator->next()<br /> 
#6 C:\inetpub\wwwroot\osticket\include\class.orm.php(2033): CallbackSimpleIterator->rewind()<br /> 
#7 C:\inetpub\wwwroot\osticket\include\class.orm.php(1704): CallbackSimpleIterator->valid()<br /> 
#8 C:\inetpub\wwwroot\osticket\include\class.orm.php(1714): CachedResultSet->fillTo(9223372036854775807)<br /> 
#9 C:\inetpub\wwwroot\osticket\include\class.orm.php(1730): CachedResultSet->asArray()<br /> 
#10C:\inetpub\wwwroot\osticket\include\staff\templates\queue-tickets.tmpl.php(262): CachedResultSet->getIterator()<br /> 
#11 C:\inetpub\wwwroot\osticket\scp\tickets.php(565): require_once('C:\\inetpub\\wwwr...')<br /> 
#12 C:\inetpub\wwwroot\osticket\scp\index.php(17): require('C:\\inetpub\\wwwr...')<br /> #13 {main}

Unknown column 'priority' in 'field list? how is that even possible in a fresh install?

Hope, someone can help me, cheers!

    Write a Reply...