see also 0005859, 0008323

I installed Version 1.2.1 but the problem isn't solved.

same problem here. filter on custom field also crashes with sql-error.

This is the problem:

mantis_custom_field_string_table_1.value responsibility --> missing AS
mantis_custom_field_string_table_1.value AS responsibility

Winthin version 1.2.4 this is also a problem:

mantis_project_table.enabled = 't' instead of mantis_project_table.enabled = 1

Custom-fileds must not contain minus and dots, this will also generate problems within SQL-STring for Postgress

Solve the problem:

filter_api.php line 922:

$t_cf_select = "$t_cf_table_alias.value $c_cf_alias";
Bugfix:
$t_cf_select = "$t_cf_table_alias.value AS $c_cf_alias";

the error persists in version 1.2.8

with the bugfix from schoppi only custom fields which are not as type of "list" get sorted. can you confirm this?

the sql error with custom fields of type "list" is:
ERROR: ORDER BY "status" is ambiguous at character 544 for the query: SELECT DISTINCT mantis_bug_table.*, mantis_bug_table.last_updated, mantis_bug_table.date_submitted, mantis_custom_field_string_table_7.value AS status FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_7 ON mantis_bug_table.id = mantis_custom_field_string_table_7.bug_id AND mantis_custom_field_string_table_7.field_id = 7 WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id = 5 ) ORDER BY status ASC, mantis_bug_table.last_updated DESC, mantis_bug_table.date_submitted DESC

This issue is not reproducible with the current version of MantisBT.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem persists, do not hesitate to reopen the issue, with additional relevant information.

[1] http://www.mantisbt.org/download.php