Search not working
#2
DVD Talk Reviewer/ Admin
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 28,824
Received 1,882 Likes
on
1,238 Posts
Re: Search not working
Yeah, it looks like it's trying to join on a big array of empty values or something:
Code:
SELECT t.threadid FROM thread t, forum f WHERE t.forumid = f.forumid AND t.threadid IN (,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,) ORDER BY t.lastpost DESC, t.lastpost DESC;
#4
DVD Talk Reviewer/ Admin
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 28,824
Received 1,882 Likes
on
1,238 Posts
Re: Search not working
Could you? I don't have a direct line.
#8
DVD Talk Hero
Join Date: Feb 2005
Location: In the straps of boots
Posts: 28,005
Received 1,184 Likes
on
836 Posts
Re: Search not working
Not that search isn't "working" but I figured this was a good place to post this question:
If a post contains the word "manager" as an example, how long does it take before that post will show up in the search results page? There was a recent discussion in the last day or two (not including the word "manager" but something else), and when I searched for the word, I only got results that are 6 or more days old.
It's absolutely not a big deal, but I'm just curious when the search database (or whatever) indexes the new posts on the forum.
Thanks!
If a post contains the word "manager" as an example, how long does it take before that post will show up in the search results page? There was a recent discussion in the last day or two (not including the word "manager" but something else), and when I searched for the word, I only got results that are 6 or more days old.
It's absolutely not a big deal, but I'm just curious when the search database (or whatever) indexes the new posts on the forum.
Thanks!