APPLICATION ERROR 0000401

[santy143all]

Hi i am using a custom due date filter where when i filter by it shows error as below of application error

APPLICATION ERROR 0000401

Database query failed. Error received from database was 0001064: 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 'AND 86398)' at line 1 for the query: SELECT Count( DISTINCT mantis_bug_table.id ) as idcnt FROM mantis_project_table, mantis_bug_table LEFT JOIN mantis_custom_field_string_table mantis_custom_field_string_table_1 ON mantis_bug_table.id = mantis_custom_field_string_table_1.bug_id AND mantis_custom_field_string_table_1.field_id = 1 WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id = 68 ) AND ( mantis_bug_table.status in (?, ?, ?) ) AND ( (mantis_custom_field_string_table_1.value+0) BETWEEN AND 86398).


Can anyone please help me in same.

[Lapinkiller]

Hello,

which version of Mantis are you using ?