osTicket (v1.14.2) give me DB Error #1054 (Unknown column 'A1.ticket_pid' in 'where clause')
[SELECT A1.number
AS number
, A1.ticket_id
AS ticket_id
, A1.source
AS source
, A1.lastupdate
AS lastupdate
, B2.subject
AS cdata__subject
, A1.isoverdue
AS isoverdue
, B4.name
AS user__name
, B2.priority
AS cdata__priority
, B5.firstname
AS staff__firstname
, B5.lastname
AS staff__lastname
, B6.name
AS team__name
, A1.team_id
AS team_id
, A1.isanswered
= '0' AS 2GkBZxz
, (SELECT COUNT(R0.id
) AS count
FROM ost_thread
Q7 JOIN ost_ticket
Q8 ON (Q7.object_type
= 'T' AND Q7.object_id
= Q8.ticket_id
) LEFT JOIN ost_thread_entry
R0 ON (Q7.id
= R0.thread_id
) WHERE Q8.ticket_id
= A1.ticket_id
AND NOT R0.flags
& 4 != 0) AS _thread_count, (SELECT COUNT(R1.id
) AS count
FROM ost_thread
Q7 JOIN ost_ticket
Q8 ON (Q7.object_type
= 'T' AND Q7.object_id
= Q8.ticket_id
) LEFT JOIN ost_thread_entry
R0 ON (Q7.id
= R0.thread_id
) LEFT JOIN ost_attachment
R1 ON (R1.type
= 'H' AND R0.id
= R1.object_id
) WHERE Q8.ticket_id
= A1.ticket_id
AND R1.inline
= 0) AS _att_count, B7.expire
> NOW() AND NOT B7.staff_id
= 1 AS _locked
, (SELECT COUNT(R0.id
) AS count
FROM ost_thread
Q7 JOIN ost_ticket
Q8 ON (Q7.object_type
= 'T' AND Q7.object_id
= Q8.ticket_id
) LEFT JOIN ost_thread_collaborator
R0 ON (Q7.id
= R0.thread_id
) WHERE Q8.ticket_id
= A1.ticket_id
) AS _collabs, COALESCE(B5.firstname
, B5.lastname
, B6.name
, 'zzz') AS assignee
FROM ost_ticket
A1 JOIN ost_ticket_status
A2 ON (A1.status_id
= A2.id
) LEFT JOIN ost_thread
A3 ON (A3.object_type
= 'T' AND A1.ticket_id
= A3.object_id
) LEFT JOIN ost_thread_referral
A4 ON (A3.id
= A4.thread_id
) LEFT JOIN ost_staff
A5 ON (A4.object_type
= 'S' AND A4.object_id
= A5.staff_id
) LEFT JOIN ost_thread
A6 ON (A1.ticket_id
= A6.object_id
AND A6.object_type
= 'C') LEFT JOIN ost_thread_referral
A7 ON (A6.id
= A7.thread_id
) LEFT JOIN ost_staff
A8 ON (A7.object_type
= 'S' AND A7.object_id
= A8.staff_id
) LEFT JOIN ost_department
B0 ON (A4.object_type
= 'D' AND A4.object_id
= B0.id
) LEFT JOIN ost_department
B1 ON (A7.object_type
= 'D' AND A7.object_id
= B1.id
) LEFT JOIN ost_ticket__cdata
B2 ON (A1.ticket_id
= B2.ticket_id
) LEFT JOIN ost_ticket_priority
B3 ON (B2.priority
= B3.priority_id
) LEFT JOIN ost_user
B4 ON (A1.user_id
= B4.id
) LEFT JOIN ost_staff
B5 ON (A1.staff_id
= B5.staff_id
) LEFT JOIN ost_team
B6 ON (A1.team_id
= B6.team_id
) LEFT JOIN ost_lock
B7 ON (A1.lock_id
= B7.lock_id
) WHERE A2.state
= 'open' AND ((A2.state
= 'open' AND (A1.staff_id
= 1 OR A5.staff_id
= 1 OR A6.object_type
= 'C' AND A8.staff_id
= 1)) OR A1.dept_id
IN (1, 3) OR B0.id
IN (1, 3) OR A6.object_type
= 'C' AND B1.id
IN (1, 3)) AND (A1.ticket_pid
IS NULL OR A1.flags
& 8 != 0) GROUP BY A1.ticket_id
ORDER BY B3.priority_urgency
ASC, A1.lastupdate
DESC LIMIT 25] Unknown column 'A1.ticket_pid' in 'where clause'
please if you can help me
thanks osTicket Team.
DB Error #1054
Please help us to help you by reading and following the posting guidelines located in this thread: Please read before requesting assistance. The more information you give us the better we will be able to assist you. Thank you.
Environment details? (see Admin panel -> Dashboard -> Information)