Hi,
phpMyFAQ seems to be having problems with search phrases (in between quotation marks). For example I want to search for the exact phrase "another computer problem". I don't expect hits for FAQ's containing just one or more of these words. I expect only hits with the exact phrase. At least that's how it should work according to https://dev.mysql.com/doc/refman/5.5/en ... olean.html.
I just used this demo page: http://jen.demo.phpmyfaq.de/ (2.9.6 with PHP 5)
After adding 2 similar FAQ's I did a search. Instead of only 1 hit there were 2 hits.
FAQ1 had this text:
Another apple banana juice in this simple test. Just quit smoking today.
FAQ2 had this text:
Another banana apple juice in this simple test. Just gave up smoking today.
My search term (including the double quotes): "banana apple"
Search result:
1. FAQ 1
2. FAQ 2 (which should have been the only result - because only this FAQ does contain the search phrase)
Is this a bug in MySQL or phpMyFAQ or am I missing something?
Danny
Search phrase (with quotation marks) not working
Moderator: Thorsten
Search phrase (with quotation marks) not working
You do not have the required permissions to view the files attached to this post.
Re: Search phrase (with quotation marks) not working
Hi,
how many FAQs do you have in your installation?
bye
Thorsten
how many FAQs do you have in your installation?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Search phrase (with quotation marks) not working
Hi Thorsten,
in my installation there are about 900 FAQ's. On the demo server there were 4 or 5 while I tested yesterday.
Danny
in my installation there are about 900 FAQ's. On the demo server there were 4 or 5 while I tested yesterday.
Danny
Re: Search phrase (with quotation marks) not working
Hi,
okay, 900 FAQs are enough. Is it possible to get a copy of them to analyze what's happening?
bye
Thorsten
okay, 900 FAQs are enough. Is it possible to get a copy of them to analyze what's happening?
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Search phrase (with quotation marks) not working
Hi Thorsten,
I can't give away the original Database. But I set up another FAQ on the same server which is showing the same problem. I did a clean install (new database, new phpMyFAQ 2.9.6 installation) and added 40 FAQs.
When I search for a phrase the result is similar to a search without quotation marks. For example the search phrase "beschränkungen dürfen" finds me 7 hits in phpMyFAQ. When I search for the same phrase via MySQL it finds me 2 hits (which is correct): I attached a backup of the FAQs here:
I can't give away the original Database. But I set up another FAQ on the same server which is showing the same problem. I did a clean install (new database, new phpMyFAQ 2.9.6 installation) and added 40 FAQs.
When I search for a phrase the result is similar to a search without quotation marks. For example the search phrase "beschränkungen dürfen" finds me 7 hits in phpMyFAQ. When I search for the same phrase via MySQL it finds me 2 hits (which is correct): I attached a backup of the FAQs here:
You do not have the required permissions to view the files attached to this post.
Re: Search phrase (with quotation marks) not working
Hi,
do you have the SQL backup for me as it's hard to import the JSON
bye
Thorsten
do you have the SQL backup for me as it's hard to import the JSON
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Search phrase (with quotation marks) not working
Oh, sorry. That was the wrong menu I used...
Here's the correct export:
Here's the correct export:
You do not have the required permissions to view the files attached to this post.
Re: Search phrase (with quotation marks) not working
Hi,
first finding: the search query returns on the MySQL command line two results, in PHP seven results. This is strange. I'll have to investigate this.
bye
Thorsten
first finding: the search query returns on the MySQL command line two results, in PHP seven results. This is strange. I'll have to investigate this.
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
Re: Search phrase (with quotation marks) not working
Hi Thorsten,
could you find the problem in the meantime?
could you find the problem in the meantime?
Re: Search phrase (with quotation marks) not working
Hi,
not yet!
bye
Thorsten
not yet!
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist