Visitors in Real-time stopped working after update to 3.0

Is anyone having an issue with the mobile app? The web version seems fine (as far as I can see) but the mobile app says “No Visitors” in the ‘Visitors in real-time’ section.

After Upgrade to v3.0.0, Piwik stops the tracking. The Real-Time Visitor Site also display nothing.

My solution:
Deactivate the Core Plugin “UserCountry”.

After that, the Tracking in Piwik 3.0.0 is working and I also get the data display at the Real-Time Visitor Site.

Seems to create more issues:

Error: Plugin UserCountry required

And the Real Time map disappearing…

I might found the issue:

Mysqli prepare error: Unknown column ‘log_link_visit_action.interaction_position’ in ‘field list’

It seems to be working for me after 1 day post install of 3.0.
Maybe it does have something to do with the date.

Hi guys,

If you experience problem with Piwik 3.0.0 after 1 day and not seeing data, please create a bug report in our tracker: Issues · piwik/piwik · GitHub and we will try to assist.

1 Like

To anyone else who is experiencing this issue and if it seemed to resolve itself, watch during the last hour before it rolls over to the next day 23:00 - 23:59 (11PM - 11:59PM) for the timezone set on the site you are checking. Does the list of recent visitors disappear during that time-frame and then start fresh once it is a new day? That is what I am seeing, and there are no error messages.

UPDATE: It is not 23:00 yet and I am seeing the error again. List of Visitors in Real-time as disappeared for all sites and clicking on View detailed visitor log link does not show any results, even though piwik is continuing to track visitors.

The live update has stopped working once again today. This is after it was working most of the day.
I think the stoppage is coinciding with the hour Piwik 3.0 was first installed for us.

Hi rabo. I just updated the post above. Now seeing the error on a different hour. It does seem to be time related, but does not correspond with installation time.

Same here.

It seems like all ‘live’ events are trying to be recorded in UTC, no matter what time you have set for each site.

So for me for example, on Eastern Standard Time (-5 UTC), ‘live’ events are trying to be stored 5 hours ahead of me. Thus right now:

EST: 8:20PM, 20th Dec 2016, but Piwik is attempting to store all ‘live’ events: 1:20am on 21st Dec 2016. It can’t record the live events, because 21st Dec doesn’t exist in my timezone. Once 21st Dec exists in my timezone it works fine, but the same thing occurs at 7pm because then 22nd Dec won’t exist in my timezone.

It I set each website to UTC, live events work fine (aside from they’re obviously not the timezone of the site and server, nor my timezone).

Problem fixed.
The database was 7GB in size, innodb has the thing that it copies the table, and then on-the-fly alters the table.
Let my HDD size to be smaller then needed, so I fixed a partition of 100GB to handle MySQL data, and the upgrade run fine after.

Perhaps other people have the same issue.

So is the fix something that we need to do or in a up coming Piwik update?

@rabo. I think Power2All was having a different issue.

Upgraded to 3.0 a few days ago and this was working, however I went and changed the website that loads by default via Administration > Personal > Settings > Report To Load By Default.

I switched the setting, then reloaded Piwik and the widget for “Visitors In Real Time” does not show any data. I switched it back to the site it was previously, no data.

Further, the I click on “View Detailed Visitor Log” I get 0 results. However, when I change the day to yesterday, then I get results. Switching the day back to today on the Detailed Visitor Log shows me today’s visitors.

Wanted to mention my experience with this issue

1 Like

Has anyone created an issue for this?

It’s sad to see the problem still persists in the new 3.0.1

Make sure to create an issue in the tracker: Issues · piwik/piwik · GitHub as we do not use forums to track bugs

Thanks Matthieu. Been out of town for longer than expected, super busy, just got back. I will figure out the process for submitting a bug to the tracker and try to do that soon, unless somebody else who is familiar with the process is going to or has already done so.

the bug was reported here: Visitors in real time data gone after 4PM Piwik 3.0 · Issue #11165 · matomo-org/piwik · GitHub

This issue appears to be fixed as of 3.0.2 update.