Search not working
03-03-14 | 10:34 AM
#1
Thread Starter
DVD Talk Legend
Search not working
Keep getting a database error every time I try to do an advanced search.
03-03-14 | 10:48 AM
#2
DVD Talk Reviewer/ Admin
Joined: Sep 1999
Posts: 31,611
Received 2,772 Likes
on
1,842 Posts
From: Greenville, South Cackalack
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;
03-03-14 | 01:01 PM
#4
DVD Talk Reviewer/ Admin
Joined: Sep 1999
Posts: 31,611
Received 2,772 Likes
on
1,842 Posts
From: Greenville, South Cackalack
Re: Search not working
Could you? I don't have a direct line.
06-12-14 | 09:30 AM
#8
DVD Talk Hero
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!
