View Issue Details

IDProjectCategoryView StatusLast Update
0002501AJAX/JSBug Report - Interfacepublic2016-08-30 09:58
ReporterBelove Assigned ToDerIdiot  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Fixed in Version2016-09 
Summary0002501: search box does not support apostrophe for ajax/search-as-you-type Anime results (anidb.pl)
DescriptionSearch-as-you-type (ajax) in anidb.pl search box (at top of most pages) does not support apostrophe (something wrong with associated conversion to backtick/acute?) (possible SQL security risk?).

Using an apostrophe in the search box gives no ajax search results, although proceeding to the results page works.
Backtick itself works fine with ajax search results, though, as expected.

As far as I can see, the ajax results only apply to Anime searches, but if I'm wrong, the issue may relate to other types of searches as well.
Steps To Reproduce1) Select category
anime
by the Search box
2) type
d's
in the Search box
3) notice the message "no matching entries found"
------------------
4) replace your search with
d`s

5) notice that this gives immediate results, as expected
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-05-20 10:05 Belove New Issue
2016-07-10 06:36 CDB-Man Project HTML & PERL => AJAX/JS
2016-08-15 18:34 DerIdiot Assigned To => DerIdiot
2016-08-15 18:34 DerIdiot Status new => resolved
2016-08-15 18:34 DerIdiot Resolution open => fixed
2016-08-30 09:58 DerIdiot Fixed in Version => 2016-09