On these pages are my WordPress plugins, the odd article and my Support Forum.

For my random rantings on everything else please visit my blog at Yellow Swordfish

WP Plugins


Articles

If you find any of my plugins useful, please comsider a donation towards my running costs.

Thank you

In preparation for the release of Simple:Press Version 4.0, the Support Forum has moved to a new site dedicated to the plugin. This will also be the future home for Simple:Press Forum.


Version 3.1.4 will still be available for download here in the short term.


For the support forum - and to visit our new site and to get details of version 4.0, click on the logo to take you to simplepressforum.com

This forum is currently locked - access is read only
Current User: Guest
Please consider registering

 
Search Forums:


 




Keyword search not finding anything

UserPost

12:28 pm
15 Jun 2008


mkf

Member

posts 4

1

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

2

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…

4:59 pm
15 Jun 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252

3

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

4

Testing with a longer search word fixed i problem. Thanks

7:18 pm
27 Jul 2008


Jeff

Guest

5

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

11:27 pm
27 Jul 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252

6

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

7

Hi, Here is my table encoding 'utf8-_general_ci' but my SQL version is 4.1.18-tn. Thanks!

9:41 pm
29 Jul 2008


Yellow Swordfish

Admin

Peterborough, England

posts 5252

8

I am going to have to do some research into this so I can't give you any answers immediately I am afraid.



Reply to Topic: Keyword search not finding anything

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 9 + 8        (Required)

Topic Reply:


 
 

About the Stuff at Yellow Swordfish forum

Currently Online:

7 Guests

Maximum Online: 71

Forums:

Groups: 3

Forums: 16

Topics: 2068

Posts: 14091

Members:

There are 1003 members

There are 837 guests


Yellow Swordfish has made 5252 posts

Top Posters:

Mr Papa - 1602

-Radio- - 558

ovizii - 114

jfv - 82

angelic007 - 72

Administrator: Yellow Swordfish | Moderators: Yellow Swordfish, Mr Papa, -Radio-


© Simple:Press Forum - Version 3.1.4 (Build 357)