MediaAnalytics error message

John_Keegan · December 8, 2022, 11:13pm

Hello ,

We’re on the latest version of Matomo as of this morning and we’re seeing these in the logs of the report processors:

INFO [2022-12-08 23:08:51] 8304 Error: Got invalid response from API request: ?module=API&method=CoreAdminHome.archiveReports&idSite=13&period=year&date=2022-01-01&format=json&trigger=archivephp. Response was '{“result”:“error”,“message”:"SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens - in plugin MediaAnalytics.

Is this a bug in the MediaAnalytics plugin? How would we as admins ensure that the “number of bound variables” matches the number of tokens?

djmetzle · December 19, 2022, 9:07pm

We are also experiencing this problem.

Version 4.12.3.

If it is helpful, we are using the QueuedTracking plugin, but have an otherwise plain setup. There have been other recent problems with that specific plugin.

Here is a stack trace:

ERROR API[2022-12-19 20:49:27 UTC] [98] caused by: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens                                                                                                                                     
ERROR API[2022-12-19 20:49:27 UTC] [98] #0 /var/www/html/libs/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)                                                                                                                                                            
ERROR API[2022-12-19 20:49:27 UTC] [98] #1 /var/www/html/libs/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)                                                                                                                                                          
ERROR API[2022-12-19 20:49:27 UTC] [98] #2 /var/www/html/libs/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT  /*+ MAX...', Array)                                                                                                                           
ERROR API[2022-12-19 20:49:27 UTC] [98] #3 /var/www/html/core/Db/Adapter/Pdo/Mysql.php(314): Zend_Db_Adapter_Pdo_Abstract->query('SELECT  /*+ MAX...', Array)                                                                                                                               
ERROR API[2022-12-19 20:49:27 UTC] [98] #4 [internal function]: Piwik\Db\Adapter\Pdo\Mysql->query('SELECT  /*+ MAX...', Array)                                                                                                                                                              
ERROR API[2022-12-19 20:49:27 UTC] [98] #5 /var/www/html/core/DataAccess/ArchivingDbAdapter.php(121): call_user_func_array(Array, Array)                                                                                                                                                    
ERROR API[2022-12-19 20:49:27 UTC] [98] #6 [internal function]: Piwik\DataAccess\ArchivingDbAdapter->callFunction('query', 'SELECT  /*+ MAX...', Array)                                                                                                                                     
ERROR API[2022-12-19 20:49:27 UTC] [98] #7 /var/www/html/core/DataAccess/ArchivingDbAdapter.php(60): call_user_func_array(Array, Array)                                                                                                                                                     
ERROR API[2022-12-19 20:49:27 UTC] [98] #8 /var/www/html/plugins/MediaAnalytics/Archiver.php(798): Piwik\DataAccess\ArchivingDbAdapter->query('SELECT  /*+ MAX...', Array)                                                                                                                  
ERROR API[2022-12-19 20:49:27 UTC] [98] #9 /var/www/html/plugins/MediaAnalytics/Archiver.php(370): Piwik\Plugins\MediaAnalytics\Archiver->query('log_media.resou...', ' AND log_media....', 'log_media.resou...', 'nb_plays DESC', Array, Object(Piwik\RankingQuery))                       
ERROR API[2022-12-19 20:49:27 UTC] [98] #10 /var/www/html/plugins/MediaAnalytics/Archiver.php(301): Piwik\Plugins\MediaAnalytics\Archiver->archiveSecondaryDimensionSpentTime(Array, Array, 'log_media.resou...')                                                                           
ERROR API[2022-12-19 20:49:27 UTC] [98] #11 /var/www/html/plugins/MediaAnalytics/Archiver.php(142): Piwik\Plugins\MediaAnalytics\Archiver->makeRegularReport(Array, ' AND log_media....', 'log_media.resou...', true)                                                                       
ERROR API[2022-12-19 20:49:27 UTC] [98] #12 /var/www/html/core/Plugin/Archiver.php(89): Piwik\Plugins\MediaAnalytics\Archiver->aggregateDayReport()                                                                                                                                         
ERROR API[2022-12-19 20:49:27 UTC] [98] #13 /var/www/html/core/ArchiveProcessor/PluginsArchiver.php(164): Piwik\Plugin\Archiver->callAggregateDayReport()                                                                                                                                   
ERROR API[2022-12-19 20:49:27 UTC] [98] #14 /var/www/html/core/ArchiveProcessor/Loader.php(284): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins('212398', '2155', false)                                                                                                   
ERROR API[2022-12-19 20:49:27 UTC] [98] #15 /var/www/html/core/ArchiveProcessor/Loader.php(176): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive('212398', '2155')                                                                                                                  
ERROR API[2022-12-19 20:49:27 UTC] [98] #16 /var/www/html/core/ArchiveProcessor/Loader.php(159): Piwik\ArchiveProcessor\Loader->insertArchiveData('212398', '2155')                                                                                                                         
ERROR API[2022-12-19 20:49:27 UTC] [98] #17 /var/www/html/core/ArchiveProcessor/Loader.php(99): Piwik\ArchiveProcessor\Loader->prepareArchiveImpl(false)                                                                                                                                    
ERROR API[2022-12-19 20:49:27 UTC] [98] #18 /var/www/html/core/Context.php(75): Piwik\ArchiveProcessor\Loader->Piwik\ArchiveProcessor\{closure}()                                                                                                                                           
ERROR API[2022-12-19 20:49:27 UTC] [98] #19 /var/www/html/core/ArchiveProcessor/Loader.php(103): Piwik\Context::changeIdSite(1, Object(Closure))                                                                                                                                            
ERROR API[2022-12-19 20:49:27 UTC] [98] #20 /var/www/html/plugins/CoreAdminHome/API.php(284): Piwik\ArchiveProcessor\Loader->prepareArchive(false)                                                                                                                                          
ERROR API[2022-12-19 20:49:27 UTC] [98] #21 [internal function]: Piwik\Plugins\CoreAdminHome\API->archiveReports('1', Object(Piwik\Period\Day), '2022-12-18', false, false, false)                                                                                                          
ERROR API[2022-12-19 20:49:27 UTC] [98] #22 /var/www/html/core/API/Proxy.php(244): call_user_func_array(Array, Array)                                                                                                                                                                       
ERROR API[2022-12-19 20:49:27 UTC] [98] #23 /var/www/html/core/Context.php(28): Piwik\API\Proxy->Piwik\API\{closure}()
ERROR API[2022-12-19 20:49:27 UTC] [98] #24 /var/www/html/core/API/Proxy.php(335): Piwik\Context::executeWithQueryParameters(Array, Object(Closure))
ERROR API[2022-12-19 20:49:27 UTC] [98] #25 /var/www/html/core/API/Request.php(267): Piwik\API\Proxy->call('\\Piwik\\Plugins\\...', 'archiveReports', Array)
ERROR API[2022-12-19 20:49:27 UTC] [98] #26 /var/www/html/plugins/API/Controller.php(45): Piwik\API\Request->process()
ERROR API[2022-12-19 20:49:27 UTC] [98] #27 [internal function]: Piwik\Plugins\API\Controller->index()
ERROR API[2022-12-19 20:49:27 UTC] [98] #28 /var/www/html/core/FrontController.php(631): call_user_func_array(Array, Array)
ERROR API[2022-12-19 20:49:27 UTC] [98] #29 /var/www/html/core/FrontController.php(169): Piwik\FrontController->doDispatch('API', false, Array)
ERROR API[2022-12-19 20:49:27 UTC] [98] #30 /var/www/html/core/dispatch.php(32): Piwik\FrontController->dispatch()
ERROR API[2022-12-19 20:49:27 UTC] [98] #31 /var/www/html/index.php(25): require_once('/var/www/html/c...')
ERROR API[2022-12-19 20:49:27 UTC] [98] #32 /var/www/html/core/CliMulti/RequestCommand.php(79): require_once('/var/www/html/i...')
ERROR API[2022-12-19 20:49:27 UTC] [98] #33 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\CliMulti\RequestCommand->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #34 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #35 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\CliMulti\RequestCommand), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #36 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #37 /var/www/html/core/Console.php(135): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #38 /var/www/html/core/Access.php(670): Piwik\Console->Piwik\{closure}()
ERROR API[2022-12-19 20:49:27 UTC] [98] #39 /var/www/html/core/Console.php(136): Piwik\Access::doAsSuperUser(Object(Closure))
ERROR API[2022-12-19 20:49:27 UTC] [98] #40 /var/www/html/core/Console.php(87): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #41 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
ERROR API[2022-12-19 20:49:27 UTC] [98] #42 /var/www/html/console(32): Symfony\Component\Console\Application->run()
ERROR API[2022-12-19 20:49:27 UTC] [98] #43 {main},

