[rt-users] Data import on pg 7.4.0 failure

mixo mixo at coza.net.za
Wed Dec 17 01:28:48 EST 2003


I have just had a data import into pg 7.4.0 fail with the following 
messages repeated:

++++++++++++++++++++++++++++++++++++++++++++
Dec 14 11:57:08 dhcp3 RT: DBD::Pg::st execute failed: ERROR:  
unterminated quoted string at or near "'ÿØÿà" at character 368 at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:247)
Dec 14 11:57:08 dhcp3 RT: RT::Handle=HASH(0x8791e78) couldn't execute 
the query 'INSERT INTO Attachments (ContentType, Parent, id, Subject, 
Filename, Headers, Creator, Created, Content, ContentEncoding, 
TransactionId) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  
(/opt/rt3/lib/RT.pm:247)
Dec 14 11:57:08 dhcp3 RT: Couldn't create attachment HASH(0x8e11d98) 
$VAR1 = {           'Subject' => '',           'ContentType' => 
'image/jpeg',           'Filename' => 'page1.jpg',           'Headers' 
=> 'Content-Type: IMAGE/jpeg; name="page1.jpg";
Content-transfer-encoding: BASE64 Content-Disposition: attachment; 
filename="page1.jpg" ',           'Creator' => '25285',
       'Parent' => '409359',           'Created' => '2003-09-12 
07:03:49+00',           'id' => '409361',           'Content'
=> 'ÿØÿà
Dec 14 11:57:08 dhcp3 ^PJFIF
Dec 14 11:57:08 dhcp3 ^A^A
Dec 14 11:57:08 dhcp3 RT: Use of uninitialized value in subroutine entry 
at /usr/lib/perl5/5.8.0/i386-linux-thread-multi/Encode.pm line 154.  
(/opt/rt3/lib/RT.pm:247)
++++++++++++++++++++++++++++++++++++++++++++

++++++++++++++++++++++++++++++++++++++++++++
Dec 14 11:58:59 dhcp3 RT: DBD::Pg::st execute failed: ERROR:  invalid 
input syntax for integer: "" at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 410.  
(/opt/rt3/lib/RT.pm:247)
Dec 14 11:58:59 dhcp3 RT: RT::Handle=HASH(0x8791e78) couldn't execute 
the query 'SELECT  * FROM Groups WHERE lower(Domain) = ? AND (Instance 
IS NULL OR Instance = '') AND lower(Type) = ?' at 
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 417.  
(/opt/rt3/lib/RT.pm:247)
Dec 14 11:58:59 dhcp3 RT: Trying to check RT::Queue rights for an 
unspecified RT::Queue at /opt/rt3/lib/RT/Principal_Overlay.pm line 354 
^IRT::Principal::HasRight('RT::Principal=HASH(0x27afae20)','Object','RT::Queue=HASH(0x27b07034)','Right','ModifyACL') 
called at /opt/rt3/lib/RT/User_Overlay.pm line 1450 
^IRT::User::HasRight('RT::User=HASH(0x27b07004)','Object','RT::Queue=HASH(0x27b07034)','Right','ModifyACL') 
called at /opt/rt3/lib/RT/CurrentUser.pm line 300 
^IRT::CurrentUser::HasRight('RT::CurrentUser=HASH(0x8e60870)','Object','RT::Queue=HASH(0x27b07034)','Right','ModifyACL') 
called at /opt/rt3/lib/RT/ACE_Overlay.pm line 235 
^IRT::ACE::Create('RT::ACE=HASH(0x27b079f8)','RightName','CreateTicket','Object','RT::Queue=HASH(0x27b07034)','PrincipalType','Group','PrincipalId',3,...) 
called at /opt/rt3/lib/RT/Principal_Overlay.pm line 139 
^IRT::Principal::GrantRight('RT::Principal=HASH(0x27ad68d8)','Object','RT::Queue=HASH(0x27b07034)','Right','CreateTicket') 
called at ./dumpfile-to-rt-3.0 line 286  (/opt/rt3/lib/RT.pm:247)
Dec 14 11:58:59 dhcp3 RT: 1 (/opt/rt3/lib/RT/Principal_Overlay.pm:354)
Dec 14 11:58:59 dhcp3 RT: Use of uninitialized value in numeric ne (!=) 
at /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle/Pg.pm line 
105.  (/opt/rt3/lib/RT.pm:247)
++++++++++++++++++++++++++++++++++++++++++++


Has anyone seen this with data import? Why am I getting "'ÿØÿà" repeated?




More information about the rt-users mailing list