What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 127 Stack Exchange communities.

I noticed that the Users.Views field for every single active user is extremely out of date. It is even zero/missing for some (not too new) users.

enter image description here


http://data.stackexchange.com/stackoverflow/query/110401/user-profile-views?UserId=335858 http://stackoverflow.com/users/335858/dasblinkenlight

This user's account is almost 3 years old, yet...

His profile shows 10k views. The DE shows 0.

Another Example:

http://data.stackexchange.com/stackoverflow/query/110401/user-profile-views?UserId=505088 http://stackoverflow.com/users/505088/david-heffernan

  • Profile Views: 23k
  • Data Explorer Views: 1284

Did I get the query wrong? Or have user views on the Data Explorer not been updated in years?

share|improve this question
Mine says 344. Oh, and 7 on Meta! Ding ding ding, winner! –  animuson Apr 27 '13 at 14:50
Running it on myself shows 0. ahaha –  Mysticial Apr 27 '13 at 14:51
I've just ran into this bug myself. Just now, it shows that our Thomas Pornin has 22 views. Pretty strange. –  Adnan May 23 '13 at 16:43
FWIW my query for the Least Viewed Questions (data.stackexchange.com/stackoverflow/query/116139/…) also demonstrates out of date behaviour. For example, questions which appear as having 1 or 2 views actually have 42. –  Daniel Daranas May 24 '13 at 12:32
@DanielDaranas That one is different. The DE is only updated once a week. But profile views haven't been updated in years. –  Mysticial May 24 '13 at 16:48
Shouldn't there be some form of script that does what DE does? Sounds like Profile Views is a manually run script that has been lost to the ages... –  Kurt Wagner May 29 '13 at 23:32
add comment

1 Answer

up vote 5 down vote accepted

Looks like this has been broken ever since we moved ViewCount to another table for both Users and Posts (to relieve some update contention and tangential reasons).

Good news is that makes it an easy fix, it will be corrected when on the next data refresh - when the job runs again this Sunday.

share|improve this answer
Was the search mechanism affected by this as well? If so the fix might apply to those two bugs too. :) –  Shadow Wizard Jul 3 '13 at 6:48
@ShaWizDowArd they are tangentially related, separate issue with how indexing works though –  Nick Craver Jul 3 '13 at 10:27
Cheers Nick, so you're looking into the search related issues? –  Shadow Wizard Jul 3 '13 at 10:32
add comment

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .