Day stats lost!


(apedic) #1

hi, i’ve a problem for a day statistic as piwik reports 0 on every section, but i’ve checked the db and the data are correctly recorded. In fact if I do this query

SELECT *
FROM piwik_log_visit
WHERE idsite =2
AND visit_server_date = '2010-07-05’
LIMIT 0 , 30

I can see 2665 records!

what can I do to visualize them in piwik? Please note that before the new day began I was able to see all statistic correctly


(Matthieu Aubry) #2

try to delete all piwik_archive tables and try again


(apedic) #3

it has worked…thank you very much!