Piwik crashes when pulling traffic for month in "All Websites" area


#1

We have a Piwik install that tracks over 1,000 websites. In the “All Websites” area, although I can view data for the default (today, 1 day) just fine, if I opt to see data for the month or for a date range, it crashes with a 500 internal server error after spending quite some time processing.

Using Piwik 2.0-b12.

Things I have tried so far:
-Currently running archive.php as a cron job
-In the general settings area, I have “Allow Piwik archiving to trigger when reports are viewed from the browser” turned off
-Reports for today process every 600 seconds

I need to be able to view data for the whole month or a date range in the All Websites area, or at least through a report of some sort, without Piwik crashing. Any suggestions? Thanks in advance!


(Matthieu Aubry) #2

It works for us… use latest Piwik


#3

When I try to check for updates, Piwik informs me that I am using the latest version. I have tried specifying to check for the latest stable version and then again to check for the latest beta version. Piwik informs me that I am using the latest version either way.

We’re running PHP 5.4.24, MySQL 5.1.72.


(Matthieu Aubry) #4

Latest piwik is 2.0.3


#5

Why do you think our install of Piwik fails to recognize it? How can we install it otherwise?


#6

are you using any cacheing mechanism that might be causing piwik this issue?


(Matthieu Aubry) #7

Maybe because you are using PHP less than 5.3.2
please upgrade php and then you should see the update?


#8

Please see above…PHP is updated:

"When I try to check for updates, Piwik informs me that I am using the latest version. I have tried specifying to check for the latest stable version and then again to check for the latest beta version. Piwik informs me that I am using the latest version either way.

We’re running PHP 5.4.24, MySQL 5.1.72."

Upgraded to PHP 5.4.24. The problem unfortunately still persists.


#9

what are the memory settings for php.ini? maybe up the if around 128 or 256?


#10

I think we just figured it out–our firewall was blocking the country where the update comes from, so the connection was never being made :stuck_out_tongue:


#11

Still crashes after update though :stuck_out_tongue:


#12

did you try to delete the tmp folders contnets? any apache server error logs


(Matthieu Aubry) #13

what crash?


#14

This one (from OP):

lesjokolat: I haven’t tried deleting the tmp folders. So that I know what to try and delete, is it safe to delete everything in /path/to/piwik-installation/tmp/ ?


#15

others have done it and it helps more often than not.ma y have to rejig some dashboards settings


#16

Just so I understand completely before I do this, is it safe to delete everything in /path/to/piwik-installation/tmp/ ?


#17

others have done it and it helps more often than not.may have to rejig some dashboards settings

I cannot 100% guantee there may be some unforsen side effect but in all the cases I have seen refenced here it solved problems. There were some instance where a dashboard need to be recreated or a widget needed to be deleted then readded. I never recall it killed data…


(Matthieu Aubry) #18

Removing the tmp/ folder is safe, as it will be re-created


#19

Thank you to both of you! I went ahead & deleted the tmp folder.

However, unfortunately the problem still persists :frowning:

I can pull month stats, but can’t pull them for a date range–Piwik crashes here with a fatal error (maximum execution time exceeded).


#20

there is a setting to fix that error do a search on it and that error will be fixed.