
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