Can't see totals for week, month or year

Support & Bugs
41

I take a look into ArchiveProcessing.php and find interestion function

/**
 * Returns the idArchive if the archive is available in the database.
 * Returns false if the archive needs to be computed.
 * 
 * An archive is available if
 * - for today, the archive was computed less than minDatetimeArchiveProcessedUTC seconds ago
 * - for any other day, if the archive was computed once this day was finished
 * - for other periods, if the archive was computed once the period was finished
 *
 * @return int|false
 */
protected function isArchived()

So if i understand it logics it only allow update if archive is past defined perion. I mean if it today it works fine, but if u wanna get week or year stat u must wait until this year ends… But actualy all stats needs also to be generated when day stats regen, or it just not show right stats, but genaration a stat for whole yr can take a lotta of time and can eat up server processor and time…

May be i am wrong, but it only problem i can see now…

42

[quote=Sky Ranger @ Nov 25 2010, 04:09 AM]I make TRUNCATE for

piwik_archive_blob_2010_01
piwik_archive_blob_2010_11
piwik_archive_numeric_2010_01
piwik_archive_numeric_2010_11

And it helps when i manual run regen archive, but next time it again only updates for a day[/quote]

Same for me after dropping that tables (since I later installed GeoIP) the data was correct.

Later on it again got wrong but I can not tell if it was because of me getting back to the old unpatched version or by itself (can not exactly remember when I put them back).

What I was amazed of:

I had the same tables but after dropping them the tables ending “_01” were not generated again. Only the “_11” ones. If I assume right the 01 should be for January? But why were they created at all? I never used piwik before this month!

@SkyRanger:
Sounds as it could be the problem to me.

43

[quote=Gorkde @ Nov 25 2010, 08:41 AM]What I was amazed of:

I had the same tables but after dropping them the tables ending “_01” were not generated again. Only the “_11” ones. If I assume right the 01 should be for January? But why were they created at all? I never used piwik before this month!

@SkyRanger:
Sounds as it could be the problem to me.[/quote]

Well, here part of my piwik_archive_numeric_2010_01:


1 	done 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	3
1 	max_actions 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	121
1 	nb_uniq_visitors 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	129
1 	nb_visits 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	158
1 	nb_actions 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	534
1 	sum_visit_length 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	39110
1 	bounce_count 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	46
1 	Referers_distinctWebsites 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	9
1 	Referers_distinctWebsitesUrls 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	12
1 	UserCountry_distinctCountries 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	1
1 	nb_visits_returning 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	29
1 	nb_actions_returning 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	85
1 	sum_visit_length_returning 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	6450
1 	bounce_count_returning 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	10
1 	max_actions_returning 	1 	2010-01-01 	2010-12-31 	4 	2010-11-25 05:06:16 	15

i just copy it from phpmyadmin

As u can see all dates for Year begins with 2010-01-01 and ends 2010-12-31
So if i understand archive script logics it only work when:
a) There no stat in files at all
b)There time range (2010-01-01 to 2010-12-31) passed, so why it not work as we expected style_emoticons/<#EMO_DIR#>/sad.gif
Well i may be wrong style_emoticons/<#EMO_DIR#>/smile.gif

44

I replaced my ArchiveProcessing.php and it seemed to work. I can see week, month and year totals after the time when previouisly they wouldn’t show.

I haven’t checked to see if stats are showing within day yet eg if the 24 hour time period is not shifted any longer.

But for now, looks like you have made good!

Thanks a bundle. Now I am much happier with Piwik.!

[quote=vipsoft @ Nov 21 2010, 10:57 AM]The archiving + timezone issue is fixed in the upcoming 1.1 release. If you can’t wait, try updating this file:

dev.piwik.org/trac/export/3246/trun…eProcessing.php

William Fay: you may have a different problem. Can you check your web server logs? Sounds like you need to increase max memory limit in php.ini.[/quote]

45

Hmm i noticed that my daily stats are do not show accurately.

When I group stats by day, for example, my Dec 8 daily stats showed only Dec 7 stats. When i look at visitor log it shows only Dec 7 stats

My weekly/monthly/yearly grouping shows the Dec 8 visits though. I compared against Site Meter stats and they match up.

It appears that daily stats are out by an entire day (24 hours) plus about 7 hours (which is my UTC -7). I am ball parking this as I can’t pinpoint when stats cut off eg my visits are few and far btwn in this period.

Anyways, something is up with daily stats so there is still a bit more work to do! But almost there!

46

Yeah, that can make quite a difference, but how much of a time span are we talking about total for the different time zones? 24 hours? 36?

47

Hello,

We tried to fix this issue in Piwik. We released a 1.1 beta 3 (which will become 1.1 if nothing comes up), and we would really appreciate if you could install it and report if the bug above is still there with this new version.

If you still experience an issue with 1.1b3 version, please create a new forum topic explaining your setup (websites, timezones), what you see and what you expected to see.

To install 1.1b3, it is the same process as a normal upgrade:

Thank you for your help!

48

Ok, installed 1.1 beta 3 and will report on new thread 301 Moved Permanently explaining setup (websites, timezones), what i see and what i expected to see. thanks!

49

Applied the beta this morning and it works fine as far as I can see. Thanks:)-D

50

It works fine for me too thanks :slight_smile:

51

Thanks, now we released the 1.1 beta 4: please read about it in this post: 301 Moved Permanently

52

It’s definitely 24 different zones.

53

See our new page, which lists the various limits on historical data, number of websites, users, database size, when using Piwik: Data Limits Analytics