[Plugin: WP SlimStat] Recent Countries / Recent Keywords always empty

I would say it’s something on your end, since it works fine on my test and production environments. Let’s see if other users are experiencing the same problem.

Camu.

Thanks Camu. I wonder how I could debug this. Did not see any useful PHP errors so far..

I’ve asked some friends of mine about this issue, and I was told they are not having this problem. It could be something about your server that WP SlimStat doesn’t “like”, you may want to check your mysql logs…

Camu

you may want to check your mysql logs…

As the sites that use WP Slimstat I take care of run on shared hosts I do not have access to MySQL logs. Only to xfer, error and access logs. Other options?

Hmmm… good question. I may need an admin access to one of these blogs to troubleshoot the issue directly in there. You can send me the credentials to my email address.

Camu

Will create one for you, but would need an e-mail address to send details to. Let me know what address you prefer.

If you are subscribed to my support forum, you can use the same email address you get the notifications from.

Camu

@ Camu Check if you received an e-mail from me to access the site. E-mail address I had from you has been used. Should have been sent to you from the WordPress site in question.

Yep, got it. I’ll take a look at it tomorrow or Tuesday at max, and then I’ll let you know what the ‘doctor’ said ??

Thanks,
Camu

Hi there,

unfortunately it seems like I don’t have write access to test something on your blog, but it looks like something related to your mysql. If you have phpmyadmin running on your production environment, could you please try to execute the following query and see what happens?

SELECT SUBSTRING(t1.searchterms, 1, 35) short_string, t1.searchterms long_string, LENGTH(t1.searchterms) len,
               searchterms, resource, country, DATE_FORMAT( FROM_UNIXTIME( MAX(t1.dt) ), '%d/%m/%Y %H:%i' ) customdatetime
               FROM wp_slim_stats t1
               WHERE t1.searchterms <> '' AND  t1.searchterms <> '__l_s__'   AND t1.dt BETWEEN '1291161600' AND '1293839999'
               GROUP BY short_string, long_string, len
               ORDER BY MAX(t1.dt) DESC
               LIMIT 0,60

Thank you,
Camu

Hi there,

any news on your side?

Camu

Sorry. Been busy. Here the result:

SQL query: Documentation

SELECT SUBSTRING( t1.searchterms, 1, 35 ) short_string, t1.searchterms long_string, LENGTH( t1.searchterms ) len, searchterms, resource, country, DATE_FORMAT( FROM_UNIXTIME( MAX( t1.dt ) ) , '%d/%m/%Y %H:%i' ) customdatetime
FROM wp_slim_stats t1
WHERE t1.searchterms <> ''
AND t1.searchterms <> '__l_s__'
AND t1.dt
BETWEEN '1291161600'
AND '1293839999'
GROUP BY short_string, long_string, len
ORDER BY MAX( t1.dt ) DESC
LIMIT 0 , 60

MySQL said: Documentation
#1111 - Invalid use of group function

As you can see I got a SQL Error..

What version of Mysql are you using?

Also, could you please try this modified version:

SELECT SUBSTRING( t1.searchterms, 1, 35 ) short_string, t1.searchterms long_string, LENGTH( t1.searchterms ) len, searchterms, resource, country, DATE_FORMAT( FROM_UNIXTIME( MAX( t1.dt ) ) , '%d/%m/%Y %H:%i' ) customdatetime, MAX( t1.dt ) max_dt
FROM wp_slim_stats t1
WHERE t1.searchterms <> ''
AND t1.searchterms <> '__l_s__'
AND t1.dt
BETWEEN '1291161600'
AND '1293839999'
GROUP BY short_string, long_string, len
ORDER BY max_dt DESC
LIMIT 0 , 60

Hi again Camu. Here is the result of last successful SQL query here: https://wordpress.pastebin.com/TE186Bgr . I copy pasted the table data created in PMA running this query. You asked the MySQL version this site runs on. I have MySQL 4.1.20 running on this shared hoster’s server