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'

  • KevinTheJedi replied to this.
  • interested

    Login to database, drop the _task__cdata table, make sure you have a field with the variable name of title on the Task Details Form, and run cron manually a bunch of times until the table is recreated and repopulated with data.

    Cheers.

    interested

    Login to database, drop the _task__cdata table, make sure you have a field with the variable name of title on the Task Details Form, and run cron manually a bunch of times until the table is recreated and repopulated with data.

    Cheers.

    Write a Reply...