Possible bug with Relevance Support.

[regispicanco]

Hi,
When Relevance Suport is disabled, I can search a FAQ using only the ID of the FAQ.

When The Relevance Suppoort is enabled, I can not search the FAQ using only the ID of the FAQ.

I tried to put the ID on the Title of the FAQ, like:
Title: (1001) - FAQ example
where 1001 is the ID of the FAQ.

If I search only for "1001" (whitout quotes), nothing is returned, but, if I search for "(1001)" (without quotes) the FAQ is returned.

Our System Information is:
Informação do Sistema

phpMyFAQ Version 2.9.5
phpMyFAQ API Version 1.1
Server Software Apache/2.2.15 (Red Hat)
Server Document Root /sites/base
phpMyFAQ Installation Path /sites/base/homologacao
PHP Version 5.6.21
Webserver Interface APACHE2HANDLER
PHP Extensions Core, date, ereg, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, session, standard, apache2handler, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, intl, ldap, exif, PDO, pgsql, Phar, posix, shmop, SimpleXML, soap, sockets, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlwriter, xsl, zip, pdo_pgsql, pdo_sqlite, wddx, xmlreader, xmlrpc, json, mhash
PHP Session path /var/lib/php/session
Database Server pgsql
Database Server Version n/a
Database Client Version 8.4.20
Elasticsearch n/a

PS - Congratulations, PHPmyFAQ is fantastic!

[thorsten]

It's no bug, it's a feature. It's the search for the solution ID. Every FAQ entry has an unique solution ID, starting with 1001. if you search for numbers, it will try to find the FAQ with this solution ID. You can disable this feature in the admin configuration: Admin -> Configuration -> Search -> Search for solution ID (default: enabled)

[regispicanco]

Hi Thorsten,

I have both options "Search for Solution ID" and "Activate relevance support" enabled.

I did the same test in two different instalations.
In the first one, I used PostgreSQL and I had the behavior I describe in the Issue.
Even if the option "Search for Solution ID" is enabled, I can not find the faq searching by its Solution ID.

In the second installation I used AMMPS and did a fresh install using MySQL.
Now, with MySQL and with both options "Search for Solution ID" and Activate relevance support" enabled, I could search and find faq using just the Solution ID.

I think the different behavior could be related to PostgreSQL.

The strange thing in PosgreSQL installation is when the "Search for Solution ID" is ENABLED and the "Activate relevance support" is DISABLED, I can search the FAQ using only the Solution ID.
But if both are enabled, I can not find the faq using just the solution ID.

[regispicanco]

Hi, Thorsten, do you need any more information?

[thorsten]

Well, I need a proper PostgreSQL environment, still need to build that.

[ernestbuffington]

Mac or Windows?? All problems that would not appear in a remote developer server running on Linux!