Piwik completely stopped collecting data after upgrading PHP


#1

We recently upgraded PHP from 5.2 to 5.4.24. Upon updating, we’ve had an issue which makes it appear that no visits are bring tracked. HOWEVER, it also appears that visitors are being accounted for somehow: They DO show up in the real-time stats. They just don’t show up in the “Visits Over Time” area on the dashboard.

What I’ve tried so far:
-Deleting contents of the tmp folder
-Upgrading Piwik from 2.0-b12 to 2.0.3 stable

Does anyone have any suggestions that could help remedy the situation we’re experiencing? Thanks in advance!


#2

try the 2.1 rc


#3

Update: I figured out what the problem was…the cron I had that was running archive.php wasn’t doing anything anymore. The cron itself is working fine–the FILE, however, gives me a 403 error if I try to access it from a browser. I temporarily turned archiving on for browser views, and the data appeared in the visits graph.

I suppose the question now would be how to get that cron running again, when accessing the file results in a 403? Ownership and permissions are same as ever before. Files are all 644, same as before.


#4

https://support.hostgator.com/articles/403-forbidden-or-no-permission-to-access

might be it has to be 755 see this support link not sure you use them but im guessing similar issue


#5

Good call on the permissions. I’m thinking it’s an Apache thing, though…if I remove the .htaccess in the /misc directory, the file is reachable. Reading around, it looks like in Apache 2.4 I might need to tweak it, so I’m going to play around with that for a while…


http://httpd.apache.org/docs/2.4/new_features_2_4.html


#6

could you not in the htaccess just assign a file permission to that one file?


#7

Good idea. I think there might be something else at work, though. I checked back on a manually accessed archive.php after disabling the .htaccess temporarily and saw this error message:

ERROR: The Piwik URL http://www.website.com/piwik/misc/cron/../../index.php does not seem to be pointing to a Piwik server. Response was ‘X-Powered-By: PHP/5.4.24Content-type: text/html

INFO [2014-02-13 21:05:46] [32a1d] ---------------------------
INFO [2014-02-13 21:05:46] [32a1d] INIT
INFO [2014-02-13 21:05:46] [32a1d] Querying Piwik API at: http://www.website.com/piwik/misc/cron/../../index.php
INFO [2014-02-13 21:05:46] [32a1d] Running Piwik 2.1-rc1 as Super User: admin
’.

I tried http://www.website.com/piwik/misc/cron/../../index.php in the browser, and it indeed is the correct URL for the Piwik install, so I’m unsure how to interpret the error message above. Thoughts?

Edit: At this point, we HAVE upgraded to 2.1 RC as suggested


#8

there must be host resolving issue.the www.host.com/piwik/misc/cron/etc is actually /var/www/vhosts/host/piwik/misc/cron/etc


#9

Very well could be…but http://www.website.com/piwik/misc/cron/../../index.php does resolve correctly when accessed manually in a web browser. How to fix this on the Piwik install?


(Matthieu Aubry) #10

If you are using the 2.1 RC then apply this patch which should fix it Fixes #4673 In case the PHP binary used is php-cgi instead of PHP cli… · matomo-org/matomo@c1db893 · GitHub