[Plugin: Top 10] Plugin stopped updating daily/total views

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 https://blog.stafflink.ca.

Laura

Laura,

Can you check the DB structure of the plugin

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:

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

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?

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?

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
— https://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?

Do you have any old backups, before you moved?

I think something went wrong during the move.

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.

I went to :

https://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?

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.

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

I’ll give it a try Ajay. Thanks!

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?

I think I just realised part of the issue:

https://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)

WordPress Address (URL): https://blog.stafflink.ca
Site Address (URL): https://blog.stafflink.ca

Thanks for helping me figure this out!