Hi Andreas, On Fri, Jul 26, 2002 at 12:56:08AM +0200, WebhostOne wrote:
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 [...] 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, [...] What can I do
Is it possible, that you updated your OpenTRS but not the database? If yes, try the db update script: host:~ # cat /opt/OpenTRS/scripts/DBUpdate.mysql.sql | mysql -f -u root -p otrs' If not, tell me more about your installation (OpenTRS release, ...). PS: You have to be subscribed to otrs@otrs.org for postings on it (http://lists.otrs.org/cgi-bin/listinfo/otrs).
Thanks
No problem. .-)
Andreas Weigert
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "Security is a process, not a product." - Bruce Schneider