• Resolved themintandonly

    (@themintandonly)


    Today I updated the WP-Statistics Plugin and after that, on all my Statistics Sites it says: “Plugin tables do not exist in the database! Please re-run the install routine.”
    I’ve done that, it also says “Install routine complete.” but the “Install now” Button is still there – and my Statistics doesn’t work! I don’t see anything.
    Can anyone please help me? Thanks!

    https://www.ads-software.com/plugins/wp-statistics/

Viewing 15 replies - 1 through 15 (of 23 total)
  • Same problem here. After update to the new Version i have exactly the same problem.

    Plugin Contributor Greg Ross

    (@gregross)

    The rerun install button will remain available at all times so that is fine.

    Does the “tables do not exist” message still get displayed?

    Can you check your database and see what tables exist, there should be several that start with “wp_statistics_”?

    Yes, i got the “tables do not exist” message.

    (Die Plugin-Tabellen existieren nicht in deiner Datenbank! Bitte führe die Plugin-Installationsroutine noch einmal aus.)

    In the MySQL Database, i can see the following Tables:

    wp_statistics_exclusions
    wp_statistics_historical
    wp_statistics_pages
    wp_statistics_search
    wp_statistics_useronline
    wp_statistics_visit
    wp_statistics_visitor

    If you still need information, please let me know

    Kuhlma

    Plugin Contributor Greg Ross

    (@gregross)

    Can you run the following SQL query and let me know what the output is? Replace {$dbname} with your database name.

    SHOW TABLES WHERE Tables_in_{$dbname} = 'wp_statistics_visitor' OR Tables_in_{$dbname} = 'wp_statistics_visit' OR Tables_in_{$dbname} = 'wp_statistics_exclusions' OR Tables_in_{$dbname} = 'wp_statistics_historical' OR Tables_in_{$dbname} = 'wp_statistics_pages' OR Tables_in_{$dbname} = 'wp_statistics_useronline' OR Tables_in_{$dbname} = 'wp_statistics_search'

    The output say this message:

    #1054 – Unknown column ‘Tables_in_kuhlma’ in ‘where clause’

    But the problem ist, that the name from my sql database contains this sign (-) without (). He canot display the result. The name of my database (kuhlma-xx.de). Is it possible that the hyphen in the database name is the problem?

    Hello,

    i have update WP Statics (Version 9.5) and i run the following SQL :

    MySQL a retourné un résultat vide (aucune ligne). (Traitement en 0.0014 sec)

    Plugin Contributor Greg Ross

    (@gregross)

    @kuhlma: Yes the hyphen is the problem, the fix is to use backticks around the “Tables_in_dbname” in the sql query.

    I’ll release a fixed version shortly.

    Thank you for your response and the fast support!

    Plugin Contributor Greg Ross

    (@gregross)

    No problem, let me know if 9.5.1 doesn’t resolve the issue for you.

    I had the same problem and it works after installing the version 9.5.1. Many thanks for fixing this issue really fast.

    thx, 9.5.1 it’s ok for me.

    After install wp-statics 9.5.1 the problem ist fixed! THANK YOU!

    Hi.
    I have just installed WP statistics 9.5.1 on WP 4.2.4, but I’m still getting the “Plugin tables do not exist in the database!” error.

    I confirm that the tables exist, using phpMyAdmin. wp_cdrs_statistics_exclusions and the other tables are there.

    When I run
    SHOW TABLES WHERE Tables_in_webisr_dev = 'wp_cdrs_statistics_visitor' OR Tables_in_webisr_dev = 'wp_cdrs_statistics_visit' OR Tables_in_webisr_dev = 'wp_cdrs_statistics_exclusions' OR Tables_in_webisr_dev = 'wp_cdrs_statistics_historical' OR Tables_in_webisr_dev = 'wp_cdrs_statistics_pages' OR Tables_in_webisr_dev = 'wp_cdrs_statistics_useronline' OR Tables_in_webisr_dev = 'wp_cdrs_statistics_search'

    I get the tables:

    Tables_in_webisr_dev
    wp_cdrs_statistics_exclusions
    wp_cdrs_statistics_historical
    wp_cdrs_statistics_pages
    wp_cdrs_statistics_search
    wp_cdrs_statistics_useronline
    wp_cdrs_statistics_visit

    Print scree at: https://img42.com/v856y+

    Any ideas why? Thank you

    Plugin Contributor Greg Ross

    (@gregross)

    Your missing the wp_cdrs_statistics_visitor table.

    So, any ideas why the plugin did not create that table?
    Should I manually create it?

Viewing 15 replies - 1 through 15 (of 23 total)
  • The topic ‘Re-run Install does not work after Update!’ is closed to new replies.