Missing data in Behaviours and Page Titles

Support & Bugs
1

Matomo: 4.15
MySQL version: 8.0.32
PHP version: 8.2.1
Running in Windows 2019

Hi

Some urls are not searchable even though they were displayed in the live users
The data exists in the database but can not be found through the UI.
The same queries with an id work as it should with many other ids but won’t for some :

image
image711×776 97.7 KB

How can this be fixed please ?

Thank you !

2

Hi @Vincent_Tison
id_action_url_ref is the previous page URL. Use id_action_url instead.
See:
https://developer.matomo.org/guides/database-schema#visit-actions

3

Hi @heurteph-ei !
Thanks for the correction
I had to add an index on id_action_url otherwise the query would timeout.