Ok, we've had otrs running for quite a while now (v2.4.7) and im pre-testing the 3.0.6 release prior to upgrading our production box, however ive noticed a number of errors in the /var/log/messages file.
Mar 22 17:35:20 otrstest OTRS-CGI-10[3254]: [Error][Kernel::System::Ticket::TicketSearch][Line:5115]: 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.ticket_lock_id IN (2) AND st.user_id IN (3) AND st.ticket_state_id IN ' 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.ticket_lock_id IN (2) AND st.user_id IN (3) AND st.ticket_state_id IN (7) AND st.until_time <= 1300775660 LIMIT 10000'
Mar 22 17:35:20 otrstest OTRS-CGI-10[3254]: [Error][Kernel::Output::HTML::Layout::NavigationBar][Line:2709]: Module Kernel/Output/HTML/NotificationAgentTicket.pm not found!
can anyone provide any insight into the cause of these errors and possible resolutions? - ive tried migrating the 'notificationagentticket.pm' file from the previous otrs system, but when that's in place (with appropriate permissions) the system wont even load the login page.
any assistance would be greatly appreciated.
Errors in SQL Syntax - After upgrade from 2.4.7 to 3.0.6
Moderator: crythias