Got the following error message in our MantisBT. I looked into other reported Application Error 401's and database 1064 error's, but they seem to have been related to the name of the custom field including special characters ( parenthesis and hyphens). In this case however it was the string in the custom field that seems to be causing an issue. It's a little odd though, as the error only occurs on one login.
Code: Select all
Database query failed. Error received from database was #1064: 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 ''OSI (North America' 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_5 ON mantis_custom_field_string_table_5.bug_id = mantis_bug_table.id AND mantis_custom_field_string_table_5.field_id = 5 WHERE mantis_project_table.enabled = ? AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id = 288 ) AND (mantis_custom_field_string_table_5.value = 'OSI (North America?)').The entry in the database has since been changed to data without the '(', ')' or the '?' and no other users can generate the fault. The fault is generated regardless of physical machine he is connecting from ( ie logged into a laptop and tried it there too) so I assume that it is somehow related to his account. I have since tried re-setting the users preferences back to default, but this did not make a difference. Is there a manual way to reset the view issues page for the user without losing any other associated settings.