| User | Post |
|
12:28 pm 15 Jun 2008
| mkf
Member
| | | |
|
| posts 4 |
|
|
Versions: Simple:Press 3.1.1 build 336, MySQL 5.0.27, Php 5.2.5, Tables are MyISAM (InnoDB not available on server).
Find is not finding anything. Example: Post title : “The dog is back”. Content: “The quick brown fox jumped over the lazy dog”.
Search for “dog” finds nothing.
I hacked the code to print the query, then executed it manually. It is a binary search, and really does find nothing. I replaced the binary search to make it find posts like %dog%, and it then returned results as expected.
Can anybody suggest a solution?
|
|
|
4:01 pm 15 Jun 2008
| Mr Papa
Moderator
| | Arizona, USA | |
|
| posts 1602 |
|
|
not really… I am afraid I dont know much about the search functions… I will try to take a look time permitting… we do have some search updates on our to do list… will try to discuss with Andy…
I might suggest, however, that you upgrade to the latest version as we fixed a security issue in the version you are running…
|
|
|
|
|
Every MySQL server has a setting (Can't remember what it is called off-hand and I am on vacation at the moment with limited internet time) that determines the shortest word that a FULLTEXT index will work with. The default is, I believe, a word length of 4 which means that a search on the word 'dog' will not return any results.
Obviously I do not know what your server is set to but your host will, I assume, tell you this and also tell you whether it can be changed/lowered should you wish.
Finally, the search does not currently include the topic title. This is because the search function while able to operate on more than one column in a table does not operate on columns from two different tables. To do this we will need to run two separate search queries and them marry them together. The downside to this, of course, is performance will be badly affected. This IS, however, on the development plans for a future feature.
|
|
|
6:39 pm 15 Jun 2008
| mkf
Member
| | | |
|
| posts 4 |
|
|
Testing with a longer search word fixed i problem. Thanks
|
|
|
7:18 pm 27 Jul 2008
| Jeff
Guest
| | | |
|
| |
|
|
Hi All,
I got the same problem too, when I try to search 2 character let's say 'my' but no result. Then I try searching 'www.abc.my' there come out many results but only one of them with the full word 'www.abc.my', I knew that can choose the option on search seem so sensitive.
But my actual problem is seraching for Chinese character totally no result.
And something about quote, when people quote a post, the contents ok but poster name be come unrecognizable code, because their name in Chinese. Can I limit the number of words? let's say 20 words maximum then continue will be '….' when people quote a post
Maybe old version no this problem, I'm not sure! I just starting But I like this plugin
|
|
|
|
|
No simple way to limit the wordcount I am afraid. Unless you want to chabnge the javascript.
What encoding are your database and database tables set up to use?
|
|
|
10:20 am 29 Jul 2008
| Jeff
Guest
| | | |
|
| |
|
|
Hi, Here is my table encoding 'utf8-_general_ci' but my SQL version is 4.1.18-tn. Thanks!
|
|
|
|
|
I am going to have to do some research into this so I can't give you any answers immediately I am afraid.
|
|