Statistics are not reflecting as Re-run Install is not working after Update

  • Resolved webrolls34

    (@webrolls34)


    8 years, 11 months ago

    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.

    PHP Version: 5.3.28

    WP Statistics Version: 9.6.6

    Server: SQL Server2012 Version: 11.0.3128

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

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

    (@gregross)

    WordPress doesn’t support MS SQL and so we don’t either, the SHOW TABLE command is MySQL specific.

    Thread Starter webrolls34

    (@webrolls34)

    But I am getting Test Report on my Email ID. It shows correct number of Online Users same as reflecting in my Database table. The report reflecting Today Visitor: 0 Today Visit: 0 and as I checked there is no data found in respective tables. Can please you assist me to get all these correct reports via Email?

    Plugin Contributor Greg Ross

    (@gregross)

    I’m sorry but WP Statistics does not work with MS SQL, if you want to use WP Statistics you will need to replace MS SQL with MySQL.

    The above SQL command is just one of many MySQL specific SQL queries we use in the code.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Statistics are not reflecting as Re-run Install is not working after Update’ is closed to new replies.