Hi @service2client,
That’s odd. That specific error message is telling you that at least one of WPP’s database tables is missing from your database. Uninstalling and reinstalling the plugin should recreate WPP’s database tables automatically (it will also delete all of your popular posts data), it’s strange that that’s not the case for you.
If you have a recent database backup I would suggest restoring that so you can recover your missing DB tables and their data. You could also try executing these MySQL queries to recreate the missing table(s):
CREATE TABLE IF NOT EXISTS wp_popularpostsdata (
postid bigint NOT NULL,
day datetime NOT NULL,
last_viewed datetime NOT NULL,
pageviews bigint DEFAULT '1',
PRIMARY KEY (postid),
UNIQUE KEY id (postid)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS wp_popularpostssummary (
ID bigint NOT NULL AUTO_INCREMENT,
postid bigint NOT NULL,
pageviews bigint NOT NULL DEFAULT '1',
view_date date NOT NULL,
view_datetime datetime NOT NULL,
PRIMARY KEY (ID),
KEY postid (postid),
KEY view_date (view_date),
KEY view_datetime (view_datetime)
) ENGINE=InnoDB;
CREATE TABLE IF NOT EXISTS wp_popularpoststransients (
ID bigint NOT NULL AUTO_INCREMENT,
tkey varchar(191) NOT NULL,
tkey_date datetime NOT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB;
