Support » Plugin: WP Statistics » Plugin tables do not exist in the database! Please re-run the install routine .

Viewing 15 replies - 1 through 15 (of 30 total)
  • Plugin Contributor Greg Ross

    (@gregross)

    Can you check to see which tables exist in the database, they start with “wp_statisitcs_”.

    Thanks Greg for fast response,

    I’m new to word press and I don’t know how can i check tables in data base.
    do I need to install any plugins?

    Thanks

    Plugin Contributor Greg Ross

    (@gregross)

    Usually your hosting provider includes a SQL admin console (usually phpMyAdmin) that will let you take a look at the tables.

    You can just try re-running the install script (Statistics->Optimization->Database) as well.

    I re-run it and I got this massage “Install routine complete.” but still not working.
    I found out hot to access to database and I found 6 tables with “wp_statisitcs_”

    Plugin Contributor Greg Ross

    (@gregross)

    There should be seven, can you tell me which ones you have?

    I have visit, useronline, search,pages,historical and exclusions

    Plugin Contributor Greg Ross

    (@gregross)

    Can you run the following SQL command and tell me what it says?

    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)
    		) CHARSET=utf8

    I have same problem
    And more Your sql command has a syntax error for phpMyAdmin
    Can you control syntax?

    Plugin Contributor Greg Ross

    (@gregross)

    What does the error say? It runs fine on my phpMyAdmin.

    Note, if the table already exists it will fail obviously.

    Thanks, It worked for me

    Plugin Contributor Greg Ross

    (@gregross)

    @maxwork: can you check your php error logs around the time you ran the upgrade script and see if there were any errors?

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versionplatform (platform), KEY version (‘ at line 14

    MySQL

    Versione del server: 5.0.92-enterprise-gpl-log

    I’m having the same problem. Brand new WordPress install.

    My blog is katsura.uk – prefix is wp_katsura.

    I can see the following tables:

    | wp_katsuracommentmeta |
    | wp_katsuracomments |
    | wp_katsuralinks |
    | wp_katsuraoptions |
    | wp_katsurapostmeta |
    | wp_katsuraposts |
    | wp_katsurastatistics_exclusions |
    | wp_katsurastatistics_historical |
    | wp_katsurastatistics_pages |
    | wp_katsurastatistics_search |
    | wp_katsurastatistics_useronline |
    | wp_katsurastatistics_visit |
    | wp_katsuraterm_relationships |
    | wp_katsuraterm_taxonomy |
    | wp_katsuraterms |
    | wp_katsurausermeta |
    | wp_katsurausers

    From what I understand, reading your earlier replies, I should have a table called wp_statistics_visitor.

    Running the SQL you suggested I get an error too:

    mysql> 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)) CHARSET=utf8
    -> ;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘version(75)), KEY agent (agent), KEY platform (platform), KEY version (version),’ at line 1

    Plugin Contributor Greg Ross

    (@gregross)

    Try the following SQL:

    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)
    		) CHARSET=utf8
Viewing 15 replies - 1 through 15 (of 30 total)
  • The topic ‘Plugin tables do not exist in the database! Please re-run the install routine .’ is closed to new replies.