Hi Folks,
I updated version 1.2 to 1.4 automatically but I am having big problems now with MySQL. I looks to me like there is some sort of issue with the idvisitor and config_id fields. Could the direct jump from 1.2 to 1.4 have missed a database schema change? or is it an encoding problem? Any help appreciated. My mysql.log file excerpt below:
FROM piwik_log_visit WHERE visit_last_action_time >= '2011-05-20 20:22:00’
AND idsite = ‘1’ AND config_id = '��_
��_�’
ORDER BY visit_last_action_time DESC
LIMIT 1
51 Query UPDATE piwik_log_visit
SET visit_total_actions = visit_total_actions + 1, visit_exit_idaction_url = ‘163843’, visit_exit_idaction_name = ‘9717’, visit_last_action_time = ‘2011-05-21 20:22:00’, visit_total_time = ‘740’, idvisitor = '�&[_�q�’
WHERE idsite = '1’
AND idvisit = '169225’
51 Query INSERT INTO piwik_log_link_visit_action (idvisit, idsite, idvisitor, server_time, idaction_url, idaction_name, idaction_url_ref, idaction_name_ref, time_spent_ref_action)
VALUES (‘169225’,‘1’,‘�&[_�q�’,‘2011-05-21 20:22:00’,‘163843’,‘9717’,‘163844’,‘9715’,‘10’)
idvisitor is now varbinary so it is expected to see such strange characters (run the SQL HEX(idvisitor) or use Live API to select the human readable idvisitor)
my bad! Looks like I needed to upgrade GeoIP plugin to resolve my problem. Thanks for your assistance matt.