Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Big Error: Single rating becomes average rating

Jun 11, 2001, 11:49 AM
nemesis
Novice (29 posts)
Jun 11, 2001, 11:49 AM
Views: 2255
Shortcut
Quote Reply
Big Error: Single rating becomes average rating
After having been working on the upgrade to 2.0.3 on the side, I finally went public with it last night.

Everything seems fine, except for one BIG problem -- whenever someone rates a site, their rating is set as the AVERAGE rating. This, obviously, makes the ratings useless, and is causing me to lose all of the correct ratings for any site that gets a vote.

Example: Site A has 313 votes, and an average rating of 7.50. I rate it with a score of 9. Site A now has 314 votes, with an average rating of 9.00.

Some excerpts from my error log -- in the following bit, the link ID 22 got a rating of 10, and 10 was then set as the average rating.
In Reply To:
GT::SQL::Driver::MYSQL (8627): Preparing query: SELECT * FROM Links WHERE ( ID = '22' ) at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (8627): Preparing query: SELECT Title, URL FROM Links WHERE ID = 22 at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (8627): Preparing query: SELECT COUNT(*) FROM ClickTrack WHERE ClickType = 'Rate' AND IP = '213.123.132.239' AND LinkID = '22' at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (8627): Preparing query: SELECT Votes,ID,Rating FROM Links WHERE ID = '22' at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (8627): Preparing query: UPDATE Links SET Votes = '415' , Rating = '10' WHERE ID = '22' at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (8627): Preparing query: SELECT COUNT(*) FROM ClickTrack WHERE ClickType = 'Rate' AND IP = '213.123.132.239' AND LinkID = '22' at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (8627): Preparing query: INSERT INTO ClickTrack (Created,ClickType,IP,LinkID) VALUES (NOW(),'Rate','213.123.132.239','22') at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.
Also, I'm using the SearchLogger plug-in, and just noticed this in my error logs:
In Reply To:
GT::SQL::Driver::MYSQL (11976): Preparing query: SELECT * FROM SearchLog WHERE ( Term = 'bronze' ) at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (11976): Preparing query: SELECT Term,Results,HitCount FROM SearchLog WHERE Term = 'bronze' at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.

GT::SQL::Driver::MYSQL (11976): Preparing query: UPDATE SearchLog SET Results = '6' , HitCount = '3' WHERE Term = 'bronze' at /home/httpd/cgi-bin/linkssql/admin/GT/SQL/Driver/MYSQL.pm line 35.
I don't know what the problem is, but the term "bronze" isn't in my search log.

Any help -- especially on the ratings problem -- would be greatly appreciated!

Jamie Marie


---------------------
BuffyGuide.com
Subject Author Views Date
Thread Big Error: Single rating becomes average rating nemesis 2255 Jun 11, 2001, 11:49 AM
Thread Re: Big Error: Single rating becomes average rating 		pugdog 2219 Jun 11, 2001, 12:21 PM
Thread Re: Big Error: Single rating becomes average rating 		nemesis 2213 Jun 11, 2001, 12:51 PM
Post Re: Big Error: Single rating becomes average rating 		pugdog 2211 Jun 11, 2001, 1:01 PM
Post Re: Big Error: Single rating becomes average rating 		nemesis 2210 Jun 11, 2001, 1:19 PM