Star Rating not working

[lordkinjo]

On my site http://www.eonlinestores.com no one can get more than one vote showing... I have used IE and Netscape and I still can't get more than One Vote... When I do vote it says I am sucessful but it does not show up... It will only show up on the first vote...

Any Ideas?

Lordkinjo

[scheetz]

is it showing up in your database? you can check using phpadmin.

[dody]

When I do vote it says I am sucessful but it does not show up... It will only show up on the first vote...

when someone place a vote, indexu will store its ip to prevent duplicate/cheating. So can't place a vote for the same link twice.

[scheetz]

i dont think thats the problem here. the problem is that no links are showing more than one vote.

[esm]

Originally posted by dody
when someone place a vote, indexu will store its ip to prevent duplicate/cheating. So can't place a vote for the same link twice.

hmmm....I thought that there lots of dynamic IPs still out there and that a different person could end of the same IP. They would not be able to vote. Don't all those AOL users get to re-use someone elses IP?

[scheetz]

well if you go to the site you you are able to vote on a link with no rating, and if you try to vote again it wont let you. everything is fine with the ips. the problem is when a link already has one vote and you have not yet voted on it, you can vote, and it says sucessful but the rating is not stored. try it out.

[dody]

It's weird
I visited random detail page, all of them have 5 star rating? Do you rate them all?

I also check you detail page html code for rating. It's fine.
Are you make modification on indexu code? in /lib/link.class.php?

The best way to trace the error is from sql query. Since most sql query is dynamic it's qood idea to see what currently sql sent to mysql server.

In /lib/link.class.php line 2458, edit

    print $query = "select ip from $this->votes_table_name where link_id = $id and ip = '$ip'";

then line 2465

    print   $query = "insert into $this->votes_table_name values ($id,'$ip',$value)";

Let me know the result.

[lordkinjo]

Ok ...I never did that before.... I uploaded a clean link.class file from the latest patch and add print to the lines you requested... I tried to rate some one good that had 5 stars and it says it is successful but it still remain 1 vote... Here is the print results...from 2 different attempts...

select ip from idx_votes where link_id = 24 and ip = '4.61.134.54'insert into idx_votes values (24,'4.61.134.54',3)

select ip from idx_votes where link_id = 41 and ip = '4.61.134.54'insert into idx_votes values (41,'4.61.134.54',3)


Lordkinjo

[lordkinjo]

Originally posted by scheetz
is it showing up in your database? you can check using phpadmin.

The vote ratings are showing up most just say 5
Is there suppose to be a column for how many votes...

link_id - ip - value These are the columns I have for votes...you would think one would say how many? i don't build databases so i really don't know...

Lordkinjo

[dody]

It's okay with query. I need to check up your db structure. Please pm me your phpmyadmin or you can send me a backup file from admin cp.

please attach file in private message.
and you can change back again your /lib/link.class.php code to its original. I'm pretty sure something wrong with your database.

[lordkinjo]

Any Luck Dody?

Lordkinjo

[lordkinjo]

Dody,
I have did a clean test install on another domain and inserted the sample database so everything is right out of the box... The star ratings does not go above 1 vote on the clean install also...
I don't know what else it could be.... I even went to the Indexu.com demo... and sure enough no ratings higher than 1 vote. So I don't think it is my database....
Does anyone have this Working on thier site? If so, Did you install the latest patch on your site?

I know this isn't a big thing to some people but it is the only dam thing not working and it is starting to bug me....

Lordkinjo
http://eonlinestores.com

[esm]

it's a bug. to correct it, remove the primary unique setting for the link_id field in the idx_votes table

see http://www.nicecoder.com/community/s...&threadid=1405

[tjoerg]

Hello esm,

I didn't encounter the "stars rating problem" so I asume that the error must be within the install.php when doing a new installation.

I guess it must be in line 379:

`link_id` mediumint(9) NOT NULL default '0',

should be like:

'link_id' mediumint(9) default NULL,

...but dody knows best!

greets

Joerg

[lordkinjo]

esm,
Thank you... that did the trick

Lordkinjo