Viewing 11 replies - 16 through 26 (of 26 total)
  • Plugin Contributor Greg Ross

    (@gregross)

    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.

    Thread Starter antxonblog

    (@antxonblog)

    After check it my provider (serverpoint) said the issue is with the plugin wp-statistics. Can we reinstall this plugin?

    Thread Starter antxonblog

    (@antxonblog)

    At this moment not only the visitors, but also the visit shown zero. I appreciate your help.

    Plugin Contributor Greg Ross

    (@gregross)

    You can try it, no harm in it.

    Thread Starter antxonblog

    (@antxonblog)

    There is a risk to lose the data?

    Plugin Contributor Greg Ross

    (@gregross)

    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 πŸ™‚

    Thread Starter antxonblog

    (@antxonblog)

    I do reinstall the plugin but the problem remain. I download the via ftp the document wp-login-php. Do you refer to this?

    Plugin Contributor Greg Ross

    (@gregross)

    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.

    Thread Starter antxonblog

    (@antxonblog)

    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…)

    Plugin Contributor Greg Ross

    (@gregross)

    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)
    );
    Plugin Contributor Greg Ross

    (@gregross)

    Closing due to inactivity.

Viewing 11 replies - 16 through 26 (of 26 total)

The topic ‘Statistics visitors always shown zero’ is closed to new replies.