[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 ?