Searching problem - characters being returned.

[essaytee]

I've installed Coppermine 1.5.   Testing the search feature, I enter a single character, "1", searching against the default set (title, keywords etc.).   The problem is that where "1" is in the keyword ie "2010" it's being returned as a result, which shouldn't be the case.

I tag many photos with the bib number of runners & cyclists.   Sometimes bib numbers are single digits as opposed to three or more digits.

Any clues or suggestions please.

[Αndré]

Untested: open include/search.inc.php, find

Code Select Expand

if (in_array($param, $allowed)) $fields[] = "$param LIKE '%$word%'";
and replace with

Code Select Expand

if (in_array($param, $allowed)) $fields[] = "$param = '$word'";

Maybe you have to replace

Code Select Expand

if (in_array($param, $allowed)) $fields[] = "$param LIKE '%$string%'";
with

Code Select Expand

if (in_array($param, $allowed)) $fields[] = "$param = '$string'";
additionally.

[essaytee]

Thanks, I'll give that a try.