Solspace Support Forums

Disable multiple ratings from same user?

2008-07-23T07:54:05-08:00

Hi!

I’ve been playing around with the allow_duplicate parameter in the ratings form. I am only using it for ratings (not reviews), and only from logged in users. It seems to allow users to re-submit the form as long as they submit a new rating each time. Is there any way to avoid this, perhaps a conditional that only shows the rating form if they have not yet rated the weblog entry?

Error with pulling Avatar

2008-07-18T15:26:58-08:00

Hello,

The ratings module works great. However, for some reason it very rarely gives me this 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 '}' at line 1

Query: SELECT avatar_filename, avatar_width, avatar_height FROM exp_members WHERE member_id ={member_id}

The code above is my way of grabbing the avatar of the member that is posting the rating.

I did some troubleshooting and found the “rating entry” that was triggering this error. I noticed that this particular rating didn’t have a screenname associated with it. I am not sure why this happens sometimes, but it seems like every once in a while the rating module doesnt grab the users screenname. Then an error happens when the query above runs.

Deleting the erroneous comment fixes the error, however I would like to prevent this permanently. Any ideas?

Thanks!

MySQL Error 1604

2008-07-12T13:48:22-08:00

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!

jQuery function to handle Rating Submittal

2008-06-02T15:32:11-08:00

I’ve been able to get the Ratings module/extension installed and working, but showing the drop down options and a submit button isn’t very appealing.

I’d really like to use the CSS Star Rating Redux for the star ratings on a site, but that is only part of the puzzle. Does anyone have the javascript (using jQuery) that can handle the rating form submittal?

Or if there is another method that works better I’d love to hear it.

If someone could provide some help/insight I would greatly appreciate it!

Cheers!

Mark first review as ‘first’

2008-07-09T09:59:35-08:00

So, you know, instead of people writing ‘First!’ in their review of an entry, I can just automatically show a flag to that effect. I get the feeling it’ll required some math tomfoolery though…

Rating and Freeform?

2008-06-19T07:14:38-08:00

Hello.

Is it possible to use the Rating module with Freeform entries? Or is it only for weblog entries?

Thanks in advance

custom field search allowed in rankings

2008-06-18T14:11:37-08:00

I need to have several custom field searches included in my rankings list. I’m currently seeing no results though, is this not yet supported? It becomes a real showstopper for me…

{exp:rating:rankings weblog="{segment_2}" form_name="review" search:f1="{embed:f1}" search:f2="{embed:f2}" limit="10" category="{embed:thecatid}" status="open" orderby="title" sort="desc" paginate="bottom"}

EDIT: never mind, i think my own stupidity struck again!

Simple listing of all ratings showing stars and with paginiation

2008-04-28T10:53:25-08:00

This code works ...

{exp:rating:rankings}

<div>{exp:rating:stats entry_id="{entry_id}" theme="default" precision="1" thousands="," fractions="."}{avg_rating}{/exp:rating:stats} {title}</div>

{/exp:rating:rankings}

... but isn’t quite what I am looking for.

Using this code, I have tried (by manipulating existing tags et al, unsuccessfully) to:

1. Have a simple listing (by average rating, starting with the highest rated first, then sorted by date)
2. Have the list stop at 5 and then paginate for the rest
3. Include the following tags ... {rating_name} / {rating_date format="%d/%m/%y"} / {rating_date format=’%h:%i%a’} ... on this page
4. Have, instead of the rating number (e.g. 5.0), show the number of stars by way of an image (just like the single entry page) - {stars}{rating}{/stars} ???

My questions are:

1. Pagination will work in the way I want it to?
2. Will the tags shown in 3. above work the way I would like to?
3. Can stars instead of a number be shown?

Thanks.

KCesp

Some entries not displaying review/rating

2008-06-09T12:48:27-08:00

It’s me again, back with another weird issue with my golf site… only this time it’s with the rating module instead of the favorites.

Here are the entries that I’ve found that are not displaying ratings:

1. http://www.kentuckygolfing.com/courses/details/persimmon-ridge-golf-club/
2. http://www.kentuckygolfing.com/courses/details/olde-stone/

Yeah, it’s Olde-Stone again!

The weird thing is that the ratings are actually being recorded. I can go to Modules >> Rating and then view all the ratings and they are all there, just not showing on the live site.

Thanks

Ratings not deleted when entry deleted?

2008-06-06T12:43:09-08:00

Shouldn’t ratings get deleted when the corresponding entry is deleted? I’m finding that when an entry is deleted, the ratings are orphaned.

For now I might add code to my own ‘delete_entries_loop’ hook handler to take care of it, but obviously it should really be handled by Rating itself.