View Issue Details

IDProjectCategoryView StatusLast Update
0027117mantisbtadministrationpublic2021-03-07 18:29
Reporteratrol Assigned Toatrol  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Product Version2.17.0 
Target Version2.25.0Fixed in Version2.25.0 
Summary0027117: SQL syntax error on manage_user_page
Description

If no search terms can be generated from the search string (e.g. a single quote) on manage_user_page,
pushing the Apply Filter button throws

APPLICATION ERROR # 401

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 ') AND enabled = '1'' at line 1 for the query: SELECT count(*) as user_count FROM mantis_user_table WHERE (1 = 1) AND ( ) AND enabled = ?.
Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
TagsNo tags attached.

Relationships

related to 0012677 closedatrol Please change a search option to manage users 

Activities

Related Changesets

MantisBT: master bd2015ec

2020-07-31 16:45:05

atrol


Committer: dregad Details Diff
Whitespace

Issue 0027117
Affected Issues
0027117
mod - manage_user_page.php Diff File

MantisBT: master 8dd82126

2020-07-31 16:48:47

atrol


Committer: dregad Details Diff
Fix SQL syntax error on manage_user_page

Fixes 0027117
Affected Issues
0027117
mod - manage_user_page.php Diff File