
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] -- -- *Best Regards* *Ali Umair*

Hi, On 30.03.2015 13:29, Ali Umair wrote:
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)
That's the problem here: the list of ticket states is empty, and the SQL syntax doesn't allow an empty list here. So, why is it empty? The dashboard does a search for tickets (or probably more than one search, but at least one is problematic), and selects by certain ticket states, but no ticket states match the search criteria. I don't know the dashboard well, but I guess there'll be a search by viewable states, so maybe somebody configured your OTRS to not contain any valid, viewable states? Cheers, Moritz
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]
--
--
*Best Regards*
*Ali Umair*
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev

Dear Moritz, Thanks for your reply, Following query state is empty.. due to some dashboard configuration. but do you know this configuration is stored in which file? so that i can remove or i am able to fix this issue? 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 On 3/30/2015 4:39 PM, Moritz Lenz wrote:
Hi,
On 30.03.2015 13:29, Ali Umair wrote:
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) That's the problem here: the list of ticket states is empty, and the SQL syntax doesn't allow an empty list here.
So, why is it empty?
The dashboard does a search for tickets (or probably more than one search, but at least one is problematic), and selects by certain ticket states, but no ticket states match the search criteria.
I don't know the dashboard well, but I guess there'll be a search by viewable states, so maybe somebody configured your OTRS to not contain any valid, viewable states?
Cheers, Moritz
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]
--
--
*Best Regards*
*Ali Umair*
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
-- -- *Best Regards* *Ali Umair*

On 30.03.2015 14:36, Ali Umair wrote:
Dear Moritz, Thanks for your reply,
Following query state is empty.. due to some dashboard configuration. but do you know this configuration is stored in which file? so that i can remove or i am able to fix this issue?
This particular configuration is part of the database, and you can change it through the admin web frontend (Ticket Settings -> States)
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
On 3/30/2015 4:39 PM, Moritz Lenz wrote:
Hi,
On 30.03.2015 13:29, Ali Umair wrote:
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) That's the problem here: the list of ticket states is empty, and the SQL syntax doesn't allow an empty list here.
So, why is it empty?
The dashboard does a search for tickets (or probably more than one search, but at least one is problematic), and selects by certain ticket states, but no ticket states match the search criteria.
I don't know the dashboard well, but I guess there'll be a search by viewable states, so maybe somebody configured your OTRS to not contain any valid, viewable states?
Cheers, Moritz
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]
--
--
*Best Regards*
*Ali Umair*
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
--
--
*Best Regards*
*Ali Umair*
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
participants (2)
-
Ali Umair
-
Moritz Lenz