-----BEGIN PGP SIGNED MESSAGE-----
On 12-Mar-2003, Jesse Vincent wrote message “Re: [rt-users] 2.x > 3.x”
Andy> rt2 db. Used rt-2.0-to-dumpfile to create the rt dump. Started
Andy> running the dumpfile-to-rt-3.0 and it looked like it was going to
Andy> work, but hit a snag. Any clues on this one?
Andy> (my theory is that it’s just refusing to import an attachment with
Andy> the word ‘obtundent’ in it… 
The upgrade script doesn’t correctly quote the Content part for the
postgresql type bytea (I think \ needs to be \\ amoung other things).
Interesting. That sort of sounds like a bug in DBD::pgsql’s quoting
mechanism.
Ok, just for fun, I went ahead and installed mysql and set it up (with
rt-2-1-87) and tried the import again. It only bombed out on 3 or 4 tickets
and they were 100000+ lines.
But after the last ticket was imported, it gave similar errors than when I
removed the “bad” tickets while importing into postgres.
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Comment’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Correspond’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Resolved’,
‘Condition’ => ‘On Resolve’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Correspond’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers’,
‘Template’ => ‘Resolved’,
‘Condition’ => ‘On Resolve’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers’,
‘Template’ => ‘Transaction’,
‘Condition’ => ‘On Create’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Comment’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Resolved’,
‘Condition’ => ‘On Resolve’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Correspond’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘escalation-resolved’,
‘Condition’ => ‘On Resolve’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Correspond’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify AdminCcs’,
‘Template’ => ‘Transaction’,
‘Condition’ => ‘On Status’
};
Could not create scrip: $VAR1 = {
‘Action’ => ‘Notify All Watchers As Comment’,
‘Template’ => ‘Correspondence’,
‘Condition’ => ‘On Correspond’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/257’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 257,
‘Created’ => ‘2002-10-01 00:05:47+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:47+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/254’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 254,
‘Created’ => ‘2002-10-01 00:05:47+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:47+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/247’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 247,
‘Created’ => ‘2002-10-01 00:05:47+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:47+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/245’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 245,
‘Created’ => ‘2002-10-01 00:05:47+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:47+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/242’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 242,
‘Created’ => ‘2002-10-01 00:05:48+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:48+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/240’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 240,
‘Created’ => ‘2002-10-01 00:05:48+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:48+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/239’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 239,
‘Created’ => ‘2002-10-01 00:05:48+00’,
‘LastUpdated’ => ‘2002-10-01 00:05:48+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/267’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 267,
‘Created’ => ‘2002-10-02 18:58:31+00’,
‘LastUpdated’ => ‘2002-10-02 18:58:31+00’
};
Couldn’t create link 255 appears to be a local object, but can’t be found in
the database$VAR1 = {
‘Target’ => ‘fsck.com-rt:/ticket/255’,
‘Base’ => ‘fsck.com-rt:/ticket/265’,
‘LocalTarget’ => 255,
‘Creator’ => ‘6’,
‘Type’ => ‘MemberOf’,
‘LastUpdatedBy’ => ‘6’,
‘LocalBase’ => 265,
‘Created’ => ‘2002-10-03 18:26:11+00’,
‘LastUpdated’ => ‘2002-10-03 18:26:11+00’
};
Andy Harrison
Great Works Internet
System Operations
ajharrison@gwi.net
RSA 1024 pgp key: http://www.nachoz.com/andy.pub
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQCVAwUBPnXmdlPEkLgodAWVAQHDrwP/VDsjKaSj0PR4v4kASixIsrwgem9SoFz/
wVBXggvRlLci7VfGanwIDEsQklY/SzQFfIt+4CPhFlsxkRt5xniOfz0fkOmbW/rV
kb6aHcPNivJOqMP13crO6WArObiXRIUVgiEYxGUMCJGnObGtPOCrteUEf8mAqFa2
Q2OVuMmHcPU=
=hJ/3
-----END PGP SIGNATURE-----
