Just installed V.18 on a new LAMP Stack and started using it. If I want to open tasks it takes several seconds to open and I get instantly following error message via Mail:
[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
, A1.updated
AS updated
, 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.staff_id
= 2 AND 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, 2, 4)) GROUP BY http://A1.id ORDER BY A1.updated
DESC LIMIT 1]
Unknown column 'A7.title' in 'field list'