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 sq.group_id IN (1, 2, 3, 4) AND tw.user_id IN (3) LIMIT 10000' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_watcher tw WHERE sq.id = st.queue_id AND st.id = tw.ticket_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (1, 2, 3, 4) AND tw.user_id IN (3) LIMIT 10000'
Error with mysql[solved]
Moderator: crythias
Error with mysql[solved]
I get alot of this message when checking systemlog
Last edited by fisk5 on 22 Mar 2011, 15:59, edited 1 time in total.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Error with mysql
Do these errors reflect a Generic Agent schedule?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Error with mysql
When a agent logs in.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Error with mysql
Have you changed state types?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Re: Error with mysql
Yes, i had for some reason set a state to invalid, i changed it and now it dont seem to produce that errors anymore.