Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#209 FullTextSearch fails to find words with uppercase characters

closed
nobody
Postgresql (18)
5
2012-10-11
2003-10-12
Gerard H. Pille
No

Hallo,

phpwiki's fulltextsearch seems to have trouble finding
names.

I have eg. a page with info about "author Axel Bouts".

I can't find Axel, I can't find Bouts, but there is no
problem with author.

The pages are stored in a 7.2.1 postgresql.

Thanks,

Gerard

Discussion

  • Logged In: YES
    user_id=105708

    Had to change ./lib/WikiDB/backend/PearDB.php:

    line 482:

       return "LOWER(pagename) LIKE '%$word%' OR
    

    LOWER(content) LIKE '%$word%'";

    without the "LOWER(content)", words with uppercase
    characters could never be found.