Go Back  DVD Talk Forum > Feedback > Forum Feedback and Support
Reload this Page >

Reviews Advanced Search not working?

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

Reviews Advanced Search not working?

Old 03-24-03, 03:02 PM
  #1  
Senior Member
Thread Starter
 
Join Date: Feb 2001
Location: Queens, NY
Posts: 254
Likes: 0
Received 0 Likes on 0 Posts
Reviews Advanced Search not working?

I tried using the advanced search feature to sort through the hundreds of great disc reviews here, but recently I've been getting the same error every time. I don't think it's my browser since I've tried the search on both my computer at work and at home. Can someone check this out? Here is what the error produces:

The following error was encountered:
SELECT COUNT(DISTINCT(ReviewText.ID)) AS Counted FROM ReviewText, ReviewUsers, ReviewAdvice LEFT JOIN ReviewStudios ON ReviewStudios.ID=ReviewText.StudioID LEFT JOIN ReviewTextGenres ON ReviewTextGenres.ReviewID=ReviewText.ID WHERE ReviewUsers.ID=ReviewText.UserID AND ReviewText.RecordState='Approved' AND ReviewText.Advice=ReviewAdvice.ID AND ReviewText.UserID='14' AND ReviewText.Advice BETWEEN '1' AND '3' AND ReviewText.ReviewType='DVD Video' AND ReviewText.VideoRating BETWEEN '4.5' AND '5' AND ReviewText.SoundRating BETWEEN '4.5' AND '5'

1054: Unknown column 'ReviewText.VideoRating' in 'where clause'
Old 03-24-03, 03:53 PM
  #2  
DVD Talk Reviewer/ Admin
 
Adam Tyner's Avatar
 
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 28,741
Received 1,856 Likes on 1,227 Posts
Fixed.
Old 03-24-03, 04:01 PM
  #3  
Senior Member
Thread Starter
 
Join Date: Feb 2001
Location: Queens, NY
Posts: 254
Likes: 0
Received 0 Likes on 0 Posts
Kick ass. Thanks.
Old 03-24-03, 04:24 PM
  #4  
DVD Talk Reviewer/ Admin
 
Adam Tyner's Avatar
 
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 28,741
Received 1,856 Likes on 1,227 Posts
No problem! Thanks for letting me know.

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 © 2024 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.