Support » Plugin: Slimstat Analytics » No data anymore

  • Resolved pvwylick

    (@pvwylick)


    The previous version of Slimstat worked OK. The new version: not able to activate Maxmind. Uninstalled Slimstat and reinstalled: no data anymore (default settings)

Viewing 15 replies - 1 through 15 (of 15 total)
  • With phpMyAdmin however I see records in the database

    Plugin Author Jason Crouse

    (@coolmann)

    Hi,

    could you please post a list of columns you see in your wp_slim_stats table? Also, if you have access to your web server error log, do you see anything related to Slimstat there?

    Thanks,
    Jason

    # Naam Type Collatie Attributen Leeg Standaardwaarde Opmerkingen Extra
    1 idPrimaire sleutel int(10) UNSIGNED Nee Geen AUTO_INCREMENT
    2 ip varchar(39) utf8_general_ci Ja NULL
    3 other_ip varchar(39) utf8_general_ci Ja NULL
    4 username varchar(255) utf8_general_ci Ja NULL
    5 country varchar(16) utf8_general_ci Ja NULL
    6 referer varchar(2048) utf8_general_ci Ja NULL
    7 resource varchar(2048) utf8_general_ci Ja NULL
    8 searchterms varchar(2048) utf8_general_ci Ja NULL
    9 plugins varchar(255) utf8_general_ci Ja NULL
    10 notes varchar(2048) utf8_general_ci Ja NULL
    11 visit_id int(10) UNSIGNED Nee 0
    12 server_latency int(10) UNSIGNED Ja 0
    13 page_performance int(10) UNSIGNED Ja 0
    14 browser varchar(40) utf8_general_ci Ja NULL
    15 browser_version varchar(15) utf8_general_ci Ja NULL
    16 browser_type tinyint(3) UNSIGNED Ja 0
    17 platform varchar(15) utf8_general_ci Ja NULL
    18 language varchar(5) utf8_general_ci Ja NULL
    19 user_agent varchar(2048) utf8_general_ci Ja NULL
    20 resolution varchar(12) utf8_general_ci Ja NULL
    21 screen_width smallint(5) UNSIGNED Ja 0
    22 screen_height smallint(5) UNSIGNED Ja 0
    23 content_type varchar(64) utf8_general_ci Ja NULL
    24 category varchar(256) utf8_general_ci Ja NULL
    25 author varchar(64) utf8_general_ci Ja NULL
    26 content_id bigint(20) UNSIGNED Ja 0
    27 outbound_resource varchar(2048) utf8_general_ci Ja NULL
    28 dt_out int(10) UNSIGNED Ja 0
    29 dtIndex int(10) UNSIGNED Ja 0

    I can not access any web logs.

    I enabled SQL debug and this is what it shows on the Acces Log view:

    SELECT id, ip, other_ip, username, country, city, location, referer, resource, searchterms, plugins, notes, visit_id, server_latency, page_performance, browser, browser_version, browser_type, platform, language, user_agent, resolution, screen_width, screen_height, content_type, category, author, content_id, outbound_resource, dt_out, dt FROM feiqw_slim_stats WHERE 1=1 AND dt BETWEEN 1502582400 AND 1505130496 ORDER BY dt DESC LIMIT 0, 1000

    When I run this query if phpMyAdmin, the columns city and location are giving errors. I have removed these from the query and the I get results in phpMyAdmin

    Plugin Author Jason Crouse

    (@coolmann)

    Yes, Slimstat 4.7.2 applies an update to the table schema, specifically by adding those two columns upon upgrade. For some reason (mysql permissions?) the update did not succeed in your case. You can add those two columns manually in php my admin, with the following code:

    ALTER TABLE wp_slim_stats ADD COLUMN city VARCHAR(255) DEFAULT NULL AFTER country, ADD COLUMN location VARCHAR(36) DEFAULT NULL AFTER country

    Make sure to use the correct table/prefix name for your configuration.

    Keep me updated.

    Jason

    That works!
    Thanks.

    Plugin Author Jason Crouse

    (@coolmann)

    Terrific! Thank you for your quick feedback.

    Best,
    Jason

    Hello,

    I don’t get it to work. Location and City looks fine for me (phpMyAdmin). Like pvwylick I can not access any web logs.

    WordPress debug would be an option but I’ll roll back to 4.71

    Thank you Jason and pvwylick

    The roll back or slimstat doesn’t work after overwrting the files, ftp. Now I have to uninstall the plugin and install it again.

    The roll back or slimstat doesn’t work after overwrting the files, ftp. Now I have to uninstall the plugin and install it again.

    Plugin Author Jason Crouse

    (@coolmann)

    The roll back or slimstat doesn’t work after overwrting the files, ftp. Now I have to uninstall the plugin and install it again.

    Please keep in mind that uninstalling Slimstat from the admin will DELETE ALL THE DATA collected by the plugin. Make sure to backup your tables before you do that.

    Jason

    Just did a new install of the plugin. No errors, but no data either. I needed to run the SQL statement adding city and location to make it work. Just chiming in to let you know more people might have this issue..

    Plugin Author Jason Crouse

    (@coolmann)

    @nielsgoossens yes, we are aware of this issue. A fix is being added to the next update. Thank you for pointing it out, though.

    Jason

    pvwylick

    (@pvwylick)

    After the update I do not get data anymore….

Viewing 15 replies - 1 through 15 (of 15 total)
  • The topic ‘No data anymore’ is closed to new replies.