Reviews Advanced Search not working?
#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'
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'
#2
DVD Talk Reviewer/ Admin
Join Date: Sep 1999
Location: Greenville, South Cackalack
Posts: 28,741
Received 1,856 Likes
on
1,227 Posts
Fixed.
#4
DVD Talk Reviewer/ Admin
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.