[rt-users] Errors when replying to a ticket with a very long subject

[Ted Cabeen]

Jesse Vincent <jesse at bestpractical.com> writes:

> On Wed, Mar 22, 2006 at 03:06:55PM -0800, Ted Cabeen wrote:
>> Jesse Vincent <jesse at bestpractical.com> writes:
>> 
>> > On Tue, Mar 21, 2006 at 04:05:35PM -0800, Ted Cabeen wrote:
>> >> I'm getting the following errors in my apache error log whenever a
>> >> user replies via email to a ticket with a very long subject:
>> >
>> > What RT and SearchBuilder are you running? What database?
>> 
>> DBIx::SearchBuilder 1.38
>> RT 3.4.5
>
> That should be recent enough to do the right thing. What are you seeing
> in your database error logs?

Good question!  That points right at the problem:
ERROR:  value too long for type character varying(100)

My transactions table has data defined as a varchar(100), and in the
current schema for Pg, those fields are varchar(255).

Is anything going to break if I just change the type of the data field
to varchar(255) or text?  Is there any reason those fields are varchar
instead of text?

I should have checked the DB error logs earlier.

>> Database is postgresql 7.4.5.
>>
>> >> [Tue Mar 21 23:55:08 2006] [crit]: RT::Attachment->Create couldn't, as you didn't specify a transaction
>> >>  (/usr/local/rt3/lib/RT/Attachment_Overlay.pm:147)
>> >> [Tue Mar 21 23:55:08 2006] [err]: RT::Ticket=HASH(0x9ce3304) couldn't init a transaction Transaction Created (/usr/local/rt3/lib/RT/Ticket_Overlay.pm:2413)
>> >> [Tue Mar 21 23:55:08 2006] [crit]: Message could not be recorded (/usr/local/rt3/lib/RT/Interface/Email.pm:816)
>> >> 
>> >> It looks like the problem occurs with any subject that is longer than
>> >> 110 characters.  I can open a long subject ticket via email and open,
>> >> reply or comment on a long subject ticket through the web interface
>> >> without a problem.  However, whenever I try to enter a reply to it via
>> >> email, I get the above errors.  Has anyone seen/worked around this
>> >> error before, or should I open a bug on it?
>> >> 
>> >> -- 
>> >> Ted Cabeen
>> >> Sr. Systems/Network Administrator
>> >> Impulse Internet Services
>> >> 
>> >> 
>> >> 
>> >> _______________________________________________
>> >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>> >> 
>> >> Community help: http://wiki.bestpractical.com
>> >> Commercial support: sales at bestpractical.com
>> >> 
>> >> 
>> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> >> Buy a copy at http://rtbook.bestpractical.com
>> >> 
>> >> 
>> >> We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
>> >> 
>> >
>> > -- 
>> >
>> 
>> -- 
>> Ted Cabeen
>> Sr. Systems/Network Administrator
>> Impulse Internet Services
>> 
>
> -- 
>

-- 
Ted Cabeen
Sr. Systems/Network Administrator
Impulse Internet Services