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'

Fixed.

Kick ass. Thanks.

No problem! Thanks for letting me know.