What is RT trying to do, that is should fail when this debug script works?
use EZDBI;
use Data::Dumper;
Connect 'mysql:rt', 'rt_user', 'PASSWORD';
my $r = Select '* From Users LIMIT 2';
print Dumper $_ while( $_ = $r->({}) );
__END__
$VAR1 = {
'WebEncoding' => undef,
'AuthSystem' => undef,
'PGPKey' => undef,
'Password' => '*NO-PASSWORD*',
'MobilePhone' => undef,
'WorkPhone' => undef,
'id' => '1',
'LastUpdated' => '2008-08-02 14:59:35',
'PagerPhone' => undef,
'ExternalContactInfoId' => undef,
'ContactInfoSystem' => undef,
'Creator' => '1',
'LastUpdatedBy' => '1',
'HomePhone' => undef,
'Address1' => undef,
'Created' => '2008-08-02 14:59:35',
'ExternalAuthId' => undef,
'Comments' => 'Do not delete or modify this user. It is
integral to RT\'s internal database structures',
'NickName' => undef,
'Address2' => undef,
'Timezone' => undef,
'FreeformContactInfo' => undef,
'RealName' => 'The RT System itself',
'City' => undef,
'EmailAddress' => undef,
'EmailEncoding' => undef,
'State' => undef,
'Signature' => undef,
'Zip' => undef,
'Organization' => undef,
'Lang' => undef,
'Gecos' => undef,
'Country' => undef,
'Name' => 'RT_System'
};
$VAR1 = {
'WebEncoding' => undef,
'AuthSystem' => undef,
'PGPKey' => undef,
'Password' => '*NO-PASSWORD*',
'MobilePhone' => undef,
'WorkPhone' => undef,
'id' => '6',
'LastUpdated' => '2008-08-02 14:59:35',
'PagerPhone' => undef,
'ExternalContactInfoId' => undef,
'ContactInfoSystem' => undef,
'Creator' => '1',
'LastUpdatedBy' => '1',
'HomePhone' => undef,
'Address1' => undef,
'Created' => '2008-08-02 14:59:35',
'ExternalAuthId' => undef,
'Comments' => 'Do not delete or modify this user. It is
integral to RT\'s internal data structures',
'NickName' => undef,
'Address2' => undef,
'Timezone' => undef,
'FreeformContactInfo' => undef,
'RealName' => 'Nobody in particular',
'City' => undef,
'EmailAddress' => '',
'EmailEncoding' => undef,
'State' => undef,
'Signature' => undef,
'Zip' => undef,
'Organization' => undef,
'Lang' => undef,
'Gecos' => undef,
'Country' => undef,
'Name' => 'Nobody'
};
--
Cambridge Energy Alliance: Save money. Save the planet.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com