We're using cookies to make this site more secure, featureful and efficient.

Issue 546: Quick Search does not locate some entries easily

St Andrew's Fair (Dance)
James Wilson
Assigned to
Anselm Lingnau
Needs help

This dance is not easy to locate in the database. As a programmer, I am intrigued by this. Instead you have to give it a search phrase such as: andrew and scroll through a number of approximate matches.

The Montgomeries’ Rant has the same problem. Is there a work around / fix for this ?

Previous Actions

  • Date  Nov. 4, 2014, 5:07 p.m.
  • User  Unknown

New issue submitted

  • Date  Nov. 4, 2014, 11:50 p.m.
  • User  Anselm Lingnau (anselm)

Assigned changed to »anselm« (previously »None«)
Disposition changed to »Needs help« (previously »New«)

I just searched for “St Andrew’s Fair“ using the quick-search facility and the correct dance did come up as an exact match. (However this requires you to get the apostrophe just right, which is probably less than optimal.) The same applies to “The Montgomeries’ Rant“.

Can you explain in more detail exactly which search facility (out of the several on offer) you tried – the quick search, the complex search, or the search box at the top right of the overview tables? Exactly what did you enter and what result did you expect? Thank you for your trouble, and sorry for any inconvenience.

  • Date  Nov. 5, 2014, 12:30 a.m.
  • User  Eric Ferguson (EricFerguson)

Hi Anselm. Could it be due to the different codes used to represent apostrophe’s? A search with " Montgomeries’ " typed in works OK. If I copy "Montgomeries’ " from a Word document (that apostrophe looks like a lone acute accent) the search fails.

Suggestion: make all “apostrophe” codes work alike throughout the site. Eric

  • Date  Nov. 5, 2014, 12:32 a.m.
  • User  Anselm Lingnau (anselm)

That sounds eminently plausible. I do try to sanitise input strings when they are written to the database, but AFAIR not for the search boxes. I should probably add that at some point.