Hello, When I open a queue is spent me following mistake:
Error: No customer article found!! (TicketID=1) Comment: Please contact your admin Handle: /opt/OpenTRS/bin/cgi-bin/index.pl Modulefile: ../../Kernel/Modules/AgentQueueView.pm Module: Kernel::Modules::AgentQueueView (v 1.13) Subfunction: Kernel::Modules::AgentQueueView::ShowTicket Line: 289 Cron <otrs@www2> $HOME/bin/UnlockTickets.pl --timeout >> /dev/null DBD::mysql::st execute failed: Unknown column 'st.ticket_answered' in 'field list' at /opt/OpenTRS/bin/..//Kernel/System/DB.pm line 172. [OpenTRS-UnlockTickets][Error][Kernel::System::DB::Prepare][Line:126] Unknown column 'st.ticket_answered' in 'field list', SQL: 'SELECT st.tn, slt.name, st.ticket_answered, st.id, st.timeout, sq.unlock_timeout FROM ticket as st, queue as sq, ticket_state tsd, ticket_lock_type slt WHERE st.ticket_state_id = tsd.id AND st.queue_id = sq.id AND st.ticket_lock_id = slt.id AND st.ticket_answered != 1 AND sq.unlock_timeout != 0 AND tsd.name IN ( 'open', 'new' ) AND slt.name NOT IN ( 'unlock', 'tmp_lock' ) ' DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/OpenTRS/bin/..//Kernel/System/DB.pm line 184. What can I do Thanks Andreas Weigert _______________________________________________ OpenTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
