myistop
01-15-2008, 06:14 AM
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,t icket.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,t icket.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,t icket.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 1Please help me eliminate these errors.
Thanks in advance,
R. Kaja Mohideen
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,t icket.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,t icket.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,t icket.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 1Please help me eliminate these errors.
Thanks in advance,
R. Kaja Mohideen