heurteph-ei · December 20, 2022, 8:31am

Hi @djmetzle, @John_Keegan
I think this is a bug, and must be declared in GitHub:

Don’t forget to put here a link to the created issue for monitoring…

djmetzle · January 10, 2023, 7:11pm

Opened a fresh github issue related to the problem:

github.com/matomo-org/matomo

TypeErrors in UrlHelper

opened 07:09PM - 10 Jan 23 UTC

djmetzle

Potential Bug To Triage

Opening an issue on advice from the forums: https://forum.matomo.org/t/mediaana…lytics-error-message/48642/2 ## Expected Behavior No errors process tracking requests with array form GET parameters. ## Current Behavior We're seeing type errors. ## Possible Solution We are currently using a patch to work around the type error from `utm` get param arrays: ```diff diff --git core/UrlHelper.php core/UrlHelper.php index 1e51828977..1faf819c63 100644 --- core/UrlHelper.php +++ core/UrlHelper.php @@ -279,7 +279,7 @@ class UrlHelper { $nameToValue = self::getArrayFromQueryString($urlQuery); - if (isset($nameToValue[$parameter])) { + if (isset($nameToValue[$parameter]) && is_string($nameToValue[$parameter])) { return $nameToValue[$parameter]; } return null; ``` Note that this probably breaks the tests around `UrlHelper::getParameterFromQueryString`: https://github.com/matomo-org/matomo/blob/8d05108aec86f5c6779b17d18c2e9a7ee7f2f827/tests/PHPUnit/Unit/UrlHelperTest.php#L117-L122 But those tests enforce contradiction with the docblock return type! https://github.com/matomo-org/matomo/blob/8d05108aec86f5c6779b17d18c2e9a7ee7f2f827/core/UrlHelper.php#L275 This method should always return a string (not an array) in order to meet the documented interface. ## Steps to Reproduce (for Bugs) <details> <summary> Tracking hits that include `utm` GET params in array format (which are not correct, but error out the tracker), such as </summary> ``` [2022-12-21 20:11:45] piwik.ERROR: Uncaught exception: TypeError: urldecode(): Argument #1 ($string) must be of type string, array given in /var/www/html/plugins/Referrers/Columns/Base.php:379 Stack trace: #0 /var/www/html/plugins/Referrers/Columns/Base.php(379): urldecode(Array) #1 /var/www/html/plugins/Referrers/Columns/Base.php(417): Piwik\Plugins\Referrers\Columns\Base->detectCampaignFromString('utm_campaign[]=...') #2 /var/www/html/plugins/Referrers/Columns/Base.php(560): Piwik\Plugins\Referrers\Columns\Base->detectReferrerCampaignFromLandingUrl() #3 /var/w ww/html/plugins/Referrers/Columns/Base.php(121): Piwik\Plugins\Referrers\Columns\Base->detectReferrerCampaign(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor)) #4 /var/www/html/plugins/Referrers/Columns/Base.php(267): Piwik\Plugins\Referrers\Columns\Base->getReferrerInfor mation('', 'https://www.ifi...', 1, Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor)) #5 /var/www/html/plugins/Referrers/Columns/Keyword.php(35): Piwik\Plugins\Referrers\Columns\Base->getReferrerInformationFromRequest(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Vi sitor)) #6 /var/www/html/core/Tracker/Visit.php(514): Piwik\Plugins\Referrers\Columns\Keyword->onNewVisit(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor), Object(Piwik\Tracker\ActionPageview)) #7 /var/www/html/core/Tracker/Visit.php(317): Piwik\Tracker\Visit->triggerHook OnDimensions(Array, 'onNewVisit') #8 /var/www/html/core/Tracker/Visit.php(210): Piwik\Tracker\Visit->handleNewVisit(NULL) #9 /var/www/html/core/Tracker.php(172): Piwik\Tracker\Visit->handle() #10 /var/www/html/plugins/QueuedTracking/Queue/Processor/Handler.php(46): Piwik\Tracker->tra ckRequest(Object(Piwik\Tracker\Request)) #11 /var/www/html/plugins/QueuedTracking/Queue/Processor.php(194): Piwik\Plugins\QueuedTracking\Queue\Processor\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet)) #12 /var/www/html/plugins/QueuedTracking/Queue/Processor. php(143): Piwik\Plugins\QueuedTracking\Queue\Processor->processRequestSets(Object(Piwik\Tracker), Array) #13 /var/www/html/plugins/QueuedTracking/Commands/Process.php(88): Piwik\Plugins\QueuedTracking\Queue\Processor->process() #14 /var/www/html/vendor/symfony/console/Symfony/Compone nt/Console/Command/Command.php(257): Piwik\Plugins\QueuedTracking\Commands\Process->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(87 4): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application ->doRunCommand(Object(Piwik\Plugins\QueuedTracking\Commands\Process), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Inpu t\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/core/Console.php(135): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 /var/www/html/core/Access.php(670): Piwi k\Console->Piwik\{closure}() #20 /var/www/html/core/Console.php(136): Piwik\Access::doAsSuperUser(Object(Closure)) #21 /var/www/html/core/Console.php(87): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput )) #22 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #23 /var/www/html/console(32): Symfony\Component\Console\Applica tion->run() #24 {main} {"exception":"[object] (TypeError(code: 0): urldecode(): Argument #1 ($string) must be of type string, array given at /var/www/html/plugins/Referrers/Columns/Base.php:379)","ignoreInScreenWriter":true} {"class":"Piwik\\ExceptionHandler","request_id":138} Uncaught exception in /var/www/html/plugins/Referrers/Columns/Base.php line 379: urldecode(): Argument #1 ($string) must be of type string, array given #0 /var/www/html/plugins/Referrers/Columns/Base.php(379): urldecode(Array) #1 /var/www/html/plugins/Referrers/Columns/Base.php(417): Piwik\Plugins\Referrers\Columns\Base->detectCampaignFromString('utm_campaign[]=...') #2 /var/www/html/plugins/Referrers/Columns/Base.php(560): Piwik\Plugins\Referrers\Columns\Base->detectReferrerCampaignFromLandingUrl() #3 /var/www/html/plugins/Referrers/Columns/Base.php(121): Piwik\Plugins\Referrers\Columns\Base->detectReferrerCampaign(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor)) #4 /var/www/html/plugins/Referrers/Columns/Base.php(267): Piwik\Plugins\Referrers\Columns\Base->getReferrerInformation('', 'https://www.ifi...', 1, Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor)) #5 /var/www/html/plugins/Referrers/Columns/Keyword.php(35): Piwik\Plugins\Referrers\Columns\Base->getReferrerInformationFromRequest(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor)) #6 /var/www/html/core/Tracker/Visit.php(514): Piwik\Plugins\Referrers\Columns\Keyword->onNewVisit(Object(Piwik\Tracker\Request), Object(Piwik\Tracker\Visitor), Object(Piwik\Tracker\ActionPageview)) #7 /var/www/html/core/Tracker/Visit.php(317): Piwik\Tracker\Visit->triggerHookOnDimensions(Array, 'onNewVisit') #8 /var/www/html/core/Tracker/Visit.php(210): Piwik\Tracker\Visit->handleNewVisit(NULL) #9 /var/www/html/core/Tracker.php(172): Piwik\Tracker\Visit->handle() #10 /var/www/html/plugins/QueuedTracking/Queue/Processor/Handler.php(46): Piwik\Tracker->trackRequest(Object(Piwik\Tracker\Request)) #11 /var/www/html/plugins/QueuedTracking/Queue/Processor.php(194): Piwik\Plugins\QueuedTracking\Queue\Processor\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet)) #12 /var/www/html/plugins/QueuedTracking/Queue/Processor.php(143): Piwik\Plugins\QueuedTracking\Queue\Processor->processRequestSets(Object(Piwik\Tracker), Array) #13 /var/www/html/plugins/QueuedTracking/Commands/Process.php(88): Piwik\Plugins\QueuedTracking\Queue\Processor->process() #14 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\QueuedTracking\Commands\Process->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #15 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\Plugins\QueuedTracking\Commands\Process), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Outp ut\ConsoleOutput)) #17 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #18 /var/www/html/core/Console.php(135): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #19 /var/www/html/core/Access.php(670): Piwik\Console->Piwik\{closure}() #20 /var/www/html/core/Console.php(136): Piwik\Access::doAsSuperUser(Object(Closure)) #21 /var/www/html/core/Console.php(87): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #22 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #23 /var/www/html/console(32): Symfony\Component\Console\Application->run() #24 {main} ``` </details> Fail to be processed. ## Context These are "bad" tracking hits, in the sense that `utm_campaign[]=...` are not technically correct, but we should be failing hard on processing these hits. Specifically, these errors stall out processing while using the QueuedTracking plugin, and stall all processing of the queue, similar to https://github.com/matomo-org/plugin-QueuedTracking/issues/192 ## Your Environment * Matomo Version: 4.12.3 * PHP Version: 8.0.26 * Server Operating System: Docker (alpine) (running on Fedora) * Additionally installed plugins: - CustomReports - MarketingCampaignsReporting - CustomAlerts - LogViewer - InvalidateReports - TasksTimetable - QueuedTracking - AbTesting - MediaAnalytics - FormAnalytics - Funnels - RollUpReporting - SearchEngineKeywordsPerformance - MultiChannelConversionAttribution - HeatmapSessionRecording - SEOWebVitals - UsersFlow - ActivityLog - WhiteLabel - Cohorts - AdvertisingConversionExport - LoginSaml - WooCommerceAnalytics - CustomVariables - GoogleAnalyticsImporter

