How to get VW3 ratings back?

**Alfa1** · April 1, 2020

Its great that we have wiki ratings back. But how do we get the ratings from VW3 visible again?

**pegasus** · April 1, 2020

They are not considered separately from new ratings. If you have ratings active, then they are there, and you should be able to view them in the ratings list for each content.

Scores will be rebuilt in the RC 3 upgrade, but since your ratings are from way back in VW3, it's likely most of them have been weighted out of the score by now. They still exist and you can still see them in the ratings list, but they won't affect the score if too many edits have happened after the rating.

**Alfa1** · April 1, 2020

I still have my vb3 + VW3 install. Articles that have ratings on VW3 do not have ratings on VW4.1 There is no rating list. There are 0 ratings for any article in VW4.1

**pegasus** · April 1, 2020

Are there any entries in your vw_rate table?

Also try the following query:

Code:

SELECT revisionid FROM vw_revision WHERE ratingcount > 0

**Alfa1** · April 2, 2020

113 revisions have reputation ratings.
There are 214 entries in vw_rate

**pegasus** · April 2, 2020

I can confirm there is a problem in the link popups for vBulletin and XF 1.x where the link to the existing-rating list is omitted, but it should not affect your ability to visit ?do=ratings manually, and it should not affect whether ratings are connected to the correct content.

There is also a database error on Special:MostRatedPages so it is hard to get a list of pages that have ratings. In library/vw/_core/controller/ui/special/highuse/mostratedpages/vw.php, find:

Code:

'joins' => array(

BEFORE it, add:

Code:

			'count_joins' => array(
				'counter' => 'counter'
			),

If this does not help, please provide an example page that you believe should have ratings already.

**Alfa1** · April 3, 2020

Yes, I can see ratings on ?do=ratings so they are there. The average rating is just not visible on the article yet. How do we get this to display?
Also it doesn't display on category view yet, except for articles with a new rating. I assume there needs to be some rebuild before it shows.

**pegasus** · April 3, 2020

Rating scores will be rebuilt on the next upgrade. However, even afterwards, it is likely that many articles that had VW3 ratings will still have a 0 score. That is because ratings weight out by number of edits ago (a rating that was made 10 edits ago is less valid than a rating made this edit).

To work around this, users can change their ratings whenever they want, and the new rating will be applied to the current edit.