Please help me ! "Fatal error"


#1

Hello everybody !

I’m sorry for my bad english.

I need help because when I tried to consult a report I have this error :
“Fatal error: Maximum execution time of 30 seconds exceeded in /home/account/public_html/stats/core/DataTable/Filter/Truncate.php on line 36”

I tried to solve this by using auto archiving but still this error…

I never use this option, can you tell me how I can activate this for all my website since the beginning??

Please help me…

Thank you very much…


#2

Si il y a des utilisateurs français qui passent, pouvez-vous me dire comment archiver tous mes sites depuis le début?

Je n’ai jamais utilisé cette option et apparemment pour 3 de mes sites (il y en a 11) cela pose problème car il y a trop de données et je ne peux plus générer de rapport PDF (automatiquement ou manuellement).

Est-ce que quelqu’un peut m’aider?


#3

So I used http://website.com/misc/cron/archive.php?token_auth=XXXXXXX , and this is the result :

[2012-04-01 11:10:09] [5220fc98] [8.60 Mb] ---------------------------
[2012-04-01 11:10:09] [5220fc98] [8.60 Mb] INIT
[2012-04-01 11:10:09] [5220fc98] [8.60 Mb] Querying Piwik API at: http://website.com/misc/cron/../../index.php
[2012-04-01 11:10:09] [5220fc98] [8.60 Mb] Running as Super User: admin
[2012-04-01 11:10:10] [5220fc98] [8.75 Mb] Notes
[2012-04-01 11:10:10] [5220fc98] [8.75 Mb] - Reports for today will be processed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
[2012-04-01 11:10:10] [5220fc98] [8.75 Mb] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-04-01 11:10:10] [5220fc98] [8.76 Mb] --force-all-periods was detected: we will process websites with visits in the last 7 jours 0 heures
[2012-04-01 11:10:12] [5220fc98] [8.91 Mb] Will process 10 websites with new visits since 7 jours 0 heures , IDs: 1, 2, 3, 4, 5, 6, 7, 8, 10, 11
[2012-04-01 11:10:12] [5220fc98] [8.92 Mb] Will process 1 other websites because the last time they were archived was on a different day (in the website’s timezone) , IDs: 9
[2012-04-01 11:10:12] [5220fc98] [8.91 Mb] ---------------------------
[2012-04-01 11:10:12] [5220fc98] [8.91 Mb] START
[2012-04-01 11:10:12] [5220fc98] [8.91 Mb] Starting Piwik reports archiving…
[2012-04-01 11:10:13] [5220fc98] [8.93 Mb] Archived website id = 1, period = day, Time elapsed: 1.275s
[2012-04-01 11:10:17] [5220fc98] [8.95 Mb] Archived website id = 1, period = week, 117 visits, Time elapsed: 4.337s
[2012-04-01 11:10:18] [5220fc98] [8.95 Mb] Archived website id = 1, period = month, 117 visits, Time elapsed: 0.787s
[2012-04-01 11:10:19] [5220fc98] [8.94 Mb] Archived website id = 1, period = year, 117 visits, Time elapsed: 0.564s
[2012-04-01 11:10:19] [5220fc98] [8.93 Mb] Archived website id = 1, today = 1 visits, 4 API requests, Time elapsed: 6.964s [1/11 done]
[2012-04-01 11:10:19] [5220fc98] [8.93 Mb] Archived website id = 2, period = day, Time elapsed: 0.646s
[2012-04-01 11:10:27] [5220fc98] [8.95 Mb] Archived website id = 2, period = week, 728 visits, Time elapsed: 8.156s
[2012-04-01 11:10:28] [5220fc98] [8.95 Mb] Archived website id = 2, period = month, 728 visits, Time elapsed: 0.628s
[2012-04-01 11:10:29] [5220fc98] [8.94 Mb] Archived website id = 2, period = year, 728 visits, Time elapsed: 0.945s
[2012-04-01 11:10:29] [5220fc98] [8.93 Mb] Archived website id = 2, today = 7 visits, 4 API requests, Time elapsed: 10.375s [2/11 done]
[2012-04-01 11:10:30] [5220fc98] [8.93 Mb] Archived website id = 3, period = day, Time elapsed: 0.523s
[2012-04-01 11:10:30] [5220fc98] [8.95 Mb] Archived website id = 3, period = week, 2452 visits, Time elapsed: 0.900s
[2012-04-01 11:10:31] [5220fc98] [8.95 Mb] Archived website id = 3, period = month, 2452 visits, Time elapsed: 0.541s
[2012-04-01 11:10:32] [5220fc98] [8.94 Mb] Archived website id = 3, period = year, 2452 visits, Time elapsed: 0.843s
[2012-04-01 11:10:32] [5220fc98] [8.93 Mb] Archived website id = 3, today = 3 visits, 4 API requests, Time elapsed: 2.808s [3/11 done]
[2012-04-01 11:10:32] [5220fc98] [8.93 Mb] Archived website id = 4, period = day, Time elapsed: 0.366s
[2012-04-01 11:10:41] [5220fc98] [8.95 Mb] Archived website id = 4, period = week, 772 visits, Time elapsed: 9.185s
[2012-04-01 11:10:42] [5220fc98] [8.95 Mb] Archived website id = 4, period = month, 772 visits, Time elapsed: 0.441s
[2012-04-01 11:10:43] [5220fc98] [8.94 Mb] Archived website id = 4, period = year, 772 visits, Time elapsed: 0.697s
[2012-04-01 11:10:43] [5220fc98] [8.93 Mb] Archived website id = 4, today = 0 visits, 4 API requests, Time elapsed: 10.689s [4/11 done]
[2012-04-01 11:10:43] [5220fc98] [8.93 Mb] Archived website id = 5, period = day, Time elapsed: 0.322s
[2012-04-01 11:10:50] [5220fc98] [8.95 Mb] Archived website id = 5, period = week, 393 visits, Time elapsed: 7.495s
[2012-04-01 11:10:51] [5220fc98] [8.95 Mb] Archived website id = 5, period = month, 393 visits, Time elapsed: 1.130s
[2012-04-01 11:10:52] [5220fc98] [8.94 Mb] Archived website id = 5, period = year, 393 visits, Time elapsed: 0.646s
[2012-04-01 11:10:52] [5220fc98] [8.93 Mb] Archived website id = 5, today = 0 visits, 4 API requests, Time elapsed: 9.594s [5/11 done]
[2012-04-01 11:10:52] [5220fc98] [8.93 Mb] Archived website id = 6, period = day, Time elapsed: 0.394s
[2012-04-01 11:10:57] [5220fc98] [8.95 Mb] Archived website id = 6, period = week, 166 visits, Time elapsed: 4.647s
[2012-04-01 11:10:58] [5220fc98] [8.95 Mb] Archived website id = 6, period = month, 166 visits, Time elapsed: 0.589s
[2012-04-01 11:10:58] [5220fc98] [8.94 Mb] Archived website id = 6, period = year, 166 visits, Time elapsed: 0.684s
[2012-04-01 11:10:58] [5220fc98] [8.93 Mb] Archived website id = 6, today = 1 visits, 4 API requests, Time elapsed: 6.315s [6/11 done]
[2012-04-01 11:10:59] [5220fc98] [8.93 Mb] Archived website id = 7, period = day, Time elapsed: 0.451s
[2012-04-01 11:11:07] [5220fc98] [8.95 Mb] Archived website id = 7, period = week, 4688 visits, Time elapsed: 8.528s
[2012-04-01 11:11:08] [5220fc98] [8.95 Mb] Archived website id = 7, period = month, 4679 visits, Time elapsed: 0.640s
[2012-04-01 11:11:09] [5220fc98] [8.94 Mb] Archived website id = 7, period = year, 4679 visits, Time elapsed: 1.188s
[2012-04-01 11:11:09] [5220fc98] [8.93 Mb] Archived website id = 7, today = 3 visits, 4 API requests, Time elapsed: 10.807s [7/11 done]
[2012-04-01 11:11:10] [5220fc98] [8.93 Mb] Archived website id = 8, period = day, Time elapsed: 0.303s
[2012-04-01 11:11:17] [5220fc98] [8.96 Mb] Archived website id = 8, period = week, 476 visits, Time elapsed: 7.121s
[2012-04-01 11:11:17] [5220fc98] [8.95 Mb] Archived website id = 8, period = month, 476 visits, Time elapsed: 0.396s
[2012-04-01 11:11:17] [5220fc98] [8.94 Mb] Archived website id = 8, period = year, 476 visits, Time elapsed: 0.457s
[2012-04-01 11:11:17] [5220fc98] [8.93 Mb] Archived website id = 8, today = 0 visits, 4 API requests, Time elapsed: 8.277s [8/11 done]
[2012-04-01 11:11:18] [5220fc98] [8.93 Mb] Archived website id = 10, period = day, Time elapsed: 0.410s
[2012-04-01 11:11:29] [5220fc98] [8.96 Mb] Archived website id = 10, period = week, 3594 visits, Time elapsed: 11.037s
[2012-04-01 11:11:32] [5220fc98] [8.95 Mb] Archived website id = 10, period = month, 3594 visits, Time elapsed: 2.836s
[2012-04-01 11:11:33] [5220fc98] [8.94 Mb] Archived website id = 10, period = year, 3594 visits, Time elapsed: 1.588s
[2012-04-01 11:11:33] [5220fc98] [8.93 Mb] Archived website id = 10, today = 6 visits, 4 API requests, Time elapsed: 15.872s [9/11 done]
[2012-04-01 11:11:34] [5220fc98] [8.93 Mb] Archived website id = 11, period = day, Time elapsed: 0.301s
[2012-04-01 11:11:34] [5220fc98] [8.96 Mb] Archived website id = 11, period = week, 9156 visits, Time elapsed: 0.802s
[2012-04-01 11:11:38] [5220fc98] [8.95 Mb] Archived website id = 11, period = month, 9156 visits, Time elapsed: 3.287s
[2012-04-01 11:11:39] [5220fc98] [8.94 Mb] Archived website id = 11, period = year, 9156 visits, Time elapsed: 1.494s
[2012-04-01 11:11:39] [5220fc98] [8.93 Mb] Archived website id = 11, today = 36 visits, 4 API requests, Time elapsed: 5.885s [10/11 done]
[2012-04-01 11:11:40] [5220fc98] [8.93 Mb] Archived website id = 9, period = day, Time elapsed: 0.292s
[2012-04-01 11:11:41] [5220fc98] [8.95 Mb] Archived website id = 9, period = week, 10 visits, Time elapsed: 1.414s
[2012-04-01 11:11:41] [5220fc98] [8.95 Mb] Archived website id = 9, period = month, 10 visits, Time elapsed: 0.511s
[2012-04-01 11:11:42] [5220fc98] [8.94 Mb] Archived website id = 9, period = year, 10 visits, Time elapsed: 0.417s
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Archived website id = 9, today = 0 visits, 4 API requests, Time elapsed: 2.635s [11/11 done]
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Done archiving!
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] ---------------------------
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] SUMMARY
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Total daily visits archived: 57
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Archived today’s reports for 11 websites
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Archived week/month/year for 11 websites.
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Skipped 0 websites: no new visit since the last script execution
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Total API requests: 44
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] done: 11/11 100%, 57 v, 11 wtoday, 11 wperiods, 44 req, 90223 ms, no error
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Time elapsed: 90.223s
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] ---------------------------
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] SCHEDULED TASKS
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] Starting Scheduled tasks…
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] No task to run
[2012-04-01 11:11:42] [5220fc98] [8.93 Mb] done

