Sorting by due date causes APPLICATION ERROR #401
Posted: 04 Oct 2010, 18:31
I clicked on "Due Date" to have it sort by due date and now I just get this error message. Unfortunately some of our users have done this as well today and now can't view issues.
APPLICATION ERROR #401
Database query failed. Error received from database was #1052: Column 'due_date' in order clause is ambiguous for the query: SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted, mantis_custom_field_string_table_4.value due_date FROM mantis_bug_text_table, mantis_project_table, mantis_bug_table LEFT JOIN mantis_bugnote_table ON mantis_bug_table.id = mantis_bugnote_table.bug_id LEFT JOIN mantis_bugnote_text_table ON mantis_bugnote_table.bugnote_text_id = mantis_bugnote_text_table.id LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_4 ON mantis_bug_table.id = mantis_custom_field_string_table_4.bug_id AND mantis_custom_field_string_table_4.field_id = 4 WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id = 46 ) AND mantis_bug_table.bug_text_id = mantis_bug_text_table.id AND ( ( (summary LIKE ?) OR (mantis_bug_text_table.description LIKE ?) OR (mantis_bug_text_table.steps_to_reproduce LIKE ?) OR (mantis_bug_text_table.additional_information LIKE ?) OR (mantis_bugnote_text_table.note LIKE ?) ) ) ORDER BY sticky DESC, due_date DESC, mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC.