[rt-users] 2.x > 3.x

[Andy Harrison]

-----BEGIN PGP SIGNED MESSAGE-----


On 12-Mar-2003 Aaron Wilson wrote:
> 
> The upgrade script doesn't correctly quote the Content part for the 
> postgresql type bytea (I think \ needs to be \\\\ amoung other things).
> 
> One (evil) fix is to change the schema to use text instead of bytea
> 
> A related question: why is the new postgresql schema using bytea instead of 
> text (as it used to in 2.0.x) ?  
> 
> Aaron
> 

I went into the attachments table, dropped content and headers which showed
bytea, and recreated them as text.  

Now it fails right at the first ticket instead of doing a bunch:

Importing ticket 1
            transaction 1
               attachment 
[Wed Mar 12 16:21:39 2003] [crit]: Couldn't create attachment HASH(0x8e7f30c)
$VAR1 = {
          'ContentType' => 'text/plain',
          'Created' => '2002-05-14 19:20:22+00',
          'Content' => '

Time of incident:

IPs:

Usernames:

Traceroute:


',
          'ContentEncoding' => 'none',
          'Creator' => '4',
          'TransactionId' => '1'
        };
 (/opt/rt3/lib/RT.pm:228)


- -- 
Andy Harrison
Great Works Internet
System Operations
ajharrison at gwi.net
RSA 1024 pgp key: http://www.nachoz.com/andy.pub

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8

iQCVAwUBPm9fZlPEkLgodAWVAQHQtgQAhjIXEgx4pw3tXwpAdoew8Z12gafFCFOI
Mp2e8Xun9bjGqtc35nFBfiUhYFJs3HfOB8G7FEbQ/zea6wrz8/+9SsDvPAYcfNmI
DYUdidnpArcNg10fR0EiwB7hEE/9ZiTMkFebyF9O0O0+XZU2IL1GVzs6AHvIHFn+
ypb1lQ+uM+k=
=ZxjV
-----END PGP SIGNATURE-----