But when I tried to generate a report for march fo website #11 (for exemple) I still have this error :

Fatal error: Maximum execution time of 30 seconds exceeded in /home/account/public_html/stats/core/DataTable/Manager.php on line 76

I don’t know what happen…

Can you help me please???


#4

Aucune idée sinon que tu devrais déjà sauvegarder les tables mysql quelque part puis les supprimer là où elle te gêne. C’est sans doute le plus simple.


#5

bah je vaux bien mais il y a des mois de données stockées :frowning:
je ne voudrais pas tout perdre…


#6

Another error :

what happen???

PLEASE HELP !!!


#7

je ne sais pas comment on sauvegarde un table mysql. Mais google le saura surement mieux que moi. Donc essayer de transférer quelque part tes données en sûreté puis n’utilise que les 3 dernières semaines pour réinstaller piwik avec. Mais google etc… toi même, je ne l’ai jamais fait.


#8

How can I be sure the cron job works fine for auto archiving??


(Matthieu Aubry) #9

How can I be sure the cron job works fine for auto archiving??

Output to a file using > /path/to/file.archive.log
And after 1 hour check that your hourly cron executed and output the archive.php in the file?


#10

It didn’t work, so I have do that on my job cron :
[attachment 568 cron.JPG]

">/dev/null 2>&1 " is for not send email at the end of cron job

Like that every 15mn stats are refresh.

But if cron job is every 15mn, I have to set on “General Settings” 15mn (900 seconds) too?

What is the difference between these two parameters?

Do you think with that all reports will be create with no fatal error?