Bug: No Tracking At All


(T.) #1

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?


(T.) #2

Problem solved - for some reason, I had overlooked my browser sending DNT=1 to the server. =8-((