Problem search module

Regular Joined: Sep 12, 2003 Posts: 63

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

Posted: Tue Feb 08, 2005 4:48 am

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

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

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

Posted: Wed Feb 09, 2005 7:56 am

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