Piwik doesn't work well ! Need HELP !:S


#1

Hello !

I had a big problem with reports (fatal error: 301 Moved Permanently).

I deleted all data (files, folder, database) and I installed again piwik.

I added 11 websites.

I configured auto archiving like you can see on screenshots :
[attachment 566 01b.JPG]
[attachment 564 02.JPG]

But when I visit “All Websites dashboard” all visits & pageviews still at 0 after 4, 5, 6 hours and more !!!

When I go on a website dashboard, I can see stats.

When I go on “Atlanta’s Affordable IT Solution | Atlanta IT Support | Millennium Solutions Inc”, script run and after on “All Websites dashboard” I can see stats.

But ONLY when I run script with “archive.php”

Please help me !!!

I really need help !!!


#2

Look at this :


Archiving was last executed without error 8 heures 18 min ago

So cron job doesn’t work, does it??

                                           
[2012-04-03 03:47:03] [634bf82a] [8.79 Mb] ---------------------------
[2012-04-03 03:47:03] [634bf82a] [8.79 Mb] INIT
[2012-04-03 03:47:03] [634bf82a] [8.79 Mb] Querying Piwik API at: http://stats.tdconcepts.net/misc/cron/../../index.php
[2012-04-03 03:47:03] [634bf82a] [8.79 Mb] Running as Super User: admin
[2012-04-03 03:47:03] [634bf82a] [8.94 Mb] Notes
[2012-04-03 03:47:03] [634bf82a] [8.94 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-03 03:47:03] [634bf82a] [8.94 Mb] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
[2012-04-03 03:47:03] [634bf82a] [8.94 Mb] - Archiving was last executed without error 8 heures 18 min ago
[2012-04-03 03:47:03] [634bf82a] [9.09 Mb] Will process 4 websites with new visits since 8 heures 18 min , IDs: 3, 7, 10, 11
[2012-04-03 03:47:03] [634bf82a] [9.09 Mb] Will process 7 other websites because the last time they were archived was on a different day (in the website's timezone) , IDs: 1, 2, 4, 5, 6, 8, 9
[2012-04-03 03:47:03] [634bf82a] [9.08 Mb] ---------------------------
[2012-04-03 03:47:03] [634bf82a] [9.08 Mb] START
[2012-04-03 03:47:03] [634bf82a] [9.08 Mb] Starting Piwik reports archiving...
[2012-04-03 03:47:03] [634bf82a] [9.08 Mb] Archived website id = 3, period = day, Time elapsed: 0.348s
[2012-04-03 03:47:04] [634bf82a] [9.09 Mb] Archived website id = 3, period = week, 5 visits, Time elapsed: 0.528s
[2012-04-03 03:47:04] [634bf82a] [9.09 Mb] Archived website id = 3, period = month, 5 visits, Time elapsed: 0.485s
[2012-04-03 03:47:05] [634bf82a] [9.09 Mb] Archived website id = 3, period = year, 5 visits, Time elapsed: 0.491s
[2012-04-03 03:47:05] [634bf82a] [9.08 Mb] Archived website id = 3, today = 0 visits, 4 API requests, Time elapsed: 1.853s [1/11 done]
[2012-04-03 03:47:05] [634bf82a] [9.08 Mb] Archived website id = 7, period = day, Time elapsed: 0.362s
[2012-04-03 03:47:06] [634bf82a] [9.09 Mb] Archived website id = 7, period = week, 12 visits, Time elapsed: 0.437s
[2012-04-03 03:47:06] [634bf82a] [9.09 Mb] Archived website id = 7, period = month, 12 visits, Time elapsed: 0.412s
[2012-04-03 03:47:06] [634bf82a] [9.09 Mb] Archived website id = 7, period = year, 12 visits, Time elapsed: 0.321s
[2012-04-03 03:47:06] [634bf82a] [9.08 Mb] Archived website id = 7, today = 2 visits, 4 API requests, Time elapsed: 1.533s [2/11 done]
[2012-04-03 03:47:07] [634bf82a] [9.08 Mb] Archived website id = 10, period = day, Time elapsed: 0.356s
[2012-04-03 03:47:07] [634bf82a] [9.09 Mb] Archived website id = 10, period = week, 9 visits, Time elapsed: 0.335s
[2012-04-03 03:47:08] [634bf82a] [9.09 Mb] Archived website id = 10, period = month, 9 visits, Time elapsed: 0.409s
[2012-04-03 03:47:08] [634bf82a] [9.09 Mb] Archived website id = 10, period = year, 9 visits, Time elapsed: 0.316s
[2012-04-03 03:47:08] [634bf82a] [9.08 Mb] Archived website id = 10, today = 3 visits, 4 API requests, Time elapsed: 1.417s [3/11 done]
[2012-04-03 03:47:08] [634bf82a] [9.08 Mb] Archived website id = 11, period = day, Time elapsed: 0.271s
[2012-04-03 03:47:08] [634bf82a] [9.09 Mb] Archived website id = 11, period = week, 75 visits, Time elapsed: 0.292s
[2012-04-03 03:47:09] [634bf82a] [9.09 Mb] Archived website id = 11, period = month, 75 visits, Time elapsed: 0.485s
[2012-04-03 03:47:09] [634bf82a] [9.09 Mb] Archived website id = 11, period = year, 75 visits, Time elapsed: 0.251s
[2012-04-03 03:47:09] [634bf82a] [9.08 Mb] Archived website id = 11, today = 3 visits, 4 API requests, Time elapsed: 1.300s [4/11 done]
[2012-04-03 03:47:10] [634bf82a] [9.08 Mb] Archived website id = 1, period = day, Time elapsed: 0.347s
[2012-04-03 03:47:10] [634bf82a] [9.09 Mb] Archived website id = 1, period = week, 1 visits, Time elapsed: 0.239s
[2012-04-03 03:47:10] [634bf82a] [9.09 Mb] Archived website id = 1, period = month, 1 visits, Time elapsed: 0.326s
[2012-04-03 03:47:12] [634bf82a] [9.09 Mb] Archived website id = 1, period = year, 1 visits, Time elapsed: 1.528s
[2012-04-03 03:47:12] [634bf82a] [9.08 Mb] Archived website id = 1, today = 0 visits, 4 API requests, Time elapsed: 2.441s [5/11 done]
[2012-04-03 03:47:12] [634bf82a] [9.09 Mb] Archived website id = 2, period = day, Time elapsed: 0.160s
[2012-04-03 03:47:12] [634bf82a] [9.09 Mb] Archived website id = 2, period = week, 1 visits, Time elapsed: 0.359s
[2012-04-03 03:47:12] [634bf82a] [9.09 Mb] Archived website id = 2, period = month, 1 visits, Time elapsed: 0.311s
[2012-04-03 03:47:13] [634bf82a] [9.09 Mb] Archived website id = 2, period = year, 1 visits, Time elapsed: 0.362s
[2012-04-03 03:47:13] [634bf82a] [9.08 Mb] Archived website id = 2, today = 0 visits, 4 API requests, Time elapsed: 1.197s [6/11 done]
[2012-04-03 03:47:13] [634bf82a] [9.09 Mb] Archived website id = 4, period = day, Time elapsed: 0.337s
[2012-04-03 03:47:14] [634bf82a] [9.09 Mb] Archived website id = 4, period = week, 4 visits, Time elapsed: 0.345s
[2012-04-03 03:47:14] [634bf82a] [9.09 Mb] Archived website id = 4, period = month, 4 visits, Time elapsed: 0.405s
[2012-04-03 03:47:14] [634bf82a] [9.09 Mb] Archived website id = 4, period = year, 4 visits, Time elapsed: 0.373s
[2012-04-03 03:47:14] [634bf82a] [9.08 Mb] Archived website id = 4, today = 0 visits, 4 API requests, Time elapsed: 1.460s [7/11 done]
[2012-04-03 03:47:14] [634bf82a] [9.09 Mb] Archived website id = 5, period = day, Time elapsed: 0.144s
[2012-04-03 03:47:15] [634bf82a] [9.09 Mb] Archived website id = 5, period = week, 0 visits, Time elapsed: 0.192s
[2012-04-03 03:47:15] [634bf82a] [9.09 Mb] Archived website id = 5, period = month, 0 visits, Time elapsed: 0.246s
[2012-04-03 03:47:15] [634bf82a] [9.09 Mb] Archived website id = 5, period = year, 0 visits, Time elapsed: 0.195s
[2012-04-03 03:47:15] [634bf82a] [9.09 Mb] Archived website id = 5, today = 0 visits, 4 API requests, Time elapsed: 0.778s [8/11 done]
[2012-04-03 03:47:15] [634bf82a] [9.09 Mb] Archived website id = 6, period = day, Time elapsed: 0.147s
[2012-04-03 03:47:15] [634bf82a] [9.10 Mb] Archived website id = 6, period = week, 0 visits, Time elapsed: 0.212s
[2012-04-03 03:47:16] [634bf82a] [9.09 Mb] Archived website id = 6, period = month, 0 visits, Time elapsed: 0.202s
[2012-04-03 03:47:16] [634bf82a] [9.09 Mb] Archived website id = 6, period = year, 0 visits, Time elapsed: 0.203s
[2012-04-03 03:47:16] [634bf82a] [9.09 Mb] Archived website id = 6, today = 0 visits, 4 API requests, Time elapsed: 0.765s [9/11 done]
[2012-04-03 03:47:16] [634bf82a] [9.09 Mb] Archived website id = 8, period = day, Time elapsed: 0.329s
[2012-04-03 03:47:17] [634bf82a] [9.10 Mb] Archived website id = 8, period = week, 2 visits, Time elapsed: 0.423s
[2012-04-03 03:47:17] [634bf82a] [9.09 Mb] Archived website id = 8, period = month, 2 visits, Time elapsed: 0.441s
[2012-04-03 03:47:17] [634bf82a] [9.09 Mb] Archived website id = 8, period = year, 2 visits, Time elapsed: 0.366s
[2012-04-03 03:47:17] [634bf82a] [9.09 Mb] Archived website id = 8, today = 0 visits, 4 API requests, Time elapsed: 1.560s [10/11 done]
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Archived website id = 9, period = day, Time elapsed: 0.222s
[2012-04-03 03:47:18] [634bf82a] [9.10 Mb] Archived website id = 9, period = week, 0 visits, Time elapsed: 0.214s
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Archived website id = 9, period = month, 0 visits, Time elapsed: 0.195s
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Archived website id = 9, period = year, 0 visits, Time elapsed: 0.223s
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Archived website id = 9, today = 0 visits, 4 API requests, Time elapsed: 0.855s [11/11 done]
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Done archiving!
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] ---------------------------
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] SUMMARY
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Total daily visits archived: 8
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Archived today's reports for 11 websites
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Archived week/month/year for 11 websites.
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Skipped 0 websites: no new visit since the last script execution
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Total API requests: 44
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] done: 11/11 100%, 8 v, 11 wtoday, 11 wperiods, 44 req, 15160 ms, no error
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Time elapsed: 15.161s
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] ---------------------------
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] SCHEDULED TASKS
[2012-04-03 03:47:18] [634bf82a] [9.09 Mb] Starting Scheduled tasks...
[2012-04-03 03:47:19] [634bf82a] [9.09 Mb] task,output Piwik_CoreAdminHome.optimizeArchiveTable,Time elapsed: 0.053s Piwik_PDFReports.dailySchedule,Time elapsed: 0.037s Piwik_PrivacyManager.deleteLogTables,Time elapsed: 0.000s
[2012-04-03 03:47:19] [634bf82a] [9.09 Mb] done


(Matthieu Aubry) #3

Enable “browser trigger archiving” in Settings > General settings


#4

In general settings I have set “no” and 900 seconds.

I have create a cron job like that :
[attachment 569 cron.JPG]

It seems to work… But I’m not sure…

My english is bad, and I don’t know if someone who speak french can help me here…

I have 2 or 3 “big websites” wich have problems with PDF reports ( for a week or a month).

I just want it work again because with piwik 1.6 there wasn’t any problem…

What is the best configuration?

I’m ready to give you access on my piwik to set the best configuration if you want…


(Matthieu Aubry) #5

Use latest piwik RC: Index of /

then you can disable all graphs in all pdf reports, please try this option


#6

With 1.7.1 I use default setting for that so, there is no graphics, isn’t it?

Does last piwik RC stable?