[Rt-devel] Encoding bug in ticket creation

[Daniel Néri]

       Hello,

Ticket creation (via the web interface) with a subject containing
accented characters (e.g. "ö") and empty content/body fails with the
following errors logged by RT:

Aug 15 09:03:13 web1 RT: Attachment insert failed - ERROR:  invalid byte sequence for encoding "UTF8": 0xf60a436f HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". (/opt/rt3/lib/RT/Attachment_Overlay.pm:153)  
Aug 15 09:03:13 web1 RT: About to think about scrips for transaction #795  
Aug 15 09:03:13 web1 RT: About to prepare scrips for transaction #795  
Aug 15 09:03:13 web1 RT: RT::Ticket=HASH(0x9a6a9f8) tried to load a bogus ticket: 86  
Aug 15 09:03:14 web1 RT: RT::Scrips=HASH(0x9a5eab4) couldn't load ticket 86 (/opt/rt3/lib/RT/Scrips_Overlay.pm:291)  
Aug 15 09:03:14 web1 RT: Found 2 scrips for TransactionCreate stage with applicable type(s) Create  
Aug 15 09:03:14 web1 RT: RT::Ticket=HASH(0x9a74c48) tried to load a bogus ticket: 86  
Aug 15 09:03:14 web1 RT: HasRight called with no valid object (/opt/rt3/lib/RT/Principal_Overlay.pm:322)  
Aug 15 09:03:15 web1 RT: RT::Ticket=HASH(0x9a90384) tried to load a bogus ticket: 86  
Aug 15 09:03:15 web1 RT: HasRight called with no valid object (/opt/rt3/lib/RT/Principal_Overlay.pm:322)  
Aug 15 09:03:15 web1 RT: RT::Ticket=HASH(0x9a6b34c) tried to load a bogus ticket: 86  
Aug 15 09:03:15 web1 RT: HasRight called with no valid object (/opt/rt3/lib/RT/Principal_Overlay.pm:322)  
Aug 15 09:03:16 web1 RT: About to commit scrips for transaction #795  
Aug 15 09:03:16 web1 RT: Committing scrip #11 on txn #795 of ticket #  
Aug 15 09:03:16 web1 RT: RT::Ticket=HASH(0x9a8da50) tried to load a bogus ticket: 86  
Aug 15 09:03:16 web1 RT: HasRight called with no valid object (/opt/rt3/lib/RT/Principal_Overlay.pm:322)  
Aug 15 09:03:17 web1 RT: Tried to load a bogus ticket id: ''  
Aug 15 09:03:17 web1 RT: RT::Ticket=HASH(0x9996da0) tried to load a bogus ticket: 86  
Aug 15 09:03:17 web1 RT: Ticket couldn't be created:  (/opt/rt3/lib/RT/Ticket_Overlay.pm:667)  
Aug 15 09:03:17 web1 RT: WebRT: Ticket could not be created due to an internal error (/opt/rt3/share/html/Elements/Error:82)  

It can be worked around by adding some content (accented or not).

I'm currently using RT 3.8.1rc5 with PostgreSQL 8.3.


Regards,
-- 
Daniel Néri <daniel.neri at sigicom.com>
Sigicom AB, Stockholm, Sweden