WordPress.org

Ready to get started?Download WordPress

Forums

Top 10 - Popular posts plugin for WordPress
%totalcount% off for few posts (10 posts)

  1. Sravsk
    Member
    Posted 1 year ago #

    After plugin upgrade, looks like total count is off for few articles. Is there a way to re-do the total count for specific articles ?

    url : http://reviews.mtbr.com/singlespeeds-are-for-angry-people

    thanks !

    http://wordpress.org/extend/plugins/top-10/

  2. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    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

  3. Sravsk
    Member
    Posted 1 year ago #

    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 http://www.mtbr.com/ under ALL tab !

    thanks,
    Sravanthi

  4. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    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).

  5. Sravsk
    Member
    Posted 1 year ago #

    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)

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

  6. oyeakd
    Member
    Posted 1 year ago #

    Having the same issues on my website

  7. Sravsk
    Member
    Posted 1 year ago #

    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

  8. oyeakd
    Member
    Posted 1 year ago #

    Thanks ... done it ...will observe and give feedback

  9. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks Sravsk. Was this issue when you upgraded?

  10. Sravsk
    Member
    Posted 1 year ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic