[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 imagenet_task A1 LEFT JOIN imagenet_ticket A2 ON (A1.object_id = A2.ticket_id) LEFT JOIN imagenet_ticket_status A3 ON (A2.status_id = A3.id) LEFT JOIN imagenet_staff A4 ON (A1.staff_id = A4.staff_id) LEFT JOIN imagenet_team A5 ON (A1.team_id = A5.team_id) JOIN imagenet_department A6 ON (A1.dept_id = A6.id) JOIN imagenet_task__cdata A7 ON (A1.id = A7.task_id) JOIN imagenet_thread A8 ON (A1.id = A8.object_id AND A8.object_type = 'A') LEFT JOIN imagenet_thread_collaborator B0 ON (A8.id = B0.thread_id) LEFT JOIN imagenet_thread_entry B1 ON (A8.id = B1.thread_id) LEFT JOIN imagenet_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 = 1) OR (A2.staff_id = 1 AND A3.state = 'open') OR A1.dept_id IN (1, 3)) GROUP BY A1.id ORDER BY A1.created DESC]
Unknown column 'A7.title' in 'field list'<br />
<br />
---- Backtrace ----<br />
#0 (raiz)/include/mysqli.php(200): osTicket->logDBError('DB Error #1054', '[SELECT A1.id...')<br />
#1 (raiz)/include/class.orm.php(3459): db_query('SELECT A1.id ...', true, true)<br />
#2 (raiz)/include/class.orm.php(3506): MySqlExecutor->execute()<br />
#3 (raiz)/include/class.orm.php(2093): MySqlExecutor->getArray()<br />
#4 (raiz)/include/class.orm.php(2043): HashArrayIterator->{closure}()<br />
#5 (raiz)/include/class.orm.php(2022): CallbackSimpleIterator->next()<br />
#6 (raiz)/include/class.orm.php(2031): CallbackSimpleIterator->rewind()<br />
#7 (raiz)/include/class.orm.php(1703): CallbackSimpleIterator->valid()<br />
#8 (raiz)/include/class.orm.php(1713): CachedResultSet->fillTo(9223372036854775807)<br />
#9 (raiz)/include/class.orm.php(1729): CachedResultSet->asArray()<br />
#10 (raiz)/include/staff/tasks.inc.php(368): CachedResultSet->getIterator()<br />
#11 (raiz)/scp/tasks.php(257): require_once('/home/imagenet/...')<br />
#12 {main}
Can someone help me ?
