Automatic log parsing on Windows machines fot Matomo (Piwik).
Once again, thanks to: Adrian Ligiewicz (aka the Master of Powershell)
Continue reading Parse logs for Matomo (Piwik) on Windows [using Powershell]
Automatic log parsing on Windows machines fot Matomo (Piwik).
Once again, thanks to: Adrian Ligiewicz (aka the Master of Powershell)
Continue reading Parse logs for Matomo (Piwik) on Windows [using Powershell]
If you’re using Matomo (previously Piwik) on MS IIS and MariaDB and you’re getting a lot of these:
[06-Jun-2018 11:56:36 UTC] Error in Matomo (tracker): Error query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC3_\xC6\x92\xC3\x82...' for column 'name' at row 1 In query: INSERT INTO matomo_log_action (name, hash, type, url_prefix) VALUES (?,CRC32(?),?,?) Parameters: array ( 0 => 'website.com/Ă_ƒÂ¢', 1 => 'website.com/Ă_ƒÂ¢', 2 => 1, 3 => 1, )
You can use my fix (because literally nothing that can be found in the internet is helpful in this case).
Continue reading Brutal fix for “Incorrect string value:” error in Matomo (Piwik)