[rt-users] MySQL error on 3.6.6

Jay Kline slushpupie at gmail.com
Fri May 9 15:59:33 EDT 2008 

Ive noticed an error in my RT log about a failed MySQL statement.  This
only shows up when I view a ticket (eg /rt/Ticket/Display.html?id=42)
but not all tickets.  It seems to only happen for certain requesters. 
The query in question is:

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 = '54')) 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;

The error is:

Unknown column 'Users_3.id' in 'on clause'

My SQL isnt quite good enough to understand all the join's in that
statement.  Any ideas where to begin on this one?

Thanks,

Jay


Full output from the logs follows (beware linewrapping)

[Fri May  9 18:03:06 2008] [warning]: DBD::mysql::st execute failed:
Unknown column 'Users_3.id' in 'on clause' at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 505.
(/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:505)
[Fri May  9 18:03:06 2008] [warning]: RT::Handle=HASH(0x9766528)
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 = '54')) 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/share/perl5/DBIx/SearchBuilder/Handle.pm line 518
   
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x9766528)',
'SELECT DISTINCT main.* FROM ((Tickets main  JOIN Groups Group...')
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 231
    DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0xa7e26c0)') called
at /usr/share/perl5/DBIx/SearchBuilder.pm line 491
    DBIx::SearchBuilder::Next('RT::Tickets=HASH(0xa7e26c0)') called at
/usr/share/request-tracker3.6/lib/RT/Tickets_Overlay.pm line 2670
    RT::Tickets::Next('RT::Tickets=HASH(0xa7e26c0)') called at
/usr/share/request-tracker3.6/html/Ticket/Elements/ShowRequestor line 74
    HTML::Mason::Commands::__ANON__() called at
/usr/share/perl5/HTML/Mason/Request.pm line 1329
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1329
   
HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xa696494)')
called at /usr/share/request-tracker3.6/html/Widgets/TitleBox line 51
    HTML::Mason::Commands::__ANON__('title_href',
'/rt/Admin/Users/Modify.html?id=54', 'title', 'More about
jay.kline at gmail.com') called at /usr/share/perl5/HTML/Mason/Component.pm
line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa5d4e14)',
'title_href', '/rt/Admin/Users/Modify.html?id=54', 'title', 'More about
jay.kline at gmail.com') called at /usr/share/perl5/HTML/Mason/Request.pm
line 1256
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
    HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title_href',
'/rt/Admin/Users/Modify.html?id=54', 'title', 'More about
jay.kline at gmail.com') called at
/usr/share/request-tracker3.6/html/Ticket/Elements/ShowRequestor line 83
    HTML::Mason::Commands::__ANON__('Ticket',
'RT::Ticket=HASH(0xa70b294)') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa7d61d4)',
'Ticket', 'RT::Ticket=HASH(0xa70b294)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1256
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
    HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0xa70b294)') called at
/usr/share/request-tracker3.6/html/Ticket/Elements/ShowSummary line 72
    HTML::Mason::Commands::__ANON__('Ticket',
'RT::Ticket=HASH(0xa70b294)', 'Attachments',
'RT::Attachments=HASH(0xa762bdc)') called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa79959c)',
'Ticket', 'RT::Ticket=HASH(0xa70b294)', 'Attachments',
'RT::Attachments=HASH(0xa762bdc)') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1256
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
    HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0xa70b294)', 'Attachments',
'RT::Attachments=HASH(0xa762bdc)') called at
/usr/share/request-tracker3.6/html/Ticket/Display.html line 58
    HTML::Mason::Commands::__ANON__() called at
/usr/share/perl5/HTML/Mason/Request.pm line 1329
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1329
   
HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0xa696494)')
called at /usr/share/request-tracker3.6/html/Widgets/TitleBox line 51
    HTML::Mason::Commands::__ANON__('title', 'Ticket metadata') called
at /usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa5d4e14)',
'title', 'Ticket metadata') called at
/usr/share/perl5/HTML/Mason/Request.pm line 1256
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
    HTML::Mason::Request::comp('undef', 'undef', 'undef', 'title',
'Ticket metadata') called at
/usr/share/request-tracker3.6/html/Ticket/Display.html line 59
    HTML::Mason::Commands::__ANON__('id', 2) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa663560)',
'id', 2) called at /usr/share/perl5/HTML/Mason/Request.pm line 1256
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
    HTML::Mason::Request::comp('undef', 'undef', 'undef', 'id', 2)
called at /usr/share/request-tracker3.6/html/autohandler line 291
    HTML::Mason::Commands::__ANON__('id', 2) called at
/usr/share/perl5/HTML/Mason/Component.pm line 135
   
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa41cc40)',
'id', 2) called at /usr/share/perl5/HTML/Mason/Request.pm line 1251
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 1246
    HTML::Mason::Request::comp('undef', 'undef', 'undef', 'id', 2)
called at /usr/share/perl5/HTML/Mason/Request.pm line 460
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 460
    eval {...} called at /usr/share/perl5/HTML/Mason/Request.pm line 412
   
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa696494)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
   
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa696494)')
called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 832
   
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x971580c)',
'Apache2::RequestRec=SCALAR(0xa695d5c)') called at
/usr/share/request-tracker3.6/libexec/webmux.pl line 125
    eval {...} called at /usr/share/request-tracker3.6/libexec/webmux.pl
line 125
    RT::Mason::handler('Apache2::RequestRec=SCALAR(0xa695d5c)') called
at -e line 0
    eval {...} called at -e line 0 (/usr/share/perl/5.8/Carp.pm:105)

More information about the rt-users mailing list