When I execute the DBUpdate-to-3.1.mysql.sql script I get a few errors back all stating that the table already exists and no other errors so I would assume that means this step was already ran
So I continue on and I'm not really sure how to run the pl script but when I start the script in command prompt I get the following c:\Program Files (x86)\OTRS\OTRS\scripts>DBUpdate-to-3.1.pl Migration started... install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: C:/Program Files (x86)/OTRS/OTRS/Custom C:/Program Files (x86)/OTRS/OTRS/Kernel/ cpan-lib C:/Program Files (x86)/OTRS/OTRS C:/Perl/site/lib C:/Perl/lib .) at (ev al 20) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: CSV, DBM, ExampleP, File, Gofer, ODBC, Oracle, Pg, Proxy, SQL ite, Sponge. at C:/Program Files (x86)/OTRS/OTRS/Kernel/System/DB.pm line 256 c:\Program Files (x86)\OTRS\OTRS\scripts> the location of the mysql.pm file is C:\Program Files (x86)\OTRS\OTRS\Kernel\System\DB if that makes a difference From: otrs-boun...@otrs.org [mailto:otrs-boun...@otrs.org] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 10:51 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 backup your database. and everything else. Read UPGRADING in your OTRS folder. You'll need to do three steps: a DBUpdate for schema, a perl update, and a post schema update, plus cache, config etc. This is assuming it hasn't been done already. I don't know the state of your database, especially since you had a crashed table. While the information should work, you should test it out before changing production. The information I've provided is not guaranteed for any purpose, and your situation may involve pieces that I can't guess from a mailing list. On Fri, Aug 3, 2012 at 11:28 AM, Gadow, Shawn <sga...@ocusd.net<mailto:sga...@ocusd.net>> wrote: I upgraded from 3.0. So it appears it is fixable then by running the update? yes? How would I do that? I am running on a windows server From: otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org> [mailto:otrs-boun...@otrs.org<mailto:otrs-boun...@otrs.org>] On Behalf Of Gerald Young Sent: Friday, August 03, 2012 10:24 AM To: User questions and discussions about OTRS. Subject: Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2 It may be that the conversion didn't complete but did you upgrade from 3.0 or 3.1.1? It appears you didn't complete the schema changes on upgrade. On Fri, Aug 3, 2012 at 11:12 AM, Gadow, Shawn <sga...@ocusd.net<mailto:sga...@ocusd.net>> wrote: 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> [mailto: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> [mailto: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> [mailto: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 --------------------------------------------------------------------- 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
