[ 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-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

------------------------------------------------------------------------------
Register Now for Creativity and Technology (CaT), June 3rd, NYC. CaT 
is a gathering of tech-side developers & brand creativity professionals. Meet
the minds behind Google Creative Lab, Visual Complexity, Processing, & 
iPhoneDevCamp as they present alongside digital heavyweights like Barbarian 
Group, R/GA, & Big Spaceship. http://p.sf.net/sfu/creativitycat-com