View Issue Details

IDProjectCategoryView StatusLast Update
0009508mantisbtfilterspublic2009-01-15 11:26
Reportermdelmarter Assigned Todaryn  
PrioritynormalSeveritytextReproducibilityalways
Status closedResolutionfixed 
Product Version1.2.0a2 
Fixed in Version1.2.0a3 
Summary0009508: Adding Filters with Apostrophe saves Backslash in the database
Description

I am using Mantis with MySQL 5.0. When I add a new Filter with an apostrophe it saves a backslash in the database which then is displayed when viewing the filter dropdown.

TagsNo tags attached.
Attached Files
nicenclean.png (7,508 bytes)   
nicenclean.png (7,508 bytes)   

Activities

giallu

giallu

2008-08-11 10:53

reporter   ~0019108

It is surely a good thing that the quote char got escaped in the DB; what is not right is that the backslash got escaped again so you can see it.

daryn

daryn

2008-08-11 13:22

reporter   ~0019112

This needs a bit more clarification I think. What do you mean by 'Adding filters'? Are you referring to a stored filter where the name of the filter has an apostrophe or something else?

giallu

giallu

2008-08-12 02:51

reporter   ~0019120

Last edited: 2008-08-12 02:52

Adding == saving a new filter.

Probably a picture is easier to understand, I just saved in my local instance a filter naming it "nice'n'clean"

mdelmarter

mdelmarter

2008-08-12 05:00

reporter   ~0019121

Thanks giallu, thats the exact behaviour I was trying to describe.

Out of interest an earlier version of Mantis sitting on top of a postgres database does not save the slashes to the database. I am not sure if it is the newer version that has caused the problem, or it is the difference in the database that is causing the issue. (I am now using MySQL).

Maybe that gives some clues, maybe not...

daryn

daryn

2008-08-12 09:56

reporter   ~0019123

Last edited: 2008-08-12 13:46

Fixed double string escape in filter api. This only fixes new saved filters.

http://mantisbt.svn.sourceforge.net/viewvc/mantisbt?view=rev&revision=5506

Related Changesets

MantisBT: master 38c27ffb

2008-08-12 09:54

daryn


Details Diff
Fix for bug 0009508. Double string escape for stored query name

git-svn-id: http://mantisbt.svn.sourceforge.net/svnroot/mantisbt/trunk@5506 <a class="text" href="/?p=mantisbt.git;a=object;h=f5dc347c">f5dc347c</a>-c33d-0410-90a0-b07cc1902cb9
Affected Issues
0009508
mod - core/filter_api.php Diff File