Search in Japanese is finally working.

[richpav]

In inc/function.php I replaced this:

$query = "SELECT id, lang, rubrik, thema, content FROM ".$sqltblpre."faqdata WHERE MATCH (thema,content,keywords) AGAINST ('".$begriff."') AND active = 'yes'";

with this:

$query = "SELECT id, lang, rubrik, content FROM ".$sqltblpre."faqdata WHERE thema LIKE '%".$begriff."%' OR content LIKE '%".$begriff."%' OR keywords LIKE '%".$begriff."%' AND active = 'yes'";

Thanks to phpMyAdmin and three hours of trial and error.

[Thorsten]

Hi,

your query is very slow, if the FAQ is really big.

bye
Thorsten

[vnpenguin]

Hi Thorsten,
I'm adding vietnamese support ( UTF-8 ) for phpMyFAQ 1.3.8. OK for all until now but the search engine does not work at all. I have always "no results" for any searching keywords.

I'm working with Apache 2.0.47 / PHP 4.3.3 / MySQL 3.23.58 under Fedora Core 1 Linux. The default charset for phpMyFAQ is UTF-8.

Have you any ideas for this problem ?

Thank you in advance,

Regards,
VP

[Thorsten]

Hi,

how many entries do you have in your FAQ? The MySQL fulltext search works only with 5 plus entries...

bye
Thorsten

[vnpenguin]

Hi,
Thank you for your so much reply My database has only 2 entries
OK, i'll check it with more record and report to you later.

I'll send to you vietnamese translation lang file for phpMyFAQ 1.3.8.

Thank you again for your support.

Regards,
VP