[rt-devel] Data import on pg 7.4.0 failure

mixo mixo at coza.net.za
Wed Dec 17 01:29:35 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? Where does come from?





More information about the Rt-devel mailing list