<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>RT gets jealous of my weekend vacation, goes bonkers</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>I left for a relaxing weekend at the lake with all things RT working just fine. I came back this morning and found that most superficial parts of WebRT were OK (the front page, the admin console, the statistics) but the Search and direct viewing of any ticket were broken. I stopped and started apache and mysql a few times, and that didn't help. I don't find any errors in the log files. Here is the error message I am getting in the browser:</FONT></P>
<BR>
<P><FONT SIZE=2>-------------------------------------------------</FONT>
<BR><FONT SIZE=2>Mason error</FONT>
<BR><FONT SIZE=2>error in file: /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm</FONT>
<BR><FONT SIZE=2> </FONT>
<BR><FONT SIZE=2>line 522: Can't call method "dbh" on an undefined value</FONT>
<BR><FONT SIZE=2>context: </FONT>
<BR><FONT SIZE=2>... </FONT>
<BR><FONT SIZE=2>518: #if we're explicitly told not to to quote the value or</FONT>
<BR><FONT SIZE=2>519: # we're doing an IS or IS NOT (null), don't quote the operator.</FONT>
<BR><FONT SIZE=2>520: </FONT>
<BR><FONT SIZE=2>521: </FONT>
<BR><FONT SIZE=2>522: if ($args{'QUOTEVALUE'} && $args{'OPERATOR'} !~ /IS/) {</FONT>
<BR><FONT SIZE=2>523: $args{'VALUE'} = $self->_Handle->dbh->quote($args{'VALUE'});</FONT>
<BR><FONT SIZE=2>524: }</FONT>
<BR><FONT SIZE=2>525: }</FONT>
<BR><FONT SIZE=2>526: </FONT>
<BR><FONT SIZE=2>... </FONT>
<BR><FONT SIZE=2>component stack: /Ticket/Elements/Tabs [standard]</FONT>
<BR><FONT SIZE=2>//Ticket/Display.html [standard]</FONT>
<BR><FONT SIZE=2>//autohandler [standard]</FONT>
<BR><FONT SIZE=2>code stack: /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:522</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/lib/RT/EasySearch.pm:95</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/lib/RT/Tickets.pm:1150</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/lib/RT/Tickets.pm:993</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/lib/RT/Tickets.pm:980</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/WebRT/data/obj/STANDARD/Ticket/Elements/Tabs:105</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/WebRT/data/obj/STANDARD//Ticket/Display.html:148</FONT>
<BR><FONT SIZE=2>/usr/local/rt2/WebRT/data/obj/STANDARD//autohandler:69</FONT>
</P>
<BR>
<P><FONT SIZE=2>raw error: </FONT>
</P>
<P><FONT SIZE=2>error while executing /Ticket/Elements/Tabs [standard]:</FONT>
<BR><FONT SIZE=2>Can't call method "dbh" on an undefined value at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 522, line 121.</FONT></P>
<P><FONT SIZE=2>HTML::Mason::Interp::__ANON__('Can\'t call method "dbh" on an undefined value at /usr/lib/perl5...') called at /usr/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm line 522</FONT></P>
<P><FONT SIZE=2>DBIx::SearchBuilder::Limit('RT::Tickets=HASH(0x904e8e0)', 'VALUE', 6, 'FIELD', 'Queue', 'ENTRYAGGREGATOR', 'OR', 'OPERATOR', ...) called at /usr/local/rt2/lib/RT/EasySearch.pm line 95</FONT></P>
<P><FONT SIZE=2>RT::EasySearch::Limit('RT::Tickets=HASH(0x904e8e0)', 'FIELD', 'Queue', 'ENTRYAGGREGATOR', 'OR', 'OPERATOR', '=', 'VALUE', ...) called at /usr/local/rt2/lib/RT/Tickets.pm line 1150</FONT></P>
<P><FONT SIZE=2>RT::Tickets::_ProcessRestrictions('RT::Tickets=HASH(0x904e8e0)') called at /usr/local/rt2/lib/RT/Tickets.pm line 993</FONT>
<BR><FONT SIZE=2>RT::Tickets::Next('RT::Tickets=HASH(0x904e8e0)') called at /usr/local/rt2/lib/RT/Tickets.pm line 980</FONT>
<BR><FONT SIZE=2>RT::Tickets::ItemsArrayRef('RT::Tickets=HASH(0x904e8e0)') called at /usr/local/rt2/WebRT/data/obj/STANDARD/Ticket/Elements/Tabs line 105</FONT></P>
<P><FONT SIZE=2>HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x907b3bc)', 'current_tab', 'Ticket/Display.html?id=25') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 131</FONT></P>
<P><FONT SIZE=2>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x907c14c)', 'Ticket', 'RT::Ticket=HASH(0x907b3bc)', 'current_tab', 'Ticket/Display.html?id=25') called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653</FONT></P>
<P><FONT SIZE=2>eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653</FONT>
<BR><FONT SIZE=2>HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9074840)', '/Ticket/Elements/Tabs', 'Ticket', 'RT::Ticket=HASH(0x907b3bc)', 'current_tab', 'Ticket/Display.html?id=25') called at /usr/local/rt2/WebRT/data/obj/STANDARD//Ticket/Display.html line 148</FONT></P>
<P><FONT SIZE=2>HTML::Mason::Commands::__ANON__('id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 131</FONT>
<BR><FONT SIZE=2>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x904f9dc)', 'id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653</FONT></P>
<P><FONT SIZE=2>eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653</FONT>
<BR><FONT SIZE=2>HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9074840)', 'HTML::Mason::Component::FileBased=HASH(0x904f9dc)', 'id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 316</FONT></P>
<P><FONT SIZE=2>HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x9074840)') called at /usr/local/rt2/WebRT/data/obj/STANDARD//autohandler line 69</FONT></P>
<P><FONT SIZE=2>HTML::Mason::Commands::__ANON__('id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Component.pm line 131</FONT>
<BR><FONT SIZE=2>HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8f4588c)', 'id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653</FONT></P>
<P><FONT SIZE=2>eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 653</FONT>
<BR><FONT SIZE=2>HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x9074840)', 'HASH(0x90749a8)', 'HTML::Mason::Component::FileBased=HASH(0x8f4588c)', 'id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 159</FONT></P>
<P><FONT SIZE=2>eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/Request.pm line 159</FONT>
<BR><FONT SIZE=2>HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x9074840)', '//Ticket/Display.html', 'id', 25) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 914</FONT></P>
<P><FONT SIZE=2>HTML::Mason::ApacheHandler::handle_request_1('HTML::Mason::ApacheHandler=HASH(0x83fa6f0)', 'Apache=SCALAR(0x8edae08)', 'HTML::Mason::Request::ApacheHandler=HASH(0x9074840)', undef) called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 560</FONT></P>
<P><FONT SIZE=2>eval {...} called at /usr/lib/perl5/site_perl/5.6.1/HTML/Mason/ApacheHandler.pm line 560</FONT>
<BR><FONT SIZE=2>HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x83fa6f0)', 'Apache=SCALAR(0x8edae08)') called at /usr/local/rt2/bin/webmux.pl line 165</FONT></P>
<P><FONT SIZE=2>RT::Mason::handler('Apache=SCALAR(0x8edae08)') called at /dev/null line 0</FONT>
<BR><FONT SIZE=2>eval {...} called at /dev/null line 0</FONT>
<BR><FONT SIZE=2>-------------------------------------------------</FONT>
</P>
<BR>
<P><FONT SIZE=2>I haven't monkeyed with the RT code in a while, so it seems pretty weird that this would crop up now.</FONT>
</P>
<P><FONT SIZE=2>I am still able to display tickets without any trouble on the command line.</FONT>
</P>
<P><FONT SIZE=2>I am running RT 2.0.11pre (basically 2.0.12 with a different version designation) against MySQL 3.23.47 on a Red Hat 7.1 box. This arrangement has worked smoothly for quite a few months.</FONT></P>
<P><FONT SIZE=2>Anyone got any ideas?</FONT>
</P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Kendric Beachey</FONT>
</P>
</BODY>
</HTML>