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


https://data.stackexchange.com/stackoverflow/query/110401/user-profile-views?UserId=335858 https://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:

https://data.stackexchange.com/stackoverflow/query/110401/user-profile-views?UserId=505088 https://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?

  • 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. – Adi 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
  • 2
    @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

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.

  • Was the search mechanism affected by this as well? If so the fix might apply to those two bugs too. :) – Shadow The Vaccinated 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 The Vaccinated Wizard Jul 3 '13 at 10:32

You must log in to answer this question.

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