Update 0.5.4 to 0.5.5 and bad consequences


(Pearltrees) #1

On the 04/04 I updated piwik 0.5.4 to 0.5.5 by clicking “update to 0.5.5” on my piwik’s webpage. Everything was good : database updated and succeeded. I checked my log_visit table to ensure my sites were always logged which was the case. But I did not notice that my main site (idsite=1) was not logged anymore !

I tried to see apache error logs but did not find something interesting.
I finally configured php to give me logs… which are empty.

I see all the queries from my website like “
81.240.183.4 - - [06/Apr/2010:18:10:39 +0200] “GET /piwik.php?url=http%3A//www.pearltrees.com/s/Index/flex%3Forigin%3Dcollector%23N-s%3D1_605053%26N-f%3D1_604987%26N-u%3D1_51073%26N-p%3D3565360&action_name=pearltrees%20%20%3E%20murakami%20%3E%20Livres%20et%20%E9crivains%20%3E%20Litterature%20audio.com%20%7C%20Livres%20audio%20gratuits%20%E0%20%E9couter%20et%20t%E9l%E9c&idsite=1&title=pearltrees%20%20%3E%20murakami%20%3E%20Livres%20et%20%E9crivains%20%3E%20Litterature%20audio.com%20%7C%20Livres%20audio%20gratuits%20%E0%20%E9couter%20et%20t%E9l%E9c&urlref= HTTP/1.1” 200 43 “www.pearltrees.com/s/Index/flex?origin=collector” “Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; GTB6.4; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30618; .NET CLR 1.1.4322)”

all HTTP queries are OK (200)

But it doesn’t write my main site actions to the database… Each of the other 5 websites are still ok with piwik

This site (www.pearltrees.com) is a flash UI.

All your advices are welcomed ! I’m really lost in confusion !

Specifics stuffs on the site :

  • We often use “/#” in URLs

some configurations aspects : apache2/php5/mysql5 running on Debian 5 lenny uptodate :

  • My database is distant from the apache servers thats hostes piwik : I checked apache can log to mysql (and by the way, the 5 sites don’ have problems to write on the same distant database)

ADDED later : I tested the MysqlServer : apache piwik doesn’t send the mysql request to the database, only for idsite=1.


(Pearltrees) #2

OK that was my fault : I didn’t update piwik.js since 200 days. I don’t have stats for the while but now requests go to mysql with idsite=1.

I close the ticket tomorrow if everything comes back normal !


(Pearltrees) #3

I updated piwik.js and the tracking javascript code.

To make my stats come back, I had to delete the april archives and reprocess it.

Now my idsite=1 visits are logged, but not the actions : there are only one or two or three actions per idvisit. All actions were sent by the visitors browsers.
Now I don’t know how to find why there is only one action per visit…

Please help !
Is there a way to come back to previous version (but I do not saved the database…)


(Pearltrees) #4

Actions are logged when reloading the flash website, but not when I click.

HTTP Requests are sent to piwik.php but don’t appear on the visit… I try to trace the code…

REFRESH : OK
?idsite=1&rec=1&url=http%3A%2F%2Fwww.pearltrees.com%2F%23N-f%3D1_53938%26N-p%3D4264054%26N-u%3D1_5419%26N-s%3D1_700051&res=1680x1050&h=1&m=56&s=41&cookie=1&urlref=&rand=0.5501372105870016&pdf=0&qt=0&realp=0&wma=0&dir=0&fla=1&java=0&gears=0&ag=0&action_name=pearltrees

Click : KO
?url=http%3A//www.pearltrees.com/%23N-f%3D1_53938%26N-p%3D4264054%26N-u%3D1_5419%26N-s%3D1_700051&action_name=pearltrees%20%20%3E%20uglycharly%20%3E%20Divertissements&idsite=1&title=pearltrees%20%20%3E%20uglycharly%20%3E%20Divertissements&urlref=http%3A//www.pearltrees.com/


(vipsoft) #5

It looks like you have your own click handler because your “click” URL doesn’t look like a request generated by piwik.js (e.g., trackLink() or trackPageView()).

In 0.5.5, we changed the protocol and require the “rec=1” parameter in requests. Just add that to your custom code.