APPLICATION ERROR #401
Posted: 14 Apr 2011, 03:21
Mantis version 1.2.3
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.
To replicate the error, we select the project that has the custom field enabled and select View Issues. This causes the error to pop up 100% of the time for the user. This does not happen if he selects All Projects, but no matter the order of selected pages etc, the combination of the specific project and the View Issues page generates the issue.
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.
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.