Simply put: the module will not work for filters based on some words ending with an accentuated character. In such cases, it returns an empty search. This is a critical bug for me because I'm working on a health-related website and health is *santé* in french. I first thougth it has to do with the fact that an accent at the end of the word means its HTML-encoded version actually ends with a ;. However, since it DOES works with certain words ending with the same letter (I just tried *ramené* 30 second ago and it did return results), I really don't have a clue as to what's going on here. It is systematic and not random: santé never returns any result, ramené always does, no matter what the source of the feeds is.
I ran the SQL query outputted by the module against the database and it should return the right results (I tested it). So I really don't know what's going on and why I have no result in the page for such words. Some words ending with é would not work and some others would. I didn't go on testing the whole of the french dictionary against the world of RSS feeds to find a statistically relevant sample, but I did test with several instances of the words in feeds from different sources. I can retrieve the exact same feed item if i filter for the words surrounding "santé", for instance, but when *santé* or *sécurité* (these are examples) are used on their own, the module will not retrieve the feeds.
Any idea why this is happening... and how to solve the problem?
Thanks,
efolia
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | news_page.patch | 2.3 KB | efolia |
Comments
Comment #1
efolia commentedThere's an important bug in your program which prevents many of the results from being returned correctly.
Wildcard characters have to be doubled in LIKE statement (db_query and db_query_range use them as escape characters). I spent hours trying to figure this out.
efolia
Comment #2
efolia commentedHere's a patch that takes care of two bugs in News Page. One that takes care of the keyword filtering, the other that fixes the path to the blogit image. Basically, the version of News Page as it is doesnt filter keywords beginning with the letters s, d, f and b (see http://api.drupal.org/api/4.7/function/db_query).
efolia
Comment #3
robert castelo commentedFixed in 4.7.x-1.0 release.
If this is still a problem for you after updating please set this issue back to active.
Thanks for the patch efolia :-)
Comment #4
robert castelo commented