Probleme with DBIx-SearchBuilder-0.93_04

hi,
i am running rt 3.0.6, and since i have upgraded the search builder to:
DBIx-SearchBuilder-0.93_04, every time i made a search i have this
error:

error: Can’t call method “quote” on an undefined value at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 645.

context: …
640:
641: #if we’re explicitly told not to to quote the value or
642: # we’re doing an IS or IS NOT (null), don’t quote the operator.
643:
644: if ( $args{‘QUOTEVALUE’} && $args{‘OPERATOR’} !~ /IS/ ) {
645: $args{‘VALUE’} = $self->_Handle->dbh->quote( $args{‘VALUE’} );
646: }
647: }
648:

code stack: /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm:644
/usr/local/rt3/lib/RT/SearchBuilder.pm:132
/usr/local/rt3/lib/RT/Tickets_Overlay_SQL.pm:382
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:2007
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:1722
/usr/local/rt3/share/html/Search/Listing.html:104
/usr/local/rt3/share/html/autohandler:189

Malek Shabou E-mail: nic@nic.fr
AFNIC Tel: +33 1 39 30 83 00
Immeuble international, 2 rue Stephenson Fax: +33 1 39 30 83 01
Saint-Quentin-En-Yvelines 78180 Montigny-Le-Bretonneux

Utiliser http://www.nic.fr/zonecheck/ pour verifier vos domaines

Me too. The exact same error with only two tickets existing in one of
two configured queues. Things appear to be fine after installing (via
the CPAN shell) DBIx-SearchBuilder-0.92.tar.gz on top of the 0.93 that
was already there.

My system, a new install from earlier today:

RT 3.0.6
RedHat 9 on a PIII 600MHz
Perl 5.8.0 (from RH’s perl-5.8.0-88.3.rpm)
Apache 2.0.40 (from RH’s httpd-2.0.40-21.5.rpm)
mod_perl2 (from RH’s mod_perl-1.99_07-5.rpm)
MySQL 4.0.16 (from MySQL AB’s RPMs)

James McMurry
Object Computing, Inc.

Malek Shabou wrote:

Me too. The exact same error with only two tickets existing in one of
two configured queues. Things appear to be fine after installing (via
the CPAN shell) DBIx-SearchBuilder-0.92.tar.gz on top of the 0.93 that
was already there.

I can’t duplicate this here. Can you tell me if there’s anything in
mysql’s error log, the httpd error log, the syslog or your rt log?

My system, a new install from earlier today:

RT 3.0.6
RedHat 9 on a PIII 600MHz
Perl 5.8.0 (from RH’s perl-5.8.0-88.3.rpm)
Apache 2.0.40 (from RH’s httpd-2.0.40-21.5.rpm)
mod_perl2 (from RH’s mod_perl-1.99_07-5.rpm)
MySQL 4.0.16 (from MySQL AB’s RPMs)

James McMurry
Object Computing, Inc.

Malek Shabou wrote:

hi,
i am running rt 3.0.6, and since i have upgraded the search builder to:
DBIx-SearchBuilder-0.93_04, every time i made a search i have this
error:

error: Can’t call method “quote” on an undefined value at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm line 645.

context: …
640:
641: #if we’re explicitly told not to to quote the value or
642: # we’re doing an IS or IS NOT (null), don’t quote the operator.
643:
644: if ( $args{‘QUOTEVALUE’} && $args{‘OPERATOR’} !~ /IS/ ) {
645: $args{‘VALUE’} = $self->_Handle->dbh->quote( $args{‘VALUE’} );
646: }
647: }
648:

code stack: /usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder.pm:644
/usr/local/rt3/lib/RT/SearchBuilder.pm:132
/usr/local/rt3/lib/RT/Tickets_Overlay_SQL.pm:382
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:2007
/usr/local/rt3/lib/RT/Tickets_Overlay.pm:1722
/usr/local/rt3/share/html/Search/Listing.html:104
/usr/local/rt3/share/html/autohandler:189


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Me too. The exact same error with only two tickets existing in one of
two configured queues. Things appear to be fine after installing (via
the CPAN shell) DBIx-SearchBuilder-0.92.tar.gz on top of the 0.93 that
was already there.

I can’t duplicate this here. Can you tell me if there’s anything in
mysql’s error log, the httpd error log, the syslog or your rt log?

I can however deduce what’s going wrong. Attached is a version of
SearchBuilder/Handle.pm that spews a bunch of debugging output. Could
folks seeing this issue drop it in, stop and start apache and send me
the relevant logs about handles?

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Handle.pm (16.1 KB)