search feature

[svautour]

Hi,

Is there a way to change the search feature to only search for keywords only and not throughout the whole page of text?
using version 2.0.12

thanks,
S

[Thorsten]

Hi,

yes... I can provide a patch if you like.

bye
Thorsten

[svautour]

Hi Thorsten,

Can you pls post the patch. It would be greatly appreciated.

thanks,
S

[Thorsten]

Hi,

open inc/functions.php, goto line 1058 and change the lines

Code: Select all

                        array(SQLPREFIX."faqdata.thema",
                              SQLPREFIX."faqdata.content",
                              SQLPREFIX."faqdata.keywords"),

to

Code: Select all

                        array(SQLPREFIX."faqdata.keywords"),

bye
Thorsten

[svautour]

Hi Thorsten,

I tried code and I'm still getting same result. I may have not asked the question correctly. See attached, I would like the search to only search for Keywords that we enter ourselves. On the attached ATC is set as keyword and when I do a search for ATC and would only get the pages with ATC.

thanks again,
S

[Thorsten]

Hi,

how many entries do you have? MySQL fulltext search has some strange issues if you only have a small set of entries.

bye
Thorsten

[svautour]

Hi,

In the DB that I'm testing I have 102.

thanks,
S

[Thorsten]

Hi,

which database version do you use?

bye
Thorsten

[svautour]

Here's my new server config.

thanks,
S

System Information
phpMyFAQ Version phpMyFAQ 2.0.12
Server Software Apache/2.2.3 (Linux/SUSE)
PHP Version PHP 5.2.5
Database Server Mysql
Database Client Version 5.0.26
Database Server Version 5.0.26
Webserver Interface APACHE2HANDLER
PHP Extensions libxml, xml, session, pcre, SimpleXML, SPL, standard, Reflection, filter, date, apache2handler, ctype, dom, iconv, json, mbstring, mcrypt, mysql, PDO, pdo_mysql, pdo_sqlite, SQLite, timezonedb, tokenizer, xmlreader

-----------------------------------------------

I was using this version before and it worked great on that version.

phpMyFAQ Version
phpMyFAQ 1.6.12
Server Software
Apache/2.2.8 (Win32) PHP/5.2.5
PHP Version
PHP 5.2.5
Database Client Version
5.0.45
Database Server Version
5.0.51a-community-nt
Webserver Interface
APACHE2HANDLER

[Thorsten]

Hi,

could you please send me a backup of your database?

bye
Thorsten