Hi:

I have a routine for my links install that pulls info on the latest posts from Forum and slaps them on the main page. Simple thing- basically an hourly CRON job that runs a search in Forum with specific paramiters. To format, I use the "t=XXXX" to use a custom template that formats the 5 newest posts into a box format... and crom writes the output to a txt file... then the home page just includes it! Easy!

Well, when I installed 3.0, all of a sudden the forum search went south- returned NO results, even with a hand search. I had some other priorities, so I just removed the box while I tried to figure it out.

Well, today I installed my second Links 3.0.1 install, and now another feed has gone to Yeck! This one pulled the most recent posts to a specific forum (News) and return those. It is interesting to note this search DID work for the first Links install.... but cratered after the second.

Here is the server config:

1) Apache 1.3.3 front for Links 1, Links 2, Forum 1 (and forum 2, Comm 1 and Comm 2, but I am not sure those is involved)
2) Apache 1.3.3/Mod_perl back for Links 1, Forum 1, Comm 1
3) Apache 2/Mod_Perl 1.99 back for Links 2, Forum 2, Comm 2

My startup.pl has all loaded properly (newest to oldest).

Any ideas?

Oh, here is a link to the current output of one of the searches, if you care to look- it is just the forum page that says no search results found:

http://www.bcdb.com/.../page.cgi?p=news_box

The query riun for this is:

Code:

http://forum.bcdb.com/...e=&mh=5&t=se

This is not killing me- I just removed the boxes... but I would like this all back up as soon as I can, so any ideas would be appreciated!
dave

Big Cartoon DataBase
Big Comic Book DataBase

Have you looked at the query that it's running and tried the query yourself?

Adrian

A-

Yes... the above link in the code box is exactly that... here it is btoken down:

http://forum.bcdb.com/gforum.cgi?
do=search_results
&search_time=10d (go back 10 days- probably too long, but safe!)
&search_forum=forum_18 (18 is the "news" forum- just search that forum)
&search_string= (no search term)
&search_type=AND
&search_fields=sb
&search_user_username= (No user name- probably droppable)
&mh=5 (return 5)
&t=se (Template set to use)
dave

Big Cartoon DataBase
Big Comic Book DataBase

No, I meant the actual SQL query it's running. Try comparing the old and new.

Adrian

Not sure how to get that Adrian- I have just always used the forum search to return results.

Was thinking to use SQL to replace/fix this, to get my boxes back, but have not gotten to coding that.

I did run:

SELECT *
FROM `forum_Post`
WHERE `forum_id_fk` = '18'

which is a simple version of the search, and that returned results...
dave

Big Cartoon DataBase
Big Comic Book DataBase

More tests- looks like the search does return results if I take out &search_time=10d part of the query...

Also, if &search_user_username=admin is added, it seems to work...
dave

Big Cartoon DataBase
Big Comic Book DataBase

I tested THIS forum, and it is not working well here, eather.

Try this on this forum:

Search String: the

Search All Forums
Type: All
Feilds: Subject & Body
Show Posts From: 24 Hours

Search will return no results... and I think we all know there are many posts in 24 hours with "The" in them....
dave

Big Cartoon DataBase
Big Comic Book DataBase

Well, I futzed with it some more, added "&search_user_username=admin" (which I would think would screw it up, but it does not) and took out the searchg time, and that seems to have made it work.

But I still feel something is not right in there- you might want to look further into it...
dave

Big Cartoon DataBase
Big Comic Book DataBase

I think 'the' is a bad search term (it might ignore it). My search was fine:

http://www.gossamer-threads.com/...ewt&sb=post_time

Adrian

Oh- yeah... sorry- I was just trying to find a common word!
dave

Big Cartoon DataBase
Big Comic Book DataBase