Reviews Advanced Search not working?
03-24-03 | 03:02 PM
#1
Thread Starter
Senior Member
Joined: Feb 2001
Posts: 254
Likes: 0
Received 0 Likes
on
0 Posts
From: Queens, NY
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'
03-24-03 | 03:53 PM
#2
DVD Talk Reviewer/ Admin
Joined: Sep 1999
Posts: 31,695
Received 2,796 Likes
on
1,859 Posts
From: Greenville, South Cackalack
Fixed.
03-24-03 | 04:24 PM
#4
DVD Talk Reviewer/ Admin
Joined: Sep 1999
Posts: 31,695
Received 2,796 Likes
on
1,859 Posts
From: Greenville, South Cackalack
No problem! Thanks for letting me know.
