Hi all, I have installed Matomo in 3 different servers and I can’t track any page through the javascript script on the header.
https://%DNS%/piwik/piwik.php?rec=1&idsite=1
result:
Error:Error query: SQLSTATE[HY000]: General error: 1366 Incorrect string value: ‘\xB7\xFC\xD6N\xFFI…’ for column ‘message’ at row 1 In query: INSERT INTO matomo_logger_message (tag, timestamp, level, message) VALUES (?, ?, ?, ?) Parameters: array ( 0 => ‘Piwik\Tracker\Handler’, 1 => ‘2023-02-28 14:33:25’, 2 => ‘ERROR’, 3 => 'ERROR Piwik\Tracker\Handler[2023-02-28 14:33:25 UTC] [4c064] Exception: /var/www/html/piwik/core/Tracker/Db/Pdo/Mysql.php(237): Error query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'config_device_nwefftype' in 'field list' In query: SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_seconds_since_first, visitor_seconds_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, idsite, profilable, visit_entry_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_url, config_browser_name, config_client_type, config_device_brand, config_device_model, config_device_type, visit_total_events, config_device_nwefftype, config_device_nwtype, visit_total_time, location_ip, location_browser_lang, last_idlink_va, custom_dimension_1, custom_dimension_2, custom_dimension_3, custom_dimension_4, custom_dimension_5 FROM matomo_log_visit WHERE visit_last_action_time >= ? AND visit_last_action_time <= ? AND idsite = ? AND config_id = ? ORDER BY visit_last_action_time DESC LIMIT 1 Parameters: array ( 0 => '2023-02-28 14:03:25', 1 => '2023-02-28 15:03:25', 2 => 1, 3 => '���N�I