Reputation; Going from unsigned to signed.

[dodgeboard.com]

After much complaining about unsigned negative reputation, our site is contemplating going to showing the "left by" column. I realize this feature exists in the admincp but some pre-cleanup is needed prior to turning it on.

We would like to clear the "left by" database field for all previously left rep or in other words, not show the "left by" fields retroactively.

If I turn on the "left by" feature now, all users will see who left them unsigned negative reputation and I fear this will cause problems.

Surely there is an SQL query that will clear the "left by" field?

Anyone?

[Jake Bunce]

This will clear the "left by" for existing rep clicks:

UPDATE reputation
SET whoadded = 0

You should backup and test this first. I don't know if this will cause problems with rep features since guests normally can't give rep.

[dodgeboard.com]

Thanks Jake!

vBulletin Message

An error occurred while attempting to execute your query. The following information was returned.

error number: 1062
error desc: Duplicate entry '0-58' for key 2

Hmmm..... Any ideas?

[Jake Bunce]

Oh, that might not work after all. The same user can't rate a post multiple times. That's what the error means. I don't have any other solutions for you.

[dodgeboard.com]

Shucks!!

I'm dealing with a reputation problem. And now they're voting on it and have posted a poll.

[Nick]

You can tell your users that it is not possible to hide all past names and then show them from now on. It seems that is what most of them want. Just tell them you can't and they hopefully will understand.

Have you considered the Post Thanks modification as an alternative? I never enabled reputation on my forum in fear of what is happening on your forum.

If I were to use the reputation system, I would be sure to have it in my rules that disputes regarding the rep system are prohibited and the user will be dealt with accordingly (banned) if they complain about it.
If they don't like the reputation they are receiving, simply don't use the system.

Anyways, the Post Thanks hack is what I use. There is also a Post Groan hack for posts members don't like. All users who thank and groan are displayed publicly though.
But I don't use the Groan. Positive feedback only on my site.

[dodgeboard.com]

I'll give it a look - Thanks!!

[copiertalk]

n/m

forgot this is support and not chit chat, sorry.

[atxtraveler]

I am having trouble in the AdminCP learning how to allow users to see who posted the rep. In the options, I can not find anything to turn on the "left by" option. Can anyone help step a rookie through it?

[Nick]

I am having trouble in the AdminCP learning how to allow users to see who posted the rep. In the options, I can not find anything to turn on the "left by" option. Can anyone help step a rookie through it?

You should always start your own support thread.

This is a Usergroup setting.

AdminCP -> Usergroups -> Usergroup Manager -> Edit -> Reputation ->
Can See Who Left User Ratings - Yes

[atxtraveler]

You should always start your own support thread.

This is a Usergroup setting.

AdminCP -> Usergroups -> Usergroup Manager -> Edit -> Reputation ->
Can See Who Left User Ratings - Yes

Ah.... usergroup.

Thanks Nick!

As for the starting my own thread... most boards prefer to just continue existing topics... I guess I will have to get used to this protocol.

[Nick]

The idea here is one issue per thread
No worries though