Ratings

Suggestions on the Internet Book List.

Moderator: S.Jeffery

User avatar
gpackin
Methuselah's Child
Posts: 2667
Joined: Mon Apr 09, 2007 2:22 pm
Location: Maryland

Ratings

Post 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
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post by tollbaby »

Well, it's a new one on me....
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
User avatar
wolfspirit
MST3K
Posts: 3048
Joined: Sat Nov 08, 2003 12:39 pm

Re: Ratings

Post 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
User avatar
voralfred
Carpal Tunnel Victim
Posts: 5639
Joined: Tue Dec 19, 2006 3:53 am
Location: Paris

Post 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...
Human is as human does....Animals don't weep, Nine

[i]LMB, The Labyrinth [/i]
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post by tollbaby »

I'll reset the ratings table and see if that helps at all.
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
User avatar
clong
Blade Runner
Posts: 9253
Joined: Tue Nov 16, 2004 9:48 am
Location: Rochester, NY
Contact:

Post 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.
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post by tollbaby »

which I just did :) problem solved?
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
User avatar
clong
Blade Runner
Posts: 9253
Joined: Tue Nov 16, 2004 9:48 am
Location: Rochester, NY
Contact:

Post by clong »

Yes and thanks! Problem solved (at least until next time it happens).
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post 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).
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
User avatar
clong
Blade Runner
Posts: 9253
Joined: Tue Nov 16, 2004 9:48 am
Location: Rochester, NY
Contact:

Post by clong »

This seems to have happened again. Please reset the ratings table.
User avatar
wolfspirit
MST3K
Posts: 3048
Joined: Sat Nov 08, 2003 12:39 pm

Post by wolfspirit »

clong wrote:This seems to have happened again. Please reset the ratings table.
Done.

Scott
User avatar
CodeBlower
Shakespearean Groupie
Posts: 1719
Joined: Sun Jun 25, 2006 12:27 am
Location: IL, USA
Contact:

Post 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.
"Budge up, yeh great lump." -- Hagrid, HP:SS
-=-
The gelding is what the gelding is, unlike people who change in response to their perceptions of events that may benefit or threaten their power. -- Lorn, Chapter LXXXII, Magi'i of Cyador
User avatar
clong
Blade Runner
Posts: 9253
Joined: Tue Nov 16, 2004 9:48 am
Location: Rochester, NY
Contact:

Post by clong »

clong wrote:This seems to have happened again. Please reset the ratings table.
again!
User avatar
clong
Blade Runner
Posts: 9253
Joined: Tue Nov 16, 2004 9:48 am
Location: Rochester, NY
Contact:

Post by clong »

Thank you!
User avatar
gpackin
Methuselah's Child
Posts: 2667
Joined: Mon Apr 09, 2007 2:22 pm
Location: Maryland

Post by gpackin »

This has happened again.
S.Jeffery
Drives the short bus
Posts: 1723
Joined: Wed Apr 28, 2004 8:16 pm
Location: Milwaukee, WI

Post by S.Jeffery »

fixed
phpbb
Zybahn
Scribe Adept
Posts: 324
Joined: Fri Jun 29, 2007 5:10 pm
Location: Canada
Contact:

Post by Zybahn »

And again.
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post by tollbaby »

should be fixed.

We have quite a few new users entering ratings. Could that be affecting things Scotty?
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
Zybahn
Scribe Adept
Posts: 324
Joined: Fri Jun 29, 2007 5:10 pm
Location: Canada
Contact:

Post by Zybahn »

Yet again.

(I just hope this mysterious "resetting" is a simple task on your end.)
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post 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.
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
Zybahn
Scribe Adept
Posts: 324
Joined: Fri Jun 29, 2007 5:10 pm
Location: Canada
Contact:

Post by Zybahn »

Once more.
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post by tollbaby »

should be fixed.
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
User avatar
gpackin
Methuselah's Child
Posts: 2667
Joined: Mon Apr 09, 2007 2:22 pm
Location: Maryland

Post by gpackin »

And yet again.
User avatar
tollbaby
anything but this ...
Posts: 6827
Joined: Sun Mar 09, 2003 11:03 am
Location: Ottawa, Ontario
Contact:

Post by tollbaby »

Should be fixed. Again.
And what manner of jackassery must we put up with today? ~ Danae, Non Sequitur
User avatar
gpackin
Methuselah's Child
Posts: 2667
Joined: Mon Apr 09, 2007 2:22 pm
Location: Maryland

Post by gpackin »

Guess what? Yup, again.
Post Reply

Return to “IBList Suggestions”