Matomo is not collecting data a long time

Since long time,Matomo not collect visitor data
Track code:

<!-- Matomo -->
  var _paq = window._paq = window._paq || [];
  /* tracker methods like "setCustomDimension" should be called before "trackPageView" */
  (function() {
    var u="https://[url]/piwik/";
    _paq.push(['setTrackerUrl', u+'matomo.php']);
    _paq.push(['setSiteId', '1']);
    var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
    g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s);
<!-- End Matomo Code -->

In developer view (F122) file matomo.php has code 400 -bad reguest.
Technical details:
PHP Version 7.4.26
DB Adapter: MYSQLI

I don’t see the tracking code…
Can you display also the response body?

I dont know why is not visible.

Error log
[Tue Jan 04 01:43:03.874363 2022] [lsapi:warn] [pid 2465732:tid 140046501787392] [client [ip]:35452] [host my. domain] Backend log: Error in Matomo (tracker): Error query: preparing query failed: Unknown column ‘last_idlink_va’ in ‘field list’ : SELECT visit_last_action_time, visit_first_action_time, idvisitor, idvisit, user_id, visit_exit_idaction_url, visit_exit_idaction_name, visitor_returning, visitor_seconds_since_first, visitor_seconds_since_order, visitor_count_visits, visit_goal_buyer, location_country, location_region, location_city, location_latitude, location_longitude, referer_name, referer_keyword, referer_type, idsite, profilable, visit_entry_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_url, config_browser_name, config_client_type, config_device_brand, config_device_model, config_device_type, visit_total_events, visit_total_time, location_ip, location_browser_lang, last_idlink_va FROM matomo_log_visit FORCE INDEX (index_idsite_idvisitor) WHERE idsite = ? AND visit_last_action_time <= ? AND idvisitor = ? ORDER BY visit_last_action_time DESC LIMIT 1\n, referer: https://[domain].pl/glosne-reklamy/463-stanowisko-tvn-i-tvn-player-glosne-reklamy.html

That’s because HTML is not allowed on the forum unless inside of codeblocks (</> button)

This sounds a lot like this issue:

1 Like

Ok. Let’s start following instruction:
“Try removing the CustomDimensions plugin from config.ini.php . There should be an entry in the PluginsInstalled and Plugins section.”

That should trigger the install of the plugin again, which should create the missing columns"
I removed
PluginsInstalled[] = “CustomDimensions”
from config file,but in backend was active. I deactivated plugin manually and activate again. After wrote password I got message
" You have successfully activated CustomDimensions .
Nowadays, in developer view are corrects codes 200 - tomorrow I will know results

Addiotaily I added
debug = 1 to config file but I dont know where read the data

Matomo not collect the data how solve it?

I reinstalled competelly.

Did you do something for not collecting data, or did it fail suddenly?

Probably after update something was corrupted. I tried repair it but,no result I decided reinstall.

1 Like