364515 - SQL error after logging in to see hidden bug

Status: RESOLVED FIXED

(bugzilla.mozilla.org :: General, defect)

Description

[Jesse Ruderman]

I got this error when I logged into bugzilla-test in order to view bug 306939.  (I logged in using the link in an error message saying I couldn't view bug 306939, or maybe its dependency tree.)

Bugzilla has suffered an internal error. Please save this page and send it to [e-mail] with details of what you were doing at the time this message appeared.

URL: https://bugzilla-test.mozilla.org/show_bug.cgi

undef error - DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM bugs_activity INNER JOIN fielddefs ON bugs_activity.fieldid = fielddefs.fie' at line 1 [for Statement "SELECT who FROM bugs_activity FROM bugs_activity INNER JOIN fielddefs ON bugs_activity.fieldid = fielddefs.fieldid WHERE fielddefs.name = 'bug_file_loc' AND bugs_activity.bug_id = ? ORDER BY bug_when DESC"] at Bugzilla/Bug.pm line 959 Bugzilla::Bug::bug_file_loc_changer('Bugzilla::Bug=HASH(0xaaa5724)') called at data/template/template/en/default/bug/edit.html.tmpl line 107 eval {...} called at data/template/template/en/default/bug/edit.html.tmpl line 107 eval {...} called at data/template/template/en/default/bug/edit.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0xa97de34)') called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0xac92270)', 'Template::Context=HASH(0xa97de34)') called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 350 eval {...} called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 320 Template::Context::process('Template::Context=HASH(0xa97de34)', 'bug/edit.html.tmpl') called at data/template/template/en/default/bug/show.html.tmpl line 94 eval {...} called at data/template/template/en/default/bug/show.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0xa97de34)') called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0xaaa52f8)', 'Template::Context=HASH(0xa97de34)') called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 350 eval {...} called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Context.pm line 320 Template::Context::process('Template::Context=HASH(0xa97de34)', 'Template::Document=HASH(0xaaa52f8)') called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Service.pm line 97 eval {...} called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template/Service.pm line 94 Template::Service::process('Template::Service=HASH(0xa9039c0)', 'bug/show.html.tmpl', 'HASH(0x9e16c28)') called at /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi/Template.pm line 71 Template::process('Bugzilla::Template=HASH(0xa902494)', 'bug/show.html.tmpl', 'HASH(0x9e16c28)') called at /opt/webtools/bugzilla-test/show_bug.cgi line 138

Comment 1

[Frédéric Buclin]

SELECT who FROM bugs_activity FROM bugs_activity INNER JOIN fielddefs ON
bugs_activity.fieldid = fielddefs.fieldid WHERE fielddefs.name = 'bug_file_loc'
AND bugs_activity.bug_id = ? ORDER BY bug_when DESC"] at Bugzilla/Bug.pm line
959 Bugzilla::Bug::bug_file_loc_changer

bug_file_loc_changer() doesn't exist in the official Bugzilla 3.0. This is a hack reed wrote for b.m.o.

Comment 2

[Reed Loden [:reed]]

Fixed on prodpatches. Not sure when bugzilla-test will get the fix.