Hi!
I have upgraded an older Piwik to 3.9.1 with QueuedTracking. Now I can see the old reports just nicely, only nothing new gets logged. I know that the tracking requests are hitting the site, because they arrive at my Redis server, but no matter whether I have turned QueuedTracking on or off, all visitor logs, page views etc. show a vaue of zero, or “no data for this report”. I have enabled query logging in my database server and see that when the records are being removed from the Redis, these database queries are being generated:
190420 12:34:27 1077 Connect matomo@localhost as anonymous on matomodb
1077 Query SET NAMES 'utf8'
1077 Query SET sql_mode = "NO_AUTO_VALUE_ON_ZERO"
1077 Query SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1
1077 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'usercountry.location_provider'
1077 Query SELECT `setting_name`, `setting_value`, `json_encoded` FROM matomo_plugin_setting WHERE plugin_name = 'QueuedTracking' and user_login = ''
190420 12:34:51 1078 Connect matomo@localhost as anonymous on matomodb
1078 Query SET NAMES 'utf8'
1078 Query START TRANSACTION
1078 Query SELECT * FROM matomo_site
WHERE idsite = '1'
1078 Query SELECT url FROM matomo_site_url
WHERE idsite = '1'
1078 Query SELECT * FROM matomo_site
WHERE idsite = '1'
1078 Query SELECT option_value, option_name FROM `matomo_option` WHERE autoload = 1
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_ExcludedIpsGlobal'
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_ExcludedQueryParameters'
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_ExcludedUserAgentsGlobal'
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_EnableSiteSpecificUserAgentExclude'
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_KeepURLFragmentsGlobal'
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_SearchKeywordParameters'
1078 Query SELECT option_value FROM `matomo_option` WHERE option_name = 'SitesManager_SearchCategoryParameters'
1078 Query SELECT * FROM matomo_goal
WHERE idsite IN (1)
AND deleted = 0
1078 Query SELECT login FROM matomo_access WHERE idsite = '1' AND access = 'admin'
1078 Query SELECT login FROM matomo_access WHERE idsite = '1' AND access = 'write'
1078 Query COMMIT
1078 Quit
I would actually expect an INSERT
statement somewhere in there. What do you suggest?