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 $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
