not all the words index

[amitm]

Hi,
i am using PHPFAQ when i am doing a search , i am getting results , but not to all the words.
it seems that its not indexing all the words.
can you advice me what to do, maybe its beacause i am not using latin letters?

BR
Amit

[amitm]

BTW,
the pdf function isnt working well, there is encoding problem

http://www.meyraz.co.il/faq/index.php?action=show

my DB: MySQL client version: 5.5.36
MySQL charset: UTF-8 Unicode (utf8)

i read that it should support, so maybe that is the key to my main search problem.
Main features of the PDF export:

supports all ISO page formats;
supports custom page formats, margins and units of measure;
supports UTF-8 Unicode and Right-To-Left languages;
supports TrueTypeUnicode, OpenTypeUnicode, TrueType, OpenType, Type1 and CID-0 fonts;
includes methods to publish some HTML code;
includes graphic (geometric) and transformation methods;
includes methods to set Bookmarks and print a Table of Content;
supports automatic page break;
supports automatic page numbering and page groups;
supports automatic line break and text justification;
supports JPEG and PNG images natively, all images supported by GD (GD, GD2, GD2PART, GIF, JPEG, PNG, BMP, XBM, XPM)

[Thorsten]

Hi,

I'm not a native Hebrew speaker, so I cannot say if Hebrew causes issues with the used MySQL full text search. I'll try to investigate that. For the PDF export, I'm working on it!

bye
Thorsten

[amitm]

Hi,
when i am using joomla (mysql DB) and i am using full text search its working great.
i must say that its a little odd.

Maybe i have to change the DB chartset to UTF8_unicode_ci ?
BR
Amit

[amitm]

hi,
i investigate it.
if i try to run the queries against the db directly i get results but in the system i am not getting the results.
example for a query:
SELECT * FROM `faqdata` d, faqcategoryrelations cr, faqcategories c WHERE MATCH (d.thema,d.content,d.keywords) AGAINST ('יהודי' IN BOOLEAN MODE) AND d.active='yes' and cr.category_id=4 and cr.record_id=d.id and cr.category_id=c.id

BR
Amit

[Thorsten]

Hi Amit,

so this query works? How many entries do you have currently?

bye
Thorsten

[amitm]

Hi,

no, it is not working.
unfortunately, i cant use phpmyfaq beacause its not support HEBREW.
it seems a very good product and i hope that you will fix it.

when i use the query from phpmyadmin its working fine, but when i am using it via the search interface i am getting an answer that there is no results.
you can try it,

add a sentense in hebrew and that search a word from it, you will see that you are not getting results for some of the words
example of sentense:
title: איטליה
המכסה את רוב שטחו של חצי האי האפניני, וכן מספר אזורים נוספים. כמו כן היא כוללת שני איים גדולים
choose a word
איטליה
or try
אזורים
the software cant find those words, but, if you will try the word
כוללת
the softare will find it.
i dont know why its happening, it is a BUG.
i will be happy if you can solve it,
thanks in advanced.

AMIT

[Thorsten]

Hi,

I checked your FAQ. You only have 2 records. As we're using MySQL fulltext search, I know what's happening: MySQL full text search only works with more than appr. 5 records, otherwise it returns nothing. phpMyFAQ tries to be smart and if the full text query doesn't return anything, it tries a LIKE query which isn't the best solution, especially in Hebrew.

Can you try to add some more FAQs and check it again? Thanks!

bye
Thorsten

[amitm]

ok,
i will do so.
the FAQ that you saw its a new install that i tried, at the previous i add more than 5 records, but now i will try to put more and i will update you.

THANKS
amit

[amitm]

Hi,

i did your request, NOTHING - its not working

try:
http://www.meyraz.co.il/faq/

choose the words:
יהודה
חגים
דגל
מדינת
איטליה
אזורים
copy And paste to the search area (instant or regular) nothng happen
that word שנקבע its working fine.
i tried to install the myfaq and change the DB to utf8 unicode unstaed of utf8 general ci, the same problem
BR
Amit

[Thorsten]

Hi,

can I get the database dump of your FAQ?

bye
Thorsten

[amitm]

Hi,
enclose my DB.

THANKS IN ADVANCED
BR
Amit

[Thorsten]

Hi,

thanks, I'll work on it: https://github.com/thorsten/phpMyFAQ/issues/807

bye
Thorsten

[amitm]

Hi,
any news?

BR
Amit

[Thorsten]

Hi,

will work on your topic this week.

bye
Thorsten