Additional error prior to the one below: [Mon Jan 21 23:05:37 2008] [warning]: DBD::mysql::st execute failed: Unknown column 'Users_3.id' in 'on clause' at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505. (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
Keep up with my goings on at http://theillien.blogspot.com Mathew 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? > _______________________________________________ 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
