Forum Feedback and Support Post forum feedback and related problems, here.

Search not working

Old 03-03-14, 11:34 AM
  #1  
DVD Talk Legend
Thread Starter
 
Maxflier's Avatar
 
Join Date: Jan 2003
Location: Louisiana
Posts: 11,598
Search not working

Keep getting a database error every time I try to do an advanced search.
Maxflier is online now  
Old 03-03-14, 11:48 AM
  #2  
DVD Talk Reviewer/ Admin
 
Adam Tyner's Avatar
 
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 20,685
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;
Adam Tyner is offline  
Old 03-03-14, 01:15 PM
  #3  
Admin-Thanos
 
VinVega's Avatar
 
Join Date: Nov 2000
Location: Caught between the moon and NYC
Posts: 30,840
Re: Search not working

Adam, have you contacted IB about this, or do you need me to?
VinVega is online now  
Old 03-03-14, 02:01 PM
  #4  
DVD Talk Reviewer/ Admin
 
Adam Tyner's Avatar
 
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 20,685
Re: Search not working

Could you? I don't have a direct line.
Adam Tyner is offline  
Old 03-03-14, 07:28 PM
  #5  
Administrator
 
IBobi's Avatar
 
Join Date: Mar 2011
Posts: 541
Re: Search not working

Reporting!
IBobi is offline  
Old 03-03-14, 07:45 PM
  #6  
Administrator
 
IBobi's Avatar
 
Join Date: Mar 2011
Posts: 541
Re: Search not working

Please try now -- tech reporting as fixed
IBobi is offline  
Old 03-03-14, 09:25 PM
  #7  
Challenge Guru & Comic Nerd
 
Trevor's Avatar
 
Join Date: Apr 1999
Location: spiritually, Minnesota
Posts: 33,888
Re: Search not working

Working for me now, thanks!
Trevor is offline  
Old 06-12-14, 10:30 AM
  #8  
Dan
DVD Talk Legend
 
Dan's Avatar
 
Join Date: Feb 2005
Location: \_(ツ)_/
Posts: 18,293
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!
Dan is offline  
Old 06-16-14, 08:15 PM
  #9  
Administrator
 
IBobi's Avatar
 
Join Date: Mar 2011
Posts: 541
Re: Search not working

Should be hours at most.
IBobi is offline  

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive Advertising Cookie Policy Privacy Statement Terms of Service

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.