No Tracking in Dashboard but No Errors - Fresh install 2.1


#1

Yesterday, I installed a fresh copy of Piwik 2.1 on my server. I created a new site in Piwik and embeded the tracking code in the footer of the site. When I go to the site and view the request to my Piwik server in chrome developer tools the server returns a 200 response indicating that it was successful. Everything appears to be setup properly but Piwik isn’t showing any visits in the Dashboard.

I’ve also setup a cron job to handle the archiving and when I view the /tmp folder there are sessions being created however none of the logs are being transferred to the DB. In addition, Under Settings -> System Check, I see all green arrows. There are no errors being reported in my server error log.

I’m getting super frustrated and can’t figure out what I’m doing wrong. I would greatly appreciate any help on the matter. Below I’ve included a the response being returned by Piwik as well as a link to my site. I’m running Ubuntu 12.04 LTS, Apache 2.4.7, PHP 5.5.9, and MySQL 5.5.35.

http://piwik.furbosoft.com/piwik.php?action_name=Who%20am%20I%20-%20Benny%20V.%20Bonora&idsite=1&rec=1&r=318329&h=15&m=11&s=20&url=http%3A%2F%2Fwww.bennyvbonora.com%2F&_id=b73a37cf705da6d5&_idts=1395349104&_idvc=4&_idn=0&_refts=0&_viewts=1395436571&pdf=1&qt=0&realp=0&wma=0&dir=0&fla=1&java=1&gears=0&ag=1&cookie=1&res=1440x900&gt_ms=290

bennyvbonora.com


#2

I’m also getting this error in my cron job - Mysqli prepare error: Unknown column ‘log_visit.location_provider’ in 'field list


(Matthieu Aubry) #3

Thanks for the report. I created ticket also tried to fix: Fixes #4886 · matomo-org/matomo@54a3399 · GitHub

can you apply patch (or replace these two files) and does it fix the issue?


#4

Thanks Man! That seemed to work for the stats but now the geo location stuff isn’t working. I’ve tried all the options but settled on PECL. Do I need to add a link to a geo DB? If so is this something needs to be uploaded to the server or can it be a URL? Is there an example of a typical setup?


(Matthieu Aubry) #5

see Geo Locate your visitors - Analytics Platform - Matomo