djmetzle · January 10, 2023, 7:17pm

I’ve also opened a second, somewhat unrelated, but suspiciously similar type error problem against the premium AdvertisingConversionExport plugin:

github.com/matomo-org/matomo

Type Error in AdvertisingConversionExport

opened 07:15PM - 10 Jan 23 UTC

djmetzle

Potential Bug To Triage

Similar issue to: https://github.com/matomo-org/matomo/issues/20189 ## Expect…ed Behavior Tracking requests are processed without errors. ## Current Behavior <details> <summary> Type Errors occur in the `AdvertisingConversionExport` plugin when tracking hits include array for GET parameters: </summary> ``` Uncaught exception in /var/www/html/plugins/AdvertisingConversionExport/Tracker/RequestProcessor.php line 96: parse_url(): Argument #1 ($url) must be of type string, array given #0 /var/www/html/plugins/AdvertisingConversionExport/Tracker/RequestProcessor.php(96): parse_url(Array, 6) #1 /var/www/html/plugins/AdvertisingConversionExport/Tracker/RequestProcessor.php(41): Piwik\Plugins\AdvertisingConversionExport\Tracker\RequestProcessor->getClickIdAndProviderFromRequest(Object(Piwik\Tracker\Request)) #2 /var/www/html/core/Tracker/Visit.php(154): Piwik\Plugins\AdvertisingConversionExport\Tracker\RequestProcessor->manipulateRequest(Object(Piwik\Tracker\Request)) #3 /var/www/html/core/Tracker.php(172): Piwik\Tracker\Visit->handle() #4 /var/www/html/plugins/QueuedTracking/Queue/Processor/Handler.php(46): Piwik\Tracker->trackRequest(Object(Piwik\Tracker\Request)) #5 /var/www/html/plugins/QueuedTracking/Queue/Processor.php(194): Piwik\Plugins\QueuedTracking\Queue\Processor\Handler->process(Object(Piwik\Tracker), Object(Piwik\Tracker\RequestSet)) #6 /var/www/html/plugins/QueuedTracking/Queue/Processor.php(143): Piwik\Plugins\QueuedTracking\Queue\Processor->processRequestSets(Object(Piwik\Tracker), Array) #7 /var/www/html/plugins/QueuedTracking/Commands/Process.php(86): Piwik\Plugins\QueuedTracking\Queue\Processor->process() #8 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Command/Command.php(257): Piwik\Plugins\QueuedTracking\Commands\Process->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #9 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(874): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #10 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(195): Symfony\Component\Console\Application->doRunCommand(Object(Piwik\Plug ins\QueuedTracking\Commands\Process), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #11 [internal function]: Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #12 /var/www/html/core/Console.php(135): call_user_func(Array, Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #13 /var/www/html/core/Access.php(670): Piwik\Console->Piwik\{closure}() #14 /var/www/html/core/Console.php(136): Piwik\Access::doAsSuperUser(Object(Closure)) #15 /var/www/html/core/Console.php(87): Piwik\Console->doRunImpl(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #16 /var/www/html/vendor/symfony/console/Symfony/Component/Console/Application.php(126): Piwik\Console->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput)) #17 /var/www/html/console(32): Symfony\Component\Console\Application->run() #18 {main} ``` </details> ## Possible Solution We are working with this patch to `AdvertisingConversionExport/Tracker/RequestProcessor.php`: ```php $rawParams = $request->getRawParams(); // Bugged! parse_str(parse_url($rawParams['url'] ?? '', PHP_URL_QUERY) ?? '', $params); // Works: $rawUrl = is_string($rawParams['url']) ? $rawParams['url'] : ''; parse_str(parse_url($rawUrl, PHP_URL_QUERY) ?? '', $params); ``` This is a premium plugin, so it is not easy to get a diff, nor to create an issue on the plugin repo. ## Steps to Reproduce (for Bugs) Tracking hits include `utm_campaign[]=....` form get parameters that decode into arrays, not simple strings. ## Context These are "bad" tracking hits, in the sense that `utm_campaign[]=...` are not technically correct, but we should not be failing hard on processing these hits. Specifically, these errors stall out processing while using the QueuedTracking plugin, and stall all processing of the queue, similar to https://github.com/matomo-org/plugin-QueuedTracking/issues/192 ## Your Environment * Matomo Version: 4.12.3 * PHP Version: 8.0.26 * Server Operating System: Docker (alpine) (running on Fedora) * Additionally installed plugins: - CustomReports - MarketingCampaignsReporting - CustomAlerts - LogViewer - InvalidateReports - TasksTimetable - QueuedTracking - AbTesting - MediaAnalytics - FormAnalytics - Funnels - RollUpReporting - SearchEngineKeywordsPerformance - MultiChannelConversionAttribution - HeatmapSessionRecording - SEOWebVitals - UsersFlow - ActivityLog - WhiteLabel - Cohorts - AdvertisingConversionExport - LoginSaml - WooCommerceAnalytics - CustomVariables - GoogleAnalyticsImporter