319993 - Can't sort on Deadline in Bug List

Status: RESOLVED DUPLICATE of bug 289602

(Bugzilla :: Query/Bug List, defect)

Description

[Fred Brunner]

User-Agent:       Mozilla/5.0 (Macintosh; U; PPC Mac OS X Mach-O; en-US; rv:1.7.12) Gecko/20050915
Build Identifier: 

Time tracking has to be turned on (obviously). When the Deadline field is shown in the query bug list and the header link is clicked, the following error is generated.


"Invalid Column Name

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: http://bugzilla.bridgeport-networks.com/buglist.cgi?query_format=advanced&short_desc_type=allwordssubstr&short_desc=&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&keywords_type=allwords&keywords=&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&emailassigned_to1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailqa_contact2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&chfieldfrom=7d&chfieldto=Now&chfieldvalue=&field0-0-0=noop&type0-0-0=noop&value0-0-0=&order=DATE_FORMAT%28bugs.deadline%2C%20%27%25Y-%25m-%25d%27%29%20AS%20deadline,bugs.bug_id&query_based_on=New%20Last%207%20Days
The custom sort order specified in your form submission contains an invalid column name DATE_FORMAT(bugs.deadline"

Reproducible: Always




This installation was upgraded via CVS label for 2.20 and then running checksetup.pl from a 2.19.3 install. We had been using the time tracking feature in 2.19.

Note that we can enter deadlines and see them in the query list, just not sort....

Comment 1

[Marc Schumann [:Wurblzap]]

*** This bug has been marked as a duplicate of 289602 ***