Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

osTicket v1.10 (stable) and Maintenance Release v1.9.15 are now available! Go get it now

SQL Error

Hello,

I'm new to osTicket. I have installed osTicket and configured it. It was about 10 days since i installed it. But, yesterday I received 6 mails reporting SQL Error. The mails read as
[SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name ,status,source,isoverdue,ticket.created,pri.* FROM ost_ticket ticket LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN ost_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() WHERE (ticket.dept_id IN (,2) OR ticket.staff_id=4) AND status='Open' AND (ticket.staff_id=0 OR ticket.staff_id=4 OR dept.manager_id=4) ORDER BY priority_urgency,ticket.created DESC LIMIT 0,30] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2) OR ticket.staff_id=4) AND status='Open' AND (ticket.staff_id=0 OR ticket.staf' at line 1
[SELECT count(*) FROM ost_ticket ticket LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN ost_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() WHERE (ticket.dept_id IN (,2) OR ticket.staff_id=4) AND status='Open' AND (ticket.staff_id=0 OR ticket.staff_id=4 OR dept.manager_id=4) ] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '2) OR ticket.staff_id=4) AND status='Open' AND (ticket.staff_id=0 OR ticket.staf' at line 1
[SELECT count(*) FROM ost_ticket ticket LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN ost_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() WHERE (ticket.dept_id IN (,1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staff_id=5 OR dept.manager_id=5) ] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staf' at line 1
[SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name ,status,source,isoverdue,ticket.created,pri.* FROM ost_ticket ticket LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN ost_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() WHERE (ticket.dept_id IN (,1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staff_id=5 OR dept.manager_id=5) ORDER BY priority_urgency,ticket.created DESC LIMIT 0,30] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staf' at line 1
[SELECT count(*) FROM ost_ticket ticket LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN ost_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() WHERE (ticket.dept_id IN (,1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staff_id=5 OR dept.manager_id=5) ] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staf' at line 1
[SELECT ticket.ticket_id,lock_id,ticketID,ticket.dept_id,ticket.staff_id,subject,name,email,dept_name ,status,source,isoverdue,ticket.created,pri.* FROM ost_ticket ticket LEFT JOIN ost_department dept ON ticket.dept_id=dept.dept_id LEFT JOIN ost_ticket_priority pri ON ticket.priority_id=pri.priority_id LEFT JOIN ost_ticket_lock tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() WHERE (ticket.dept_id IN (,1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staff_id=5 OR dept.manager_id=5) ORDER BY priority_urgency,ticket.created DESC LIMIT 0,30] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1) OR ticket.staff_id=5) AND status='Open' AND (ticket.staff_id=0 OR ticket.staf' at line 1
Please help me eliminate these errors.

Thanks in advance,

R. Kaja Mohideen
Sign In or Register to comment.