[rt-users] problem with slashes

Jesse Vincent jesse at bestpractical.com
Mon Apr 28 07:57:18 EDT 2003


If you followed the upgrade procedure through the betas, you should have
converted all of your bytea columns to 'text'.

That's your problem.


On Mon, Apr 28, 2003 at 01:57:11PM +0200, Alex Fung A Foek wrote:
> I have the same problem (noticed somewhere around version 2-1-87). I'm 
> currently 3-0-2pre4 (with perl 5.8.0, apache 1.3.26, postgres 7.3.2r1-4) 
> but still have the backslash problem. The backslash is considered an 
> escape character so whenever I need to add text containing a backslash I 
> add a second one. Added text with only one backslash will end up with 
> the error:
> 
> Apr 28 13:35:24 rt postgres[1245]: [3] ERROR:  Bad input string for type 
> bytea
> Apr 28 15:35:24 rt RT: DBD::Pg::st execute failed: ERROR:  Bad input 
> string for type bytea at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm 
> line 385.  (/opt/rt3.0.2pre4/lib/RT.pm:222)
> Apr 28 15:35:24 rt RT: RT::Handle=HASH(0x9840830) couldn't execute the 
> query 'INSERT INTO Attachments (Subject, ContentType, Filename, Headers, 
> Creator, Parent, Created, ContentEncoding, Content, TransactionId) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at 
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 392. 
> (/opt/rt3.0.2pre4/lib/RT.pm:222)
> 
> regards,
> 
> Alex Fung A Foek
> 
> Sergey Tsvetukhin wrote:
> >Hello
> >
> >I create a new ticket via e-mail or vie web.
> >Subject line and body contain text with two slashes
> >
> >for example {slash}{slash}server
> >\\server
> >
> >but I see only one slash in body
> >
> >I suppose it is a error. :(
> >
> >
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

-- 
http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.



More information about the rt-users mailing list