Statistics visitors always shown zero
-
Hi,
I follow the steps of topic resolved but the problem remain.
This is the site, but statistics are no public
-
I’m not sure how they would check the statistics inside your WordPress install…
It really shouldn’t be that hard to get access to the PHP log. It is the next step in troubleshooting what is going wrong.
After check it my provider (serverpoint) said the issue is with the plugin wp-statistics. Can we reinstall this plugin?
At this moment not only the visitors, but also the visit shown zero. I appreciate your help.
You can try it, no harm in it.
There is a risk to lose the data?
As long as you don’t use the removal option in settings then all data is maintained.
Simply go to the WordPress plugins page, deactivate WP Statistics and then remove it.
Of course it is always best practice to backup your database π
I do reinstall the plugin but the problem remain. I download the via ftp the document wp-login-php. Do you refer to this?
No we don’t touch wp-login.
At this point you’re going to have to get access to your PHP log file to do any more troubleshooting.
Th error log look like if the plugin wordpress statistics is not compatible with my wordpress version. (WordPress database error Unknown column ‘created’ in ‘field list’ for query INSERT INTO
wp_statistics_useronlineβ¦WordPress database error Unknown column ‘hits’ in ‘field list’ for query INSERT IGNORE INTO wp_statistics_visitorβ¦)Can you check your database tables and structure with phpMyAdmin? There should be 6 tables wp_statistics_*, the should have the following structure:
CREATE TABLE wp_statistics_useronline ( ID int(11) NOT NULL AUTO_INCREMENT, ip varchar(60) NOT NULL, created int(11), timestamp int(10) NOT NULL, date datetime NOT NULL, referred text CHARACTER SET utf8 NOT NULL, agent varchar(255) NOT NULL, platform varchar(255), version varchar(255), location varchar(10), PRIMARY KEY (ID) ); CREATE TABLE wp_statistics_visit ( ID int(11) NOT NULL AUTO_INCREMENT, last_visit datetime NOT NULL, last_counter date NOT NULL, visit int(10) NOT NULL, PRIMARY KEY (ID) ); CREATE TABLE wp_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), version varchar(255), UAString varchar(255), ip varchar(60) NOT NULL, location varchar(10), hits int(11), honeypot int(11), 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) ); CREATE TABLE wp_statistics_exclusions ( ID int(11) NOT NULL AUTO_INCREMENT, date date NOT NULL, reason varchar(255) DEFAULT NULL, count bigint(20) NOT NULL, PRIMARY KEY (ID), KEY date (date), KEY reason (reason) ); CREATE TABLE wp_statistics_pages ( uri varchar(255) NOT NULL, date date NOT NULL, count int(11) NOT NULL, id int(11) NOT NULL, UNIQUE KEY date_2 (date,uri), KEY url (uri), KEY date (date), KEY id (id) ); CREATE TABLE wp_statistics_historical ( ID bigint(20) NOT NULL AUTO_INCREMENT, category varchar(25) NOT NULL, page_id bigint(20) NOT NULL, uri varchar(255) NOT NULL, value bigint(20) NOT NULL, PRIMARY KEY (ID), KEY category (category), UNIQUE KEY page_id (page_id), UNIQUE KEY uri (uri) );Closing due to inactivity.
The topic ‘Statistics visitors always shown zero’ is closed to new replies.