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?

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

1 Answer 1

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.

3
  • Was the search mechanism affected by this as well? If so the fix might apply to those two bugs too. :) Jul 3, 2013 at 6:48
  • @ShaWizDowArd they are tangentially related, separate issue with how indexing works though Jul 3, 2013 at 10:27
  • Cheers Nick, so you're looking into the search related issues? 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 .