On Thu, Dec 1, 2011 at 15:58, Mariano Mara <mariano.mara@gmail.com> wrote:

On 01.12.11 13:19, Michiel Beijen wrote:
> Hi Mariano,
> What version of OTRS are you using?
> Version 3.0 or later is supposed to truncate characters before sending
> them to the database.
> Can you provide the exact error message you're getting?
> --
> Mike
>

Mike, thanks for your answer. I'm still using 2.4.9 (we scheduled an upgrade
for February-2012).

Here's the exact error message:

DBD::Pg::db do failed: ERROR: value too long for type character varying(255) at /opt/otrs/Kernel/System/DB.pm line 427.
ERROR: OTRS-PMAccount-10 Perl: 5.8.8 OS: linux Time: Thu Dec 1 11:50:04 2011

Message: ERROR: value too long for type character varying(255), SQL: 'INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id, user_id, responsible_user_
+id, group_id, ticket_priority_id, ticket_state_id, ticket_answered, escalation_time, escalation_update_time, escalation_response_time, escalation_solution_time, timeout, service_id,
+sla_id, until_time, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 0, 0, 0, 0, 0, 0, ?, ?, 0, ?, current_timestamp, ?,
+current_timestamp, ?)'

Traceback (30692):
Module: Kernel::System::Ticket::TicketCreate (v1.416.2.13) Line: 447
Module: Kernel::System::PostMaster::NewTicket::Run (v1.75) Line: 147
Module: Kernel::System::PostMaster::Run (v1.83) Line: 351
Module: Kernel::System::MailAccount::IMAPS::_Fetch (v1.7.2.1) Line: 172
Module: Kernel::System::MailAccount::IMAPS::Fetch (v1.7.2.1) Line: 42
Module: Kernel::System::MailAccount::MailAccountFetch (v1.9) Line: 380
Module: main::Fetch (v1.10) Line: 181
Module: /opt/otrs/bin/PostMasterMailbox.pl (v1.10) Line: 94

ERROR: OTRS-PMAccount-10 Perl: 5.8.8 OS: linux Time: Thu Dec 1 11:50:04 2011

Message: IMAPS: Can't process mail, see log sub system (/opt/otrs/var/spool/problem-email-ef9adc931ff30132b42dea8701ce0de5, report it on http://bugs.otrs.org/)!

Traceback (30692):
Module: Kernel::System::MailAccount::IMAPS::_Fetch (v1.7.2.1) Line: 182
Module: Kernel::System::MailAccount::IMAPS::Fetch (v1.7.2.1) Line: 42
Module: Kernel::System::MailAccount::MailAccountFetch (v1.9) Line: 380
Module: main::Fetch (v1.10) Line: 181
Module: /opt/otrs/bin/PostMasterMailbox.pl (v1.10) Line: 94

Mariano

> On Wed, Nov 30, 2011 at 16:41, Mariano Mara <[1]mariano.mara@gmail.com>

> wrote:
>
> Hi guys, I have this system that it's sending error messages to a
> specific
> queue in my Otrs installation. Sometimes the email subject is too
> long (more
> than 255 characters) and I'm getting an error on the Otrs db side
> since the
> "title" column in the ticket table is a 255 varchar.
> Since I cannot shorten the other system email's subject I was
> wondering if altering
> the title column (to 600 characters) might have some unexpected side
> effect on
> my working Otrs installation.
> If somebody can comment on this, I will appreciate it.
> Regards,
> Mariano
---------------------------------------------------------------------
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