FireStats 1.5.2 does not work on MySQL 4.1.22 in some cases.

[omry]

outputs this when trying to access statistics page:

error evaluating response : Response text:
שגיאת בסיס נתונים: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation 'regexp'

SQL Query:
SELECT useragent FROM wp_firestats_useragent_classes right join (SELECT 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)' AS useragent UNION SELECT 'msnbot/1.1 (+http://search.msn.com/msnbot.htm)' AS useragent UNION SELECT 'Mozilla/5.0 (compatible; Yahoo! Slurp/3.0; http://help.yahoo.com/help/us/ysearch/slurp)' AS useragent UNION SELECT 'Gigabot/3.0 (http://www.gigablast.com/spider.html)' AS useragent UNION SELECT 'Technoratibot/0.7' AS useragent UNION SELECT 'YahooFeedSeeker/2.0 (compatible; Mozilla 4.0; MSIE 5.5; http://publisher.yahoo.com/rssguide)' AS useragent UNION SELECT 'Java/1.6.0_02' AS useragent) urls ON useragent REGEXP wildcard GROUP BY useragent HAVING count(wildcard) > 0

info:

• WP 2.3.2
• PHP 4.4.7
• MySQL 4.1.22

[omry]

can't reproduce with a clean db on 4.1.22, waiting for a database snapshot.

[omry]

worked around on mysql 4.1.x by prepanding _utf8 to literals (urls and useragents).

see mysql bug http://bugs.mysql.com/bug.php?id=35896