Team,
I am continuously facing following exception in OTRS, and i
am unable to track....
Anybody can suggest the root cause of this exception ?
if no user access the OTRS application but still this exception is
printing in error log continuously...
[Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015]
index.pl: DBD::mysql::st execute failed: 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 ') AND st.queue_id IN
(999999) AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at line
1 at /opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553.
[Sun Mar 29 17:29:53 2015] [error] ERROR: OTRS-CGI-10 Perl: 5.10.1
OS: linux Time: Sun Mar 29 17:29:53 2015
[Sun Mar 29 17:29:53 2015] [error]
[Sun Mar 29 17:29:53 2015] [error] Message: 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 ') AND st.queue_id
IN (999999) AND sq.group_id IN (802, 807, 820, 822, 829, 876,' at
line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq
WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND
st.queue_id IN (999999) AND sq.group_id IN (802, 807, 820, 822, 829,
876, 913) AND st.until_time <= 1427722133 LIMIT 10000'
[Sun Mar 29 17:29:53 2015] [error]
[Sun Mar 29 17:29:53 2015] [error] Traceback (12647):
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
[Sun Mar 29 17:29:53 2015] [error] Module:
/opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45
[Sun Mar 29 17:29:53 2015] [error]
[Sun Mar 29 17:29:53 2015] [error] [Sun Mar 29 17:29:53 2015]
index.pl: DBD::mysql::st execute failed: 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 ') AND
st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820,
822, 82' at line 1 at
/opt/iplOTRS/bin/cgi-bin/../../Kernel/System/DB.pm line 553.
[Sun Mar 29 17:29:53 2015] [error] ERROR: OTRS-CGI-10 Perl: 5.10.1
OS: linux Time: Sun Mar 29 17:29:53 2015
[Sun Mar 29 17:29:53 2015] [error]
[Sun Mar 29 17:29:53 2015] [error] Message: 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 ') AND
st.responsible_user_id IN (16) AND sq.group_id IN (802, 807, 820,
822, 82' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st,
queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( )
AND st.responsible_user_id IN (16) AND sq.group_id IN (802, 807,
820, 822, 829, 876, 913) AND st.until_time <= 1427722133 LIMIT
10000'
[Sun Mar 29 17:29:53 2015] [error]
[Sun Mar 29 17:29:53 2015] [error] Traceback (12647):
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::System::Ticket::TicketSearch (v1.488.2.1) Line: 5136
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.38) Line: 224
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::Modules::AgentDashboard::_Element (v1.24) Line: 458
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::Modules::AgentDashboard::Run (v1.24) Line: 307
[Sun Mar 29 17:29:53 2015] [error] Module:
Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853
[Sun Mar 29 17:29:53 2015] [error] Module:
/opt/iplOTRS/bin/cgi-bin/index.pl (v1.89) Line: 45
[Sun Mar 29 17:29:53 2015] [error]