Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Author Ajay

    (@ajay)

    Only way to go about this is to adjust the cntaccess field in the “tptn_” tables of the database.

    However, please be careful if you intend to do so. And, always backup before making any changes

    Thread Starter Sravsk

    (@sravsk)

    Hi Ajay,

    Can you elaborate a little more for me. What do you mean when you say “adjust” the cntaccess field ? As i see, this issue seems to have started as soon as i upgraded & have been wrong for all new posts. If there is no work around please let me know.

    You can look at all new posts at https://www.mtbr.com/ under ALL tab !

    thanks,
    Sravanthi

    Plugin Author Ajay

    (@ajay)

    Do you still have “(Visited %totalcount% times, %dailycount% visits today)” under Output options?

    By adjust I mean you’ll need to edit the entries within your database via phpMyAdmin.

    Do you think you can share the extract of the tptn_ tables in your database with me (no other tables needed).

    Thread Starter Sravsk

    (@sravsk)

    Yes, i didn’t edit output options. It’s the same.

    Also, can you define extract ? Do you need a copy of the entire table ?
    Can you work with few entries ?

    wp_top_ten_Daily table :

    postnumber cntaccess dp_date
    58158 1 2013-03-07
    57861 1 2013-03-07
    59703 1 2013-03-07
    74552 1 2013-03-07
    1269 1 2013-03-07
    12218 1 2013-03-07
    74552 1 2013-03-07
    62694 1 2013-03-07
    15197 1 2013-03-07
    74782 1 2013-03-07
    74552 1 2013-03-07
    72384 1 2013-03-07
    74782 1 2013-03-07
    74552 1 2013-03-07
    74782 1 2013-03-07
    15197 1 2013-03-07

    wp_top_ten table :

    postnumber cntaccess
    27269 11309
    27263 226
    27111 3633
    27254 87
    8908 1763
    6 34508
    9 3157
    10 6921
    11 978
    12 1232
    13 32215
    15 18425
    27 2001
    28 1835
    30 403
    32 1331
    33 12
    35 1596
    36 14
    37 1235

    All New/recent posts have (Visited 1 times, xxx visits today)

    https://reviews.mtbr.com/cratoni-back-in-the-usa-with-all-new-rocket-mtb-helmet

    Having the same issues on my website

    Thread Starter Sravsk

    (@sravsk)

    Oyekd :

    Check if wp_top_Ten & wp_top_ten_daily tables have primary key set. We had to manually create new tables ( that set primary key) and then transfer “good” data to new tables. The INSERT query won’t work if you don’t have primary key set for those tables.

    INSERT INTO $table_name (postnumber, cntaccess) VALUES(‘$id’, ‘1’) ON DUPLICATE KEY UPDATE cntaccess= cntaccess+1

    Thanks … done it …will observe and give feedback

    Plugin Author Ajay

    (@ajay)

    Thanks Sravsk. Was this issue when you upgraded?

    Thread Starter Sravsk

    (@sravsk)

    Yes, the plugin was working fine ( although we had severe page load/database issues) before the upgrade. I speculate the primary key somehow got messed up while upgrade & so had to re-do it manually.

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘%totalcount% off for few posts’ is closed to new replies.