Recent Topics

[3.3.3] User agents stats

started by on Apr 20, 2010 – Last touched: Apr 20, 2010

Apr 20, 2010 14:11    

Hi,

Most the time, I canot display user agent statistics.

Please, let me know if you need more informations.

MySQL error!

The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay(Errno=1104)

Your query: Results::Query()

SELECT agnt_signature, agnt_type, COUNT( hit_ID ) AS hit_count

FROM evo_useragents LEFT JOIN evo_hitlog ON agnt_ID = hit_agnt_ID
WHERE agnt_type IN ('browser','robot','rss','unknown')

GROUP BY agnt_ID
ORDER BY hit_count DESC
LIMIT 0, 20


Form is loading...

powered by b2evolution – This forum is powered by b2evolution CMS, a complete engine for your website.