otrs 3.13
Centos 5.2
** I wanted to upgrade to 3.1.5 but reverted back to 3.1.3 **
Getting the following errors when this script runs,
DBD::mysql::st execute failed: Unknown column 'st.freekey1' in 'field list' at /home/zapticket/Kernel/System/DB.pm line 559.
ERROR: OTRS-PMAccount-10 Perl: 5.8.8 OS: linux Time: Tue May 22 11:00:04 2012
Message: Unknown column 'st.freekey1' in 'field list', SQL: 'SELECT st.id, st.queue_id, sq.name, st.ticket_state_id, st.ticket_lock_id, sp.id, sp.name, st.create_time_unix, st.create_time, sq.group_id, st.tn, st.customer_id, st.customer_user_id, st.user_id, st.responsible_user_id, st.until_time, st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3, st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5, st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8, st.freetext8, st.freekey9, st.freetext9, st.freekey10, st.freetext10, st.freekey11, st.freetext11, st.freekey12, st.freetext12, st.freekey13, st.freetext13, st.freekey14, st.freetext14, st.freekey15, st.freetext15, st.freekey16, st.freetext16, st.freetime1, st.freetime2, st.freetime3, st.freetime4, st.freetime5, st.freetime6, st.change_time, st.title, st.escalation_update_time, st.timeout, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, !
st.escalation_time FROM ticket st, ticket_priority sp, queue sq WHERE sp.id = st.ticket_priority_id AND sq.id = st.queue_id AND st.id = ? LIMIT 1'
Traceback (32030):
Module: Kernel::System::Ticket::TicketGet (v1.416.2.15) Line: 920
Module: Kernel::System::Ticket::HistoryAdd (v1.416.2.15) Line: 6239
Module: Kernel::System::Ticket::TicketCreate (v1.416.2.15) Line: 471
Module: Kernel::System::PostMaster::NewTicket::Run (v1.75) Line: 147
Module: Kernel::System::PostMaster::Run (v1.83) Line: 351
Module: Kernel::System::MailAccount::POP3::_Fetch (v1.6.2.1) Line: 165
Module: Kernel::System::MailAccount::POP3::Fetch (v1.6.2.1) Line: 45
Module: Kernel::System::MailAccount::MailAccountFetch (v1.9) Line: 380
Module: main::Fetch (v1.10) Line: 181
Module: /home/zapticket/bin/PostMasterMailbox.pl (v1.10) Line: 94
PostMasterMailbox.pl
Moderator: crythias