Hello, I've encountered a bug: when referer keyword is a of some exotic language (georgian in my case), search by keyword can't find any of those georgian words, while they are displayed correctly in initial list of keywords.
I think the problem is more global, and is caused by incorrect collation of database. The solution, as fas as I can see, is to add an option of selecting db collation in installation procedure of Piwik, or just setting it staticaly to utf8_unicode_ci
Hope this information was helpful :)
Keywords: keyword search database collation
_Hitman47, did you try changing the collation of your tables? Did it work better then? Thanks
hey Matt, I've changed the collation of all tables and fields in piwik db to unicode, but the problem is still there :( so, i'm going to log the queries that piwik sends to mysql server and I'll write here as soon as I get any result.
Digging up mysql logs didn't gave any result, I couldn't find any query mentioning the word I specified in keyword search, neither english, nor georgian. But while I was browsing piwik database I found that referer_keyword is stored in url format, so, actually, the issue can be even not associated with database collation, more possibly - with php logic behind the search process - maybe someone forgot to apply urlencode to search phrase before using it in sql query?
hitman, please post a comment in #435 giving example of georgians earch engine for which searching the keywords don't work in piwik. we really want to fix this issue. thanks!