Re-run Install does not work after Update!

Not sure why it didn’t get created, simply go to Statistics->Optimization->Database and re-run the install routine.

If it still doesn’t get created for some reason let me know and I’ll give you a SQL command to create it manually.

Something like this?

DROP TABLE IF EXISTSwp_cdrs_statistics_visitor`;
CREATE TABLE IF NOT EXISTS wp_cdrs_statistics_visitor (
ID int(11) NOT NULL AUTO_INCREMENT,
last_counter date NOT NULL,
referred text NOT NULL,
agent varchar(255) NOT NULL,
platform varchar(255) DEFAULT NULL,
version varchar(255) DEFAULT NULL,
UAString varchar(255) DEFAULT NULL,
ip varchar(60) NOT NULL,
location varchar(10) DEFAULT NULL,
hits int(11) DEFAULT NULL,
honeypot int(11) DEFAULT NULL,
PRIMARY KEY (ID),
UNIQUE KEY date_ip_agent (last_counter,ip,agent(75),platform(75),version(75)),
KEY agent (agent),
KEY platform (platform),
KEY version (version),
KEY location (location)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;`

Pretty much yes, a few typo’s in there though.

This was exported (phpMyAdmin) from a new install of the plugin in another WP installation.

What are the corrections to be made?

Thank you

You’ll notice the first line is missing a space after EXISTS.

There’s also an extra backtick at the end.

Everything else looks fine.

So the Optimization method did not solve the problem, but manually creating the table did. So it’s working now. Thank you so much for the support.

I have used WP Statistics Version:9.6.6. But it is showing message “The following plugin table(s) do not exist in the database, please re-run the install routine : wp_statistics_visitor, wp_statistics_visit, wp_statistics_exclusions, wp_statistics_historical, wp_statistics_useronline, wp_statistics_pages, wp_statistics_search”.

But is I checked in my database the tables exists. I also tried to run Query

SHOW TABLES WHERE Tables_in_Dev_RES = ‘wp_statistics_visitor’ OR Tables_in_Dev_RES = ‘wp_statistics_visit’ OR Tables_in_Dev_RES = ‘wp_statistics_exclusions’
OR Tables_in_Dev_RES = ‘wp_statistics_historical’ OR Tables_in_Dev_RES = ‘wp_statistics_pages’ OR Tables_in_Dev_RES = ‘wp_statistics_useronline’ OR Tables_in_Dev_RES = ‘wp_statistics_search’

But it’s not working and showing error:Incorrect syntax near the keyword ‘WHERE’. Can please anyone assist me to fix the issue. I also re-run the install routine, but issue still exists.

@webrolls34, please open a new thread instead of tacking on to the end of one that has already been closed.

In the new thread, include what version of MySQL you are running.