not all the words index
Moderator: Thorsten
not all the words index
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
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
Re: not all the words index
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)
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)
Re: not all the words index
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
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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: not all the words index
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
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
UPDATE
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
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
Re: not all the words index
Hi Amit,
so this query works? How many entries do you have currently?
bye
Thorsten
so this query works? How many entries do you have currently?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: not all the words index
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
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
Re: not all the words index
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
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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: not all the words index
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
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
Re: not all the words index
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
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
Re: not all the words index
Hi,
can I get the database dump of your FAQ?
bye
Thorsten
can I get the database dump of your FAQ?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: not all the words index
Hi,
enclose my DB.
THANKS IN ADVANCED
BR
Amit
enclose my DB.
THANKS IN ADVANCED
BR
Amit
You do not have the required permissions to view the files attached to this post.
Re: not all the words index
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: not all the words index
Hi,
any news?
BR
Amit
any news?
BR
Amit
Re: not all the words index
Hi,
will work on your topic this week.
bye
Thorsten
will work on your topic this week.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist