Thomas Steur

Integrity constraint violation: 1062 Duplicate entry '...' for key 'PRIMARY for segment temporary table

26

Getting recently below error regularly. I assume this started with https://github.com/matomo-org/matomo/pull/18797 > [2022-03-13 19:01:13] piwik.ERROR: Uncaught exception in API: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '127824106' for key...

Improve in app documentation on privacy

1

We would like to improve our documentation on privacy. Especially around consent and personal data. Things we want to mention are: * When cookie consent is needed, * how to...

Understand why conversions are sometimes attributed to "Direct entry" or the payment provider, instead of the current channel

87

from https://forum.matomo.org/t/referral-exclusions/33582/25 The resolution suggested by Matomo in this article https://matomo.org/faq/how-to/how-do-i-add-a-referral-exclusion-in-matomo/ does not really address the underlying issue - it merely recategorizes the referrer from “website” to “direct entry”, which...

Segments containing log_action.name (for example page_url) contains are very slow

1

refs https://github.com/matomo-org/matomo/issues/8850 and https://github.com/matomo-org/matomo/issues/8867 When someone creates a segment like `page_url contains '%...%'` or `page_title contains '%...%'` or `event_name contains '%...%'` then these kind of queries are very slow as...

Removing default sanitizing of all API params and request vars

11

To prevent issues like https://github.com/piwik/plugin-CustomDimensions/issues/62 I would say the current way of sanitizing all input is rather an anti pattern and causes lots of bugs. We need to check if...

No longer track various browser plugins

5

Can we stop tracking of `Flash`, `Java`, `Windowsmedia`, `Silverlight`, `Realplayer` and `Quicktime`? These aren't really used anymore. Putting this for now into Matomo 5.0 so we don't forget discussing this...

Prefix all our vendor libs

17

see https://github.com/matomo-org/wp-matomo/issues/233 Need to do this in a major release. Should investigate if we can make this work. We'd only prefix vendor libraries. Could use `Matomo` or `MatomoLib` or something...

See https://github.com/matomo-org/matomo/issues/16569 to learn more about the problem it fixes and visit https://developer.matomo.org/api-reference/tracking-api for more documentation about the new `ca` parameter. Basically, we should be sending `&ca=1` along any tracking...

Not possible to create multiple Piwik tracker instances having different API urls

4

Because `$URL` is a constant and not a property of the class: https://github.com/piwik/piwik-php-tracker/blob/1.0.0/PiwikTracker.php#L32 ``` $tracker1 = new \PiwikTracker(1, 'http://demo.piwik.org/piwik.php'); $tracker2 = new \PiwikTracker(1, 'http://apache.piwik/piwik.php'); ``` Both tracker instances will use...

See https://github.com/matomo-org/matomo/issues/16569 to learn more about the problem it fixes and visit https://developer.matomo.org/api-reference/tracking-api for more documentation about the new `ca` parameter. Basically, we should be sending `&ca=1` along any tracking...