[ php-blog-Bugs-998457 ] Quick Search does not work

Bugs item #998457, was opened at 2004-07-27 04:16
Message generated for change (Comment added) made by garvinhicking
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=998457&group_id=75065

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Frontend functions
Group: v0.6
Status: Closed
Resolution: Duplicate
Priority: 1
Private: No
Submitted By: Jason Levitt (fredb86)
Assigned to: Garvin Hicking (garvinhicking)
Summary: Quick Search does not work

Initial Comment:
I'm running build s9y_200407261337 (July 26)
FreeBSD 4.1
PHP 4.3.8 
Apache 1.3.31 without mod_rewrite

No matter what I enter for the search term, it always
comes back and says:

No Entries Found for Query xxxxxxxx






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

>Comment By: Garvin Hicking (garvinhicking)
Date: 2009-07-02 09:21

Message:
Hi toni!

(you might want to come to the s9y forum to discuss this).

I believe your pgsql version uses fulltext matching using a procedure of
pgsql. I'm not a pgsql pro, but mysql's fulltext ssystem has some caveats
with word stemming. So this would be a problem of the underlying pgsql
search, not with s9y per se. I could give you the SQL query that is
executed and you might want to ask on pgsql specific boards/support
channels for help?

Regards,
Garvin

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

Comment By: Toni Mueller (tonimueller)
Date: 2009-06-25 18:44

Message:
Ok, i have to clarify. Please consider the following "blog entry" in my
PostgreSQL-powered "blog":

headline: need to figure out searching

body:
----------- cut
Sometimes, searching works, and at other times, it doesn't. more
specifically, searching for one word works, and searching for another in
the same post, doesn't return anything.


I'd like to know what makes the search fail.

Let's see if we can make this entry being found, anyway, because other
entries are showing up, but this doesn't.
----------- cut

Searching for "search" finds this entry, but searching for "searching"
doesn't. Searching for "found" or "know" finds this entry as well, but
searching for "another", "because", "same", "sometimes" or "showing"
doesn't. I don't understand why some searches work, and others don't. This
is with PostgreSQL 8.3.7 and PHP 5.2.6 on Debian-Lenny (external FastCGI
setup).

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

Comment By: Garvin Hicking (garvinhicking)
Date: 2009-05-30 10:05

Message:
Serendipity does have support for postgresql Search. The information_schema
table is queried to see if it supported. Please see the
include/functions_entries.inc.php, function serendipity_searchEntries()
function for it. This did work for the original implementation, maybe you
can see why it doesn't work for you? Maybe the information_schema is not
available for you=

Regards,
Garvin

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

Comment By: Toni Mueller (tonimueller)
Date: 2009-05-30 00:38

Message:
searching does not work with postgresql

for postgresql 8.3 and up, searching needs to be done along the lines of
http://www.postgresql.org/docs/8.3/static/textsearch-intro.html#TEXTSEARCH-MATCHING

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

Comment By: Garvin Hicking (garvinhicking)
Date: 2004-08-09 10:16

Message:
Logged In: YES 
user_id=473563

No, that's not correct, the title is search as well:

MATCH (title,body,extended) AGAINST ('yourword')

is the appropriate MySQL code. Well, it also works on my
machine, but on the other one it still doesn't work
sometimes. Still no reproducibility. So I'll close this
report and leave #907221 open. Thanks for helping!

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

Comment By: Jason Levitt (fredb86)
Date: 2004-08-04 21:45

Message:
Logged In: YES 
user_id=407805

Quicksearch is working now (I'm not sure which build fixed it). 
However, it does not search the title of the postings, just the 
body. Is that correct?

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

Comment By: Nobody/Anonymous (nobody)
Date: 2004-07-27 13:27

Message:
Logged In: NO 

I'm running MySQL 4.0.18, by the way.

It appears to be the same bug as #907221 but
there's no diagnosis of #907221, so it's really
kind of hard to say.  :-)

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

Comment By: Garvin Hicking (garvinhicking)
Date: 2004-07-27 08:29

Message:
Logged In: YES 
user_id=473563

Does Bug  #907221 apply to you?

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

Comment By: Jason Levitt (fredb86)
Date: 2004-07-27 04:25

Message:
Logged In: YES 
user_id=407805

BTW, I'm running Windows XP SP1 and IE 6 as the client.

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=542822&aid=998457&group_id=75065

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