25

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

Example:

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?

Improve this question
6
  • Mine says 344. Oh, and 7 on Meta! Ding ding ding, winner!
    – animuson StaffMod
    Commented Apr 27, 2013 at 14:50
  • Running it on myself shows 0. ahaha
    – Mysticial
    Commented Apr 27, 2013 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
    Commented May 23, 2013 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
    Commented May 24, 2013 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
    Commented May 24, 2013 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
    Commented May 29, 2013 at 23:32

1 Answer 1

Reset to default
5

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.

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

You must log in to answer this question.

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