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

Andy Harrison ajharrison at gwi.net
Mon Mar 17 10:15:03 EST 2003


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


- -------------------------------------------------------------
On 12-Mar-2003, Jesse Vincent wrote message "Re: [rt-users] 2.x > 3.x"
- -------------------------------------------------------------
> 
> 
> 
> On Wed, Mar 12, 2003 at 03:00:03PM +0000, Aaron Wilson wrote:
>> 
>> >>>>> On Wed, 12 Mar 2003, "Andy" == Andy Harrison wrote:
>> 
>>   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 at 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-----



More information about the rt-users mailing list