Upgrade error

Moderator: crythias

Locked
technicolor
Znuny newbie
Posts: 14
Joined: 22 Apr 2010, 10:01
Znuny Version: 2.4.7

Upgrade error

Post by technicolor »

Hi, i made upgrade from 2.4.7 to 3.0.8 but it seems that less some sql tables as ticket_flasg and archive_flag. Can you tell me how can repair this error?

This is the message when i click on a ticket:

Backend ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Wed Jun 8 16:59:35 2011 Message: Table 'piramedia.ticket_flag' doesn't exist, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_flag tf1 WHERE sq.id = st.queue_id AND st.id = tf1.ticket_id AND st.ticket_lock_id IN (2) AND st.user_id IN (1) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 1 LIMIT 10000' Traceback (1484): Module: Kernel::System::Ticket::TicketSearch (v1.488.2.6) Line: 5124 Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (v1.7) Line: 53 Module: Kernel::Output::HTML::Layout::Header (v1.351.2.9) Line: 1415 Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.351.2.9) Line: 1113 Module: Kernel::Modules::AgentTicketZoom::Run (v1.145.2.4) Line: 90 Module: Kernel::System::Web::InterfaceAgent::Run (v1.58.2.1) Line: 853 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 46 Module: (eval) (v1.89.2.1) Line: 204 Module: ModPerl::RegistryCooker::run (v1.89.2.1) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.89.2.1) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31

Thanks
OS: CentoOS
OTRS 2.4.7
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Upgrade error

Post by jojo »

Please read the UPGRADING file for performing a correct update
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked