View Issue Details

IDProjectCategoryView StatusLast Update
0027117mantisbtadministrationpublic2020-08-01 11:02
Reporteratrol Assigned Toatrol  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
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

Issue History

Date Modified Username Field Change
2020-07-31 17:11 atrol New Issue
2020-07-31 17:11 atrol Status new => assigned
2020-07-31 17:11 atrol Assigned To => atrol
2020-07-31 17:12 atrol Description Updated View Revisions
2020-07-31 17:12 atrol Description Updated View Revisions
2020-07-31 17:13 atrol Relationship added related to 0012677
2020-07-31 17:19 atrol Note Added: 0064213
2020-08-01 11:02 dregad Changeset attached => MantisBT master bd2015ec
2020-08-01 11:02 dregad Changeset attached => MantisBT master 8dd82126
2020-08-01 11:02 atrol Status assigned => resolved
2020-08-01 11:02 atrol Resolution open => fixed
2020-08-01 11:02 atrol Fixed in Version => 2.25.0