Hello! I just installed Rating 2.1.2 yesterday, as it’s something I’d really like to get going on my site.
The goal of the installation is just to get average ratings, no reviews.
I installed it as per the readme instructions and am getting an error on the page that has the rating code included. This is the error:
MySQL ERROR:
Error Number: 1064
Description: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘exp_weblog_titles.weblog_id = ‘4’’ at line 1
Query: SELECT exp_weblog_titles.entry_id, exp_weblogs.rating_system_enabled, exp_weblogs.rating_use_captcha, exp_weblogs.rating_require_membership FROM exp_weblog_titles, exp_weblogs WHERE exp_weblog_titles.url_title = ‘text’ AND exp_weblog_titles.weblog_id = exp_weblogs.weblog_idAND exp_weblog_titles.weblog_id = ‘4’
And this is the code (to keep things tidy, I’ve put the code in a webpage template, and have embedded that template on the article page of the blog):
{exp:rating:form form_name="ratethis" weblog="tom" required="rating" anonymous="no" require_membership = "yes"}
<input type="hidden" name="name" value="{screen_name}" />
<input type="hidden" name="email" value="{email}" />
<label for="review">Your Rating</label>
<select name="rating">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
<input type="submit" name="submit" value="Rate this!" />
{/exp:rating:form}
Is this a problem with the code, or with the installation, or what? Any help much appreciated. THANKS!
