With phpMyAdmin however I see records in the database
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
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
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.
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..
@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
After the update I do not get data anymore….
