Hi vipsoft,
thanks for your support1
[quote=vipsoft @ Jun 15 2009, 09:56 PM) <{POST_SNAPBACK}>
The absence of errors is perplexing.
Yes, that’s really annoying since I can’t find any obvious problems…
QUOTE (vipsoft @ Jun 15 2009, 09:56 PM) [<{POST_SNAPBACK}>](index.php?act=findpost&pid=2866)
Can you query your archive tables and see if it's still archiving all periods?
The results of your query are:
SELECT COUNT(period) FROM piwik_archive_blob_2009_06 WHERE period=1
union
SELECT COUNT(period) FROM piwik_archive_blob_2009_06 WHERE period=2
union
SELECT COUNT(period) FROM piwik_archive_blob_2009_06 WHERE period=3;
COUNT(period)
3462
541
176
SELECT COUNT(period) FROM piwik_archive_numeric_2009_06 WHERE period=1
union
SELECT COUNT(period) FROM piwik_archive_numeric_2009_06 WHERE period=2
union
SELECT COUNT(period) FROM piwik_archive_numeric_2009_06 WHERE period=3;
COUNT(period)
1719
140
20
Looks like piwik is fetching data…
QUOTE (vipsoft @ Jun 15 2009, 09:56 PM) [<{POST_SNAPBACK}>](index.php?act=findpost&pid=2866)
If there aren't any 2's and 3's, it isn't archiving. Something in log_visits?
Querying the log_visit table with the following query gives me results for every single day since installing piwik:
SELECT visit_server_date, count(*) FROM `piwik_log_visit` group by visit_server_date
QUOTE (vipsoft @ Jun 15 2009, 09:56 PM]From your Dashboard, click on the API link (near the top left). Go to VisitsSummary.get and select a format (e.g., XML). Edit the URL in your address bar, changing the site ID, period, date range, and token_auth, as needed.[/quote]
I tried various dates but the result is the same in every situation: As soon as I query weekly/monthly results there is no data returned.
For example:
Daily query.
http://host/index.php?module=API&method=VisitsSummary.get&idSite=1&period=day&date=2009-06-01&format=xml&token_auth=anonymous
<result>
<max_actions>15</max_actions>
<nb_uniq_visitors>14</nb_uniq_visitors>
<nb_visits>16</nb_visits>
<nb_actions>58</nb_actions>
<sum_visit_length>3513</sum_visit_length>
<bounce_count>6</bounce_count>
<nb_visits_converted>0</nb_visits_converted>
</result>
and
Weekly query:
http://host/index.php?module=API&method=VisitsSummary.get&idSite=1&period=week&date=2009-06-01&format=xml&token_auth=anonymous
<result>
<max_actions>0</max_actions>
<nb_uniq_visitors>0</nb_uniq_visitors>
<nb_visits>0</nb_visits>
<nb_actions>0</nb_actions>
<sum_visit_length>0</sum_visit_length>
<bounce_count>0</bounce_count>
<nb_visits_converted>0</nb_visits_converted>
</result>
Strange side effect: Querying VisitsSummary.get crashes my Firefox after fiddling with the parameters (nearly 100% CPU time).
Anything else I could do to help to nartrow down the possible problems?
CU
maxh