WordPress.org

Ready to get started?Download WordPress

Forums

Top 10 - Popular posts plugin for WordPress
[Plugin: Top 10] Plugin stopped updating daily/total views (41 posts)

  1. wellesley
    Member
    Posted 1 year ago #

    My install of Top 10 has stopped counting views, both daily and in total. I am running version 1.9.1.

    The only major change lately was that my service provider migrated my hosted site to a new server. I don't see how this could be related as all of the WordPress data and SQL databases went over to the new server.

    One thing I did notice after the migration was that the permalinks structure was changed from a customized one I had created to one of the standard options offered by WordPress. I have since changed it back to a custom structure.

    Either way, none of the posts are collecting views on Top 10.

    Help!

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

  2. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Could you please post your site URL?

    Also, how soon back did you notice this change?

  3. wellesley
    Member
    Posted 1 year ago #

  4. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    For some reason, I see the URL being returned as http://wellesleyservices.ca/temp/wp-content/plugins/top-10/top-10-addcount.js.php?top_ten_id=2999

    Do you know why you have the /temp/ being added in automatically?

    Are you Settings > General using this option?

  5. wellesley
    Member
    Posted 1 year ago #

    Yes, the wordpress files are installed to a folder called temp. They've always been there, it was never an issue before. The Settings > General setting for the URL of the site reflects this configuration.

  6. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Seems like a configuration change is causing a problem. If you visit the link above, you'll notice the 404 error.

    The issues is that even http://wellesleyservices.ca/wp-content/plugins/top-10/top-10-addcount.js.php?top_ten_id=2999
    is throwing up an error.

    Could you please verify what is the exact path of the file?

  7. wellesley
    Member
    Posted 1 year ago #

    The filepath is correct in the first instance, with the "temp" folder:

    http://wellesleyservices.ca/temp/wp-content/plugins/top-10/top-10addcount.js.php?top_ten_id=2999

    I also get the 404 error, yet the file is there. I have re-checked on both my host's file maanger, and by directly logging into my site via ftp:// through Internet Explorer.

    From the WP admin panel the plugin operates normally and gives no indication that any files are missing or cannot be executed.

  8. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    I have a feeling this is something to do with the permalinks and the way WordPress is interpreting it.

    Do you have any other plugin installed that you can access?

  9. wellesley
    Member
    Posted 1 year ago #

    Now that you mention it I had a download manager plugin that stopped working, giving me broken links.

    All the others appear to be working fine though, including Event Espresso, which is my most important one.

  10. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Maybe you can try resaving your permalinks?

  11. uradvd
    Member
    Posted 1 year ago #

    Yes i am stopped total count posts, dayli its works

  12. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    uradvd, please post your website URL for me to check.

  13. uradvd
    Member
    Posted 1 year ago #

    i am fix
    in update query ALTER IGNORE TABLE wp_top_ten ADD PRIMARY KEY (postnumber); not in works, manual in mysql query

    CREATE TEMPORARY TABLE wp_top_ten_temp AS SELECT * FROM wp_top_ten GROUP BY postnumber;
    TRUNCATE TABLE wp_top_ten;
    ALTER IGNORE TABLE wp_top_ten ADD PRIMARY KEY (postnumber);
    INSERT INTO wp_top_ten SELECT * FROM wp_top_ten_temp;
  14. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    What error did you get in the update?

    Can you post a screenshot of the Structure of your mySQL tables wp_top_ten and wp_top_ten_daily?

  15. uradvd
    Member
    Posted 1 year ago #

    not error in update plugin
    previous db structure after update to version 1.9.1, not work count post, dayli is works

    CREATE TABLE IF NOT EXISTS wp_top_ten (
    postnumber int(11) NOT NULL,
    cntaccess int(11) NOT NULL,
    KEY postnumber (postnumber)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

    my fix to version 1.9.1 plugin work fine

    CREATE TABLE IF NOT EXISTS wp_top_ten
    (
    postnumber int(11) NOT NULL,
    cntaccess int(11) NOT NULL,
    PRIMARY KEY (postnumber)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

  16. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Thanks for the update. I need to check if something didn't work on the plugin update if another user reports it.

  17. lauraupcott
    Member
    Posted 1 year ago #

    Hi Ajay,

    I am having the same problem. The Top Ten plugin is not updating my Total/Today's views.

    My latest two posts have 126 and 107 page views in Google Analytics. But the Top Tep plugin is showing 0 visits for both.

    I haven't change servers recently. But I did migrate from shared hosting to a VPS a few months ago.

    My URL is http://blog.stafflink.ca.

    Laura

  18. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Laura,

    Can you check the DB structure of the plugin

  19. lauraupcott
    Member
    Posted 1 year ago #

    Hi Ajay,

    What should I look for when I check the database structure?

    Here's a link to a screen capture of my bb0_top_ten database Structure tab in phpMyAdmin:

    http://blog.stafflink.ca/wp-content/uploads/2012/09/bb0_top_ten_db_structure.jpg

  20. lauraupcott
    Member
    Posted 1 year ago #

    Actually, I just noticed this error message that appeared in phpMyAdmin when the Structure tabs is selected on the bb0_top_ten DB w: MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0001 sec )

    Maybe thats the problem. Any idea how I can fix it?

  21. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Is there a reason your database starts with bb0? Was it always the same?

    Can you try backing up these 2 tables of top ten. Then deactivating the plugin and finally deleting it via the plugins page?

    Then reinstall the plugin?

  22. lauraupcott
    Member
    Posted 1 year ago #

    I don't know why the database starts with bb0. I also have a Top Ten table called bl_top_ten. But the top ten list in my sidebar is taking the counts from the bb0 table. I think this problem started when I changed themes a few months ago.

    Your plugin is great! I just wish I could reinstall it without losing the page view counts.

    I don't know how to save the page view counts because when I export the bb0 table, its doesn't show the page views:

    `-- phpMyAdmin SQL Dump
    -- version 3.4.10.1
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Sep 20, 2012 at 07:37 PM
    -- Server version: 5.1.63
    -- PHP Version: 5.2.6

    SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
    SET time_zone = "+00:00";

    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    /*!40101 SET NAMES utf8 */;

    --
    -- Database: lauraupc_blog
    --

    -- --------------------------------------------------------

    --
    -- Table structure for table bb0_top_ten
    --

    CREATE TABLE IF NOT EXISTS bb0_top_ten (
    accessedid int(11) NOT NULL AUTO_INCREMENT,
    postnumber int(11) NOT NULL,
    cntaccess int(11) NOT NULL,
    PRIMARY KEY (accessedid)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

    /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

    But at least the counts still show up in the sidebar.

    So I think I will lose the data, even with the backup.

    I may have to start over again with an empty table.

    Is there anyway I can get the page view counts back into the Top Ten list after I reinstall?

  23. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    Do you have any old backups, before you moved?

    I think something went wrong during the move.

  24. lauraupcott
    Member
    Posted 1 year ago #

    I do have some database backups through Backup Buddy.

    I installed the Sucuri plugin a few weeks ago. I ran some function it has some functions to "harden" the site. I think that's about the same time that the Top Ten plugin stopped incrementing.

  25. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    I went to :

    http://blog.stafflink.ca

    Is this the right one?
    I see popular posts in the right, which means the counts exist in the database?

    Can you check which of the top_ten dbs have this since you seem to have duplicate ones?

  26. lauraupcott
    Member
    Posted 1 year ago #

    Yes, that's the right site and the count does exist. It's associated with the bb0_top_ten database. I can tell because the ctnaccess counts were the same as the numbers showing in the Popular Post sidebar widget. But now I cannot access the "Browse" tab for bb0_top_ten in phpMYADMIN because a big red "X" appears when I hover over it.

    I'm not sure how it got associated with the bb0_top_ten database. I think the "bb" prefix stands for "Backup Buddy" so I might have created it as a backup when I changed themes a few months ago.

    It stopped adding new visits to the count about 2 weeks ago. I know this because my last few post show 0 visits in my WP dashboard.

  27. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    My confusion is that it shouldn't be the bb0 database. What's the prefixes for your other tables, i.e. the XX_postse.g.

    There are definitely counts sitting in the main XX_top_ten db because the site still shows counts. This wouldn't have happened if the db was empty.

    My suggestion is to find this db, export from phpMyAdmin all the counts, delete the plugin from WP Admin > Plugins and then re-add it and reconfigure the options.
    Once you're done, check if counts are being updated by logging out and browsing through your site.

    You can then reimport the database you exported earlier.

    Of course, make sure your whole site is backed up before

  28. lauraupcott
    Member
    Posted 1 year ago #

    I'll give it a try Ajay. Thanks!

  29. lauraupcott
    Member
    Posted 1 year ago #

    You are right. The database is not bb0_top_ten. It's bl_top_ten.

    As you suggested, I exported the bl_top_ten db. Then I deleted and re-installed the top 10 plugin. Then I logged out and browsed through the 6 most recent posts on my site. Then I logged back in to see if the counts were updated in Top 10 plugin. But the counts were not registered in the Top 10 plugin lists. Total / Today's Views still shows as 0/0. Also, the Top 10 Daily and Overall Popular Posts lists are empty.

    I'm not sure why, but even after deleting the plugin and re-installing, it is still not counting up the visits.

    Is there anything else I can do to try to get this working again?

  30. Ajay
    Member
    Plugin Author

    Posted 1 year ago #

    I think I just realised part of the issue:

    http://blog.stafflink.ca/wp-content/plugins/top-10/top-10-addcount.js.php?top_ten_id=9592

    gives 404 errors.

    Can you tell me in Settings > General
    What is your options of:

    WordPress Address (URL)
    Site Address (URL)

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.