In addition to all of this we are not longer getting any emails into the database. Postfix and procmail are handling things as they have been but nothing is being entered into the DB
Keep up with me and what I'm up to: http://theillien.blogspot.com Ruslan Zakirov wrote: > Upgrade to the latest version of DBIx::SearchBuilder module. > > On Jan 22, 2008 1:46 AM, Mathew <[EMAIL PROTECTED]> wrote: >> We recently started getting this error which seems to be preventing incoming >> email from making it into the database: >> >> [Mon Jan 21 22:42:30 2008] [warning]: RT::Handle=HASH(0xadd9538) couldn't >> execute the query 'SELECT DISTINCT main.* FROM ((Tickets main JOIN Groups >> Groups_1 ON ((Groups_1.Domain = 'RT::Ticket-Role')) AND ( (Groups_1.Type = >> 'Requestor')) AND ( Groups_1.Instance = main.id)) LEFT JOIN >> CachedGroupMembers CachedGroupMembers_2 ON ( CachedGroupMembers_2.GroupId = >> Groups_1.id) AND ( (CachedGroupMembers_2.MemberId = Users_3.id))) , Users >> Users_3 WHERE ((Users_3.id = '60292')) AND ((main.EffectiveId = main.id)) >> AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( >> (CachedGroupMembers_2.id IS NOT NULL) ) AND ( (main.Status = 'open') OR >> (main.Status = 'new') ) ) ORDER BY main.Priority DESC LIMIT 10' at >> /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 >> >> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xadd9538)', >> 'SELECT DISTINCT main.* FROM ((Tickets main JOIN Groups Group...') called >> at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 231 >> DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0xb59cf20)') called >> at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 491 >> DBIx::SearchBuilder::Next('RT::Tickets=HASH(0xb59cf20)') called at >> /usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2670 >> RT::Tickets::Next('RT::Tickets=HASH(0xb59cf20)') called at >> /usr/local/rt3/share/html/Ticket/Elements/ShowRequestor line 74 >> HTML::Mason::Commands::__ANON__() called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1315 >> >> HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') >> called at /usr/local/rt3/share/html/Widgets/TitleBox line 51 >> HTML::Mason::Commands::__ANON__('title_href', 'undef', 'title', >> 'More about [EMAIL PROTECTED]') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135 >> >> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb33a0dc)', >> 'title_href', 'undef', 'title', 'More about [EMAIL PROTECTED]') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245 >> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title_href', >> 'undef', 'title', 'More about [EMAIL PROTECTED]') called at >> /usr/local/rt3/share/html/Ticket/Elements/ShowRequestor line 83 >> HTML::Mason::Commands::__ANON__('Ticket', >> 'RT::Ticket=HASH(0xb59d67c)') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135 >> >> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb595ae4)', >> 'Ticket', 'RT::Ticket=HASH(0xb59d67c)') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245 >> HTML::Mason::Request::comp('undef', 'undef', 'Ticket', >> 'RT::Ticket=HASH(0xb59d67c)') called at >> /usr/local/rt3/share/html/Ticket/Elements/ShowSummary line 72 >> HTML::Mason::Commands::__ANON__('Ticket', >> 'RT::Ticket=HASH(0xb59d67c)', 'Attachments', >> 'RT::Attachments=HASH(0xb578d7c)') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135 >> >> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb581864)', >> 'Ticket', 'RT::Ticket=HASH(0xb59d67c)', 'Attachments', >> 'RT::Attachments=HASH(0xb578d7c)') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245 >> HTML::Mason::Request::comp('undef', 'undef', 'Ticket', >> 'RT::Ticket=HASH(0xb59d67c)', 'Attachments', >> 'RT::Attachments=HASH(0xb578d7c)') called at >> /usr/local/rt3/share/html/Ticket/Display.html line 58 >> HTML::Mason::Commands::__ANON__() called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1315 >> >> HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') >> called at /usr/local/rt3/share/html/Widgets/TitleBox line 51 >> HTML::Mason::Commands::__ANON__('title', 'Ticket metadata') called >> at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135 >> >> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb33a0dc)', >> 'title', 'Ticket metadata') called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245 >> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title', >> 'Ticket metadata') called at /usr/local/rt3/share/html/Ticket/Display.html >> line 59 >> HTML::Mason::Commands::__ANON__('id', 112208) called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135 >> >> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb5823b0)', >> 'id', 112208) called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1251 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245 >> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'id', 112208) >> called at /usr/local/rt3/share/html/autohandler line 291 >> HTML::Mason::Commands::__ANON__('id', 112208) called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135 >> >> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb12686c)', >> 'id', 112208) called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1246 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245 >> HTML::Mason::Request::comp('undef', 'undef', 'undef', 'id', 112208) >> called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459 >> eval {...} called at >> /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 411 >> >> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') >> called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line >> 168 >> >> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xb5655ac)') >> called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line >> 826 >> >> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xa41827c)', >> 'Apache2::RequestRec=SCALAR(0xb58b3dc)') called at >> /usr/local/rt3/bin/webmux.pl line 125 >> eval {...} called at /usr/local/rt3/bin/webmux.pl line 125 >> RT::Mason::handler('Apache2::RequestRec=SCALAR(0xb58b3dc)') called >> at -e line 0 >> eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272) >> >> >> Emails are coming into our system but not being handled properly. Can >> anyone shed some light on this? >> >> -- >> Keep up with my goings on at http://theillien.blogspot.com >> _______________________________________________ >> 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 >> > > > _______________________________________________ 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
