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