Problem search module

fondy · Regular Joined: Sep 12, 2003 Posts: 55

Hello.

I have trouble with the search module. I am using version 6.5 and patched with chatserves 2.8 version. When I search for something only a few articles comes up, not all of them. I have checked the search modules index.php and found this:

$q = "select s.sid, s.aid, s.informant, s.title, s.time, s.hometext, s.bodytext, a.url, s.comments, s.topic from ".$prefix."_stories s, ".$prefix."_authors a where s.aid=a.aid $queryalang $categ";
if (isset($query)) $q .= "AND (s.title LIKE '%$query%' OR s.hometext LIKE '%$query%' OR s.bodytext LIKE '%$query%' OR s.notes LIKE '%$query%') ";

In older versions of php nuke an author could have an id like John Hansen. Now you can not have spaces between these and you have to rename the id to JohnHansen.

In the search module there are: .... where stories.aid=authors.aid ....

Do I have to delete the spaces between names in the authors table to correct the problem?

regards fondy

fondy · Regular Joined: Sep 12, 2003 Posts: 55

Have changed line 186:

$q = "select s.sid, s.aid, s.informant, s.title, s.time, s.hometext, s.bodytext, a.url, s.comments, s.topic from ".$prefix."_stories s, ".$prefix."_authors a where s.aid=a.aid $queryalang $categ";

to this:

$q = "select s.sid, s.aid, s.informant, s.title, s.time, s.hometext, s.bodytext, a.url, s.comments, s.topic from ".$prefix."_stories s, ".$prefix."_authors a where";

and all is ok now.

regards fondy

Raven · Posted: Tue Feb 08, 2005 6:34 am

I'm glad. I looked at this briefly and was not able to see anything immediately Smile

fondy · Regular Joined: Sep 12, 2003 Posts: 55

Hi Raven !

To correct the problem, I have to delete the spaces between the name in the aid field. 'John Hansen' have to be 'JohnHansen'

In phpmyadmin I use these sql statement:

UPDATE nuke_stories SET aid = 'JohnHansen' WHERE aid = 'John Hansen';

fondy