DVD Talk Forum - Search not working

DVD Talk Forum (https://forum.dvdtalk.com/)

- Forum Feedback and Support (https://forum.dvdtalk.com/forum-feedback-support-4/)

- - Search not working (https://forum.dvdtalk.com/forum-feedback-support/618476-search-not-working.html)

Maxflier

03-03-14 10:34 AM

Search not working

Keep getting a database error every time I try to do an advanced search.

Adam Tyner

03-03-14 10:48 AM

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;

VinVega

03-03-14 12:15 PM

Re: Search not working

Adam, have you contacted IB about this, or do you need me to?

Adam Tyner

03-03-14 01:01 PM

Re: Search not working

Could you? I don't have a direct line.

ibobi

03-03-14 06:28 PM

Re: Search not working

Reporting!

ibobi

03-03-14 06:45 PM

Re: Search not working

Please try now -- tech reporting as fixed

Trevor

03-03-14 08:25 PM

Re: Search not working

Working for me now, thanks!

Dan	06-12-14 09:30 AM

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!

ibobi

06-16-14 07:15 PM

Re: Search not working

Should be hours at most.

All times are GMT -5. The time now is 03:58 AM.