Re: [otrs] Can't send e-mail replies after upgrade to 3.1.2

3 Aug 2012

      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  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-bounces@otrs.org [mailto:otrs-bounces@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  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-bounces@otrs.org [mailto:otrs-bounces@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-bounces@otrs.org [mailto:otrs-bounces@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-bounces@otrs.org [mailto:otrs-bounces@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  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-bounces@otrs.org [mailto:otrs-bounces@otrs.org] *On Behalf
Of *Gadow, Shawn
*Sent:* Friday, August 03, 2012 8:55 AM
*To:* 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: berickson@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: alarsen@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