[rt-users] Quick Searches are empty
Bryon Baker
bbaker at copesan.com
Tue Apr 1 10:18:23 EDT 2014
Good morning need help quickly please
Came in this morning and all the Quick search are not showing any data.
[cid:image001.png at 01CF4D8A.F8E33860]
If I click anywhere in the quick search box the searches are working meaning I get a list of tickets.
This is also happening on all of the Quick searches I have defined.
I also look in the var directory and found a lot of directories see below.
[cid:image002.png at 01CF4D8B.1F6B43B0]
This is just a small list.
Here is a part of the RT log after a restart which does not look normal.
[26474] [Tue Apr 1 14:11:25 2014] [warning]: RT::Handle=HASH(0x8a1a460) couldn't execute the query 'SELECT main.Status AS status, main.Queue AS queue, COUNT(DISTINCT main.id) AS id FROM Tickets main WHERE (main.IsMerged IS NULL) AND (main.Status != 'deleted') AND (main.Type = 'ticket') AND ( ( main.Status = 'new' OR main.Status = 'assigned' OR main.Status = 'opened' OR main.Status = 'evaluation' OR main.Status = 'closed' ) AND ( main.Queue = '15' OR main.Queue = '16' OR main.Queue = '21' OR main.Queue = '17' OR main.Queue = '10' OR main.Queue = '18' OR main.Queue = '19' OR main.Queue = '25' OR main.Queue = '20' OR main.Queue = '12' OR main.Queue = '4' OR main.Queue = '14' OR main.Queue = '13' ) ) GROUP BY main.Status, main.Queue ' at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder/Handle.pm line 602.
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8a1a460)', 'SELECT main.Status AS status, main.Queue AS queue, COUNT(DIST...') called at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/SearchBuilder.pm line 990
RT::SearchBuilder::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Tickets.pm line 2374
RT::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Report/Tickets.pm line 563
RT::Report::Tickets::_DoSearch('RT::Report::Tickets=HASH(0x8acc040)') called at /usr/lib/perl5/site_perl/5.16.2/DBIx/SearchBuilder.pm line 507
DBIx::SearchBuilder::Next('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/sbin/../lib/RT/Report/Tickets.pm line 603
RT::Report::Tickets::Next('RT::Report::Tickets=HASH(0x8acc040)') called at /opt/rt4/share/html/Elements/QueueSummaryByLifecycle line 157
HTML::Mason::Commands::__ANON__('queue_filter', 'CODE(0x8f91d90)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8fed3c8)', 'queue_filter', 'CODE(0x8f91d90)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, 'queue_filter', 'CODE(0x8f91d90)') called at /opt/rt4/share/html/Elements/Quicksearch line 58
HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1383
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1383
HTML::Mason::Request::content('RT::Interface::Web::Request=HASH(0x8920180)') called at /opt/rt4/share/html/Widgets/TitleBox line 56
HTML::Mason::Commands::__ANON__('title', 'Quick search', 'bodyclass', '', 'titleright', 'Edit', 'titleright_href', '/rt/Prefs/Quicksearch.html') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8e56f88)', 'title', 'Quick search', 'bodyclass', '', 'titleright', 'Edit', 'titleright_href', '/rt/Prefs/Quicksearch.html', ...) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, 'title', 'Quick search', 'bodyclass', '', 'titleright', 'Edit', ...) called at /opt/rt4/share/html/Elements/Quicksearch line 58
HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x1af9bc8)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/share/html/Elements/MyRT line 97
HTML::Mason::Commands::__ANON__('HASH(0x8ac8308)') called at /opt/rt4/share/html/Elements/MyRT line 58
HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8dddd90)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef) called at /opt/rt4/share/html/index.html line 78
HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a3b558)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1305
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 680
RT::Interface::Web::ShowRequestedPage('HASH(0x8b1ab60)') called at /opt/rt4/sbin/../lib/RT/Interface/Web.pm line 368
RT::Interface::Web::HandleRequest('HASH(0x8b1ab60)') called at /opt/rt4/share/html/autohandler line 53
HTML::Mason::Commands::__ANON__() called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a5b958)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1300
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 484
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 484
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x8920180)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 96
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 96
HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x8920180)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/Interp.pm line 345
HTML::Mason::Interp::exec(undef, undef) called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 59
eval {...} called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler.pm line 59
HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x89a7018)', 'HASH(0x8a6fcc8)', 'HASH(0x8a6fd40)') called at /usr/lib/perl5/site_perl/5.16.2/HTML/Mason/PSGIHandler/Streamy.pm line 52
HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x8ac9c20)') called at /opt/rt4/sbin/../lib/RT/Interface/Web/Handler.pm line 307
RT::Interface::Web::Handler::__ANON__('CODE(0x8ac9c20)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Util.pm line 301
Plack::Util::__ANON__('CODE(0x8bc0648)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Handler/FCGI.pm line 136
Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x89d5e70)', 'CODE(0x89c7868)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Loader.pm line 84
Plack::Loader::run('Plack::Loader=HASH(0x89c7550)', 'Plack::Handler::FCGI=HASH(0x89d5e70)') called at /usr/lib/perl5/site_perl/5.16.2/Plack/Runner.pm line 277
Plack::Runner::run('RT::PlackRunner=HASH(0x85ff8b0)') called at /opt/rt4/sbin/../lib/RT/PlackRunner.pm line 141
eval {...} called at /opt/rt4/sbin/../lib/RT/PlackRunner.pm line 141
I have not rebooted the server yet but at this point that is next.
Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726 * 262-783-6261 ext. 2296
bbaker at copesan.com
www.copesan.com
"Servicing North America with Local Care"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140401/3343e107/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 13303 bytes
Desc: image001.png
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140401/3343e107/attachment.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 13116 bytes
Desc: image002.png
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20140401/3343e107/attachment-0001.png>
More information about the rt-users
mailing list