Repaired the table and I am no longer receiving that error but now I get this.. unsure if its related or not.
[Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDGet][184] Unknown column 'process_change' in 'field list', SQL: 'SELECT process_name, process_id, process_host, process_create, process_change FROM process_id WHERE process_name = ? LIMIT 1' [Fri Aug 3 10:10:01 2012][Error][Kernel::System::PID::PIDCreate][154] Unknown column 'process_change' in 'field list', SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)' From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 10:03 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Nevermind I found it This coincides with the time [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' [Fri Aug 3 10:01:44 2012][Error][Kernel::System::Ticket::HistoryAdd][5255] Table '.\odhd\ticket_history' is marked as crashed and should be repaired, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, '2012-08-03 10:01:44' , ?, '2012-08-03 10:01:44' , ?)' From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 9:53 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Which logs would I look in to find the error information? From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 9:31 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 What do the logs say? Chances are, you *still* have problems sending email. On Fri, Aug 3, 2012 at 10:10 AM, Gadow, Shawn <sga...@ocusd.net<mailto:sga...@ocusd.net>> wrote: I got past that error I believe I noticed that the sendmail settings had been defaulted with the upgrade.. but now when I reply to a ticket it opens a blank window no error messages nothing just sits there.. when I close the window no e-mail has been sent and the status of the ticket has not changed however the response is noted Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer From: otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org> [mailto:otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org>] On Behalf Of Gadow, Shawn Sent: Friday, August 03, 2012 8:55 AM To: otrs@otrs.org<mailto:otrs@otrs.org> Subject: [otrs] Can't send e-mail replies after upgrade to 3.1.2 Every time I try to send an e-mail reply to a ticket I receive the following error.. This was working prior to the upgrade to 3.1.2 Any help would be appreciated Error Message: Impossible to send message to: berick...@ocusd.net<mailto:berick...@ocusd.net>, . Backend ERROR: OTRS-CGI-10 Perl: 5.12.3 OS: MSWin32 Time: Fri Aug 3 08:49:27 2012 Message: Impossible to send message to: alar...@ocusd.net<mailto:alar...@ocusd.net>, . Traceback (4452): Module: Kernel::System::Ticket::Article::ArticleSend (v1.309) Line: 2180 Module: Kernel::Modules::AgentTicketCompose::Run (v1.161) Line: 736 Module: Kernel::System::Web::InterfaceAgent::Run (v1.64) Line: 868 Module: ModPerl::ROOT::ModPerl::Registry::C_3a_Program_20Files_20_28x86_29_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 49 Module: (eval) (v1.90) Line: 204 Module: ModPerl::RegistryCooker::run (v1.90) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.90) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 Thank you, Shawn Gadow Network Administrator Oregon CUSD 220 "Security is when everything is settled. When nothing can happen to you. Security is the denial of life." - Germaine Greer --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
