Page 1 of 2

Ratings

Posted: Wed Jul 25, 2007 10:20 am
by gpackin
I was just wondering why every book that I look up has a Rating of No votes? This shows up for all books, even for ones that I know have been rated. Once I submit a rating for a book it shows that there have been other votes cast. Then if I come back to the same book sometime later it shows No votes again. Are you aware of this glitch?

Thanks,
Greg

Posted: Wed Jul 25, 2007 10:41 am
by tollbaby
Well, it's a new one on me....

Re: Ratings

Posted: Wed Jul 25, 2007 11:05 am
by wolfspirit
gpackin wrote:I was just wondering why every book that I look up has a Rating of No votes? This shows up for all books, even for ones that I know have been rated. Once I submit a rating for a book it shows that there have been other votes cast. Then if I come back to the same book sometime later it shows No votes again. Are you aware of this glitch?

Thanks,
Greg
I'm not sure what has happened. This is not the first time teh average_ratings table has decided to clear itself for no reason that I can find in the code. I have re-updated all ratings in the table.

Someday, I will actually find the reason for the table deciding to be empty sometimes.

Scott

Posted: Wed Jul 25, 2007 11:08 am
by voralfred
Welll, I experienced a slightly different version: two books (one of which I rated long ago, one I never rated, namely "The Anubis Gates" and "Declare" both by Tim Powers) both appeared with "No Votes" but when I rated both, they reappered with more than one vote (11 and 2 respectively).
So this is analogous to what gpacking had. But for me, the number of votes is still 11 and 2 now. Maybe he waited longer than I did...

Posted: Wed Jul 25, 2007 12:54 pm
by tollbaby
I'll reset the ratings table and see if that helps at all.

Posted: Wed Jul 25, 2007 2:31 pm
by clong
This seems to be a recurring problem since WEM went live (I had posted a bug on it the first time I noticed). The underlying ratings don't disappear, but all books display as if they have no ratings, and continue to do so until either someone comes along and enters (or re-enters) a rating, or one of the admins forces a reset of the ratings table.

Posted: Wed Jul 25, 2007 2:34 pm
by tollbaby
which I just did :) problem solved?

Posted: Wed Jul 25, 2007 2:39 pm
by clong
Yes and thanks! Problem solved (at least until next time it happens).

Posted: Wed Jul 25, 2007 10:58 pm
by tollbaby
well, it's a simple enough process. I can access it from the Masters screen (similar to the Editorial Tools and Admin screens) and it takes about a minute and a half to run the script. Any time the problem crops up, just give a yell (I tend to respond quicker than Steven does during the day).

Posted: Fri Aug 10, 2007 3:40 am
by clong
This seems to have happened again. Please reset the ratings table.

Posted: Fri Aug 10, 2007 6:55 am
by wolfspirit
clong wrote:This seems to have happened again. Please reset the ratings table.
Done.

Scott

Posted: Fri Aug 10, 2007 7:49 am
by CodeBlower
While I realize that I have absolutely no clue what you guys are talking about, if the data reappears when something is updated, that sounds like the data's really still there but that an index to that data has been lost/corrupted.

It just occurred to me that you guys may have already reasoned that out. If so, my apologies for stating the obvious. I enjoy this place quite a bit and feel that I do nothing to contribute - so thought I'd attempt to help, if I could.

Posted: Sat Aug 11, 2007 7:58 am
by clong
clong wrote:This seems to have happened again. Please reset the ratings table.
again!

Posted: Sat Aug 11, 2007 9:11 am
by clong
Thank you!

Posted: Tue Oct 23, 2007 6:40 am
by gpackin
This has happened again.

Posted: Tue Oct 23, 2007 7:34 am
by S.Jeffery
fixed

Posted: Wed Oct 24, 2007 9:22 pm
by Zybahn
And again.

Posted: Thu Oct 25, 2007 8:09 am
by tollbaby
should be fixed.

We have quite a few new users entering ratings. Could that be affecting things Scotty?

Posted: Fri Oct 26, 2007 9:37 am
by Zybahn
Yet again.

(I just hope this mysterious "resetting" is a simple task on your end.)

Posted: Fri Oct 26, 2007 9:43 am
by tollbaby
Fixed. Yes, it's a question of clicking a link. It does put a bit of load on the server, but it's simple and straightforward.

Posted: Thu Nov 08, 2007 11:10 pm
by Zybahn
Once more.

Posted: Thu Nov 08, 2007 11:51 pm
by tollbaby
should be fixed.

Posted: Fri Nov 30, 2007 11:13 am
by gpackin
And yet again.

Posted: Fri Nov 30, 2007 12:44 pm
by tollbaby
Should be fixed. Again.

Posted: Fri Dec 07, 2007 7:52 am
by gpackin
Guess what? Yup, again.