Errors in DB Period 201705

  • Resolved kvltmagazinepl

    (@kvltmagazinepl)


    9 years, 4 months ago

    Hi All!

    I have a problem with data. In databes i found a lot off rows. My website stop working. I check tabel wp_post_views was the problem. In this tabel was 650000 rows.
    I clean it manualy just leave important data. Everything works now.
    Now I see that I have a lot of period ‘201705’!? why? in future?
    I clean it, but after some time i have more those rows. 🙁

    Please help

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author dFactory

    (@dfactory)

    9 years, 4 months ago

    Hi,

    Regarding your first problem – number of rows – 99% of these are daily views probably. Just use Reset Data Interval option to clean things up from time to time. It will not remove all of your data, but only the daily stats, that are the great majority of all the post views db records.

    Regarding the ‘201705’ – PVC stores post views in a couple of date types records – years, months, weeks, days and total and uses them when it needs to in specific db queries.

    So what you see as ‘201705’ is probably of type 1 (weekly counts) – so in your case it’s the views count for the 5th week of the year.

    So it’s not the future 🙂

    Regards,
    Bartosz Arendt
    dfactory team

    Thread Starter kvltmagazinepl

    (@kvltmagazinepl)

    9 years, 4 months ago

    Thanks for explanation. I thought that is YYYYMMDD, YYYYMM, YYYY and total 🙂
    Now it’s clear 🙂 Now I have 25k in post_views and it’s works 🙂
    Thank you very much

    Plugin Author dFactory

    (@dfactory)

    9 years, 4 months ago

    You’re welcome,

    Pzdr. 🙂

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Errors in DB Period 201705’ is closed to new replies.