Some posts have Total Views stuck at zero 0

  • Resolved roderick.young

    (@roderickyoung)


    7 years, 3 months ago

    I’ve noticed that Top 10 tracks most of my posts well, but a few have a count that seems to be stuck at 0, and cannot be updated.

    If I go to the Posts page of the dashboard for the site, Total Views shows as 0, and Today’s Views may be a nonzero number. However, the Total Views number never changes.

    If I open the particular post for editing, the Top 10 Section at the bottom shows the following (sorry, I don’t know how to include a picture):
    Visit Count: 0
    Disable Popular Posts Display: (unchecked)
    Exclude this post from the popular posts list: (unchecked)
    Location of thumbnail: (blank)

    In the above, I have tried to update the Visit Count to some other number such as 20, but after I update the post, the 0 is back. I have also tried checking the boxes, updating, unchecking the boxes, and updating again. The Visit Count is still stuck at 0, and uneditable.

    Actual visits to the page update the daily count, but the total views count is stuck at 0.

    Only some of my posts have this issue. One example is in the link above.

    One thing that the problem posts MAY have in common is that the post date was edited after the fact. I’m not absolutely sure of this, but it seems to affect something that was posted on (say) April 23, then later altered to show a date of April 22.

    Any ideas or suggestions? Thanks in advance!

    The page I need help with: [log in to see the link]

Viewing 3 replies - 16 through 18 (of 18 total)
  • Plugin Author Ajay

    (@ajay)

    Which works for your install. These are just alternate ways to track. You can try both to test what results work better for you.

    I resolved as following:
    1. creating a new, correct, table using the query from includes/activate-deactivate.php
    2. inserting the data: INSERTO INTO wp_top_ten_OK (SELECT postnumber, SUM(cntaccess), blog_id FROM wp_top_ten GROUP BY postnumber, blog_id)
    3. cleaning, in the new table, the strange blog_id entries (0? 12345? negatives!), postnumber too high, etc.
    3. deleting the original table
    4. renaming the new table as the old
    5. profit

    (Ajay, what do you think about checking for existing postnumber and blog_id before inserting? Too much work for the DB?)

    Thanks.

    Plugin Author WebberZone

    (@webberzone)

    The ON DUPLICATE query entry that I run for adding to the database does this checking while inserting. The issue with some versions particularly older installs has had the PRIMARY KEY missing. And my recent update doesn’t seem to have properly fixed this for everyone, so I’m going to release one which has a button to manually recreate the PRIMARY KEY which should hopefully fix this issue with most installs.

Viewing 3 replies - 16 through 18 (of 18 total)
  • The topic ‘Some posts have Total Views stuck at zero 0’ is closed to new replies.