Upgrade Problem 1.2 to 1.4


#1

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’)


(Matthieu Aubry) #2

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)


#3

my bad! Looks like I needed to upgrade GeoIP plugin to resolve my problem. Thanks for your assistance matt.