38788 - Query is busted.

Status: VERIFIED FIXED

(Bugzilla :: Bugzilla-General, defect, P3)

Description

[Matthew Tuck [:CodeMachine]]

Bugzilla queries aren't working.  Apparently they broke somewhere between now
and 8 hours ago.  Not sure whether this is a moz.org or Bugzilla problem,
although there are no recent checkins to the Bugzilla tree that I can see.

Very likely related to bug #38784.

Here's an error:

Content-type: text/html 

Software error:

SELECT bugs.bug_id, bugs.groupset, date_format(bugs.delta_ts,'%Y-%m-%d'),
map_assigned_to.login_name,
substring(bugs.bug_status,1,4), substring(bugs.resolution,1,4),
substring(bugs.product, 1, 8), bugs.votes,
bugs.target_milestone, substring(bugs.short_desc, 1, 60) FROM bugs, profiles
map_assigned_to, profiles
map_reporter LEFT JOIN profiles map_qa_contact ON bugs.qa_contact =
map_qa_contact.userid WHERE
bugs.assigned_to = map_assigned_to.userid AND bugs.reporter =
map_reporter.userid AND bugs.groupset & 192 =
bugs.groupset AND (bugs.product = 'Webtools') AND (bugs.bug_status = 'RESOLVED')
GROUP BY bugs.bug_id ORDER
BY bugs.bug_id: Table 'shadow_bugs.bugs' doesn't exist at globals.pl line 133. 

Please send mail to this site's webmaster for help.

Comment 1

[R.K.Aa.]

Also, when submitting changes to a bug you get:

Software error:

DELETE FROM logincookies WHERE TO_DAYS(NOW()) - TO_DAYS(lastused) > 30:
Table
'shadow_bugs.logincookies' doesn't exist at globals.pl line 133. 

Please send mail to this site's webmaster for help.

Comment 2

[Matthew Tuck [:CodeMachine]]

That is bug #38784, as stated.

Comment 3

[Matthew Tuck [:CodeMachine]]

Fixed, assumedly along with bug #38784.

Comment 4

[R.K.Aa.]

v

Comment 5

[Dave Miller [:justdave]]

In search of accurate queries....  (sorry for the spam)

Comment 6

[Dave Miller [:justdave]]

Moving closed bugs to Bugzilla product