Hello,
when I try to view task, list is empty, and it log DB Error #1054:
DB Error #1054
[SELECT A1.id AS id, A1.number AS number, A1.created AS created, A1.staff_id AS staff_id, A1.team_id AS team_id, A4.firstname AS staff__firstname, A4.lastname AS staff__lastname, A5.name AS team__name, A6.name AS dept__name, A7.title AS cdata__title, A1.flags AS flags, A2.number AS ticket__number, A2.ticket_id AS ticket__ticket_id, COUNT(DISTINCT B0.thread_id) AS collab_count, COUNT(DISTINCT CASE WHEN B2.inline THEN NULL ELSE B2.object_id END) AS attachment_count, COUNT(DISTINCT CASE WHEN B1.flags & 4 != 0 THEN NULL ELSE B1.id END) AS thread_count FROM ost_task A1 LEFT JOIN ost_ticket A2 ON (A1.object_id = A2.ticket_id) LEFT JOIN ost_ticket_status A3 ON (A2.status_id = A3.id) LEFT JOIN ost_staff A4 ON (A1.staff_id = A4.staff_id) LEFT JOIN ost_team A5 ON (A1.team_id = A5.team_id) JOIN ost_department A6 ON (A1.dept_id = A6.id) JOIN ost_task__cdata A7 ON (A1.id = A7.task_id) JOIN ost_thread A8 ON (A1.id = A8.object_id AND A8.object_type = 'A') LEFT JOIN ost_thread_collaborator B0 ON (A8.id = B0.thread_id) LEFT JOIN ost_thread_entry B1 ON (A8.id = B1.thread_id) LEFT JOIN ost_attachment B2 ON (B2.type = 'H' AND B1.id = B2.object_id) WHERE A1.flags & 1 != 0 AND ((A1.flags & 1 != 0 AND A1.staff_id = 2) OR (A2.staff_id = 2 AND A3.state = 'open') OR A1.dept_id IN (1) OR (A1.team_id IN (1) AND A1.flags & 1 != 0)) GROUP BY A1.id ORDER BY A1.created DESC] Unknown column 'A7.title' in 'field list'
---- Backtrace ----
#0 (root)/include/mysqli.php(201): osTicket->logDBError('DB Error #1054', '[SELECT A1.id...')
#1 (root)/include/class.orm.php(3466): db_query('SELECT A1.id ...', true, true)
#2 (root)/include/class.orm.php(3513): MySqlExecutor->execute()
#3 (root)/include/class.orm.php(2093): MySqlExecutor->getArray()
#4 (root)/include/class.orm.php(2043): HashArrayIterator->{closure}()
#5 (root)/include/class.orm.php(2022): CallbackSimpleIterator->next()
#6 (root)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()
#7 (root)/include/class.orm.php(1703): CallbackSimpleIterator->valid()
#8 (root)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)
#9 (root)/include/class.orm.php(1729): CachedResultSet->asArray()
#10 (root)/include/staff/tasks.inc.php(368): CachedResultSet->getIterator()
#11 (root)/scp/tasks.php(257): require_once('/var/www/ostick...')
#12 {main}
osTicket Version v1.15.2 (cb6766e)
Web Server Software Apache
MySQL Version 10.3.29
PHP Version 7.3.29-1deb10u1
