No more visit counting since upgrade to Matomo 5.11.1

Support & Bugs
1

Hi,

I cannot see any visit count since the very time I upgraded to Matomo 5.11.1, presumably from Matomo 4.4.1.

Matomo Update History says 4.4.1,4.0.1-b1,3.5.1-b1,3.0.4 (yes, I obviously don’t upgrade often enough)

The “issue” is that… the interface shows a number of warning, but no particular issue, and the upgrade is said to have been successful.

<details>
<summary>Click to view System Check</summary>

### Mandatory checks

#### Version PHP >= 7.2.5:
 ✔ 7.4.33

#### PDO extension:
 ✔ 

#### PDO\MYSQL extension:
 ✔ 

#### MYSQLI extension:
 ✔ 

#### Autres extensions requises:
 ✔ zlib ✔ json ✔ filter ✔ hash ✔ session

#### Fonctions requises:
 ✔ debug_backtrace ✔ escapeshellarg ✔ eval ✔ hash ✔ gzcompress ✔ gzuncompress ✔ pack

#### Configuration PHP requise (php.ini):
 ✔ session.auto_start = 0 ✔ max_execution_time = 0 OR = -1 OR >= 30

etc.

What can I do?

Thanks!

2

Hi,

I still have no Matomo working; what can I do? Of course deleting everything might be an option, but clearly I’d like to avoid that :stuck_out_tongue:

3

Hello there,

Can you share the public URL of any website which is connected/integrated with Matomo?

I want to cross if there is any Matomo related error being displayed in console or network tab.

5

Also note that, when I try to regenerate the code, I get an empty box and the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'plugin_name' in 'where clause'

6

image
image1919×970 565 KB

image
image1914×975 359 KB

Please take a look at the attached screenshots, Matomo is not working fine. It is throwing 400 bad request error.

@matomonp44 ,
Can you share the Matomo log file if possible? So that I can identify the actual issue with Matomo.

7

Tons of errors of this form

ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] Exception: /core/Tracker/Db/Pdo/Mysql.php(261): Error query: Error query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘plugin_name’ in ‘where clause’ In query: SELECT setting_name, setting_value FROM piwik_site_setting WHERE idsite = ? and plugin_name = ? Parameters: array (
ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] 0 => 11,
ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] 1 => ‘CnilPolicy’,
ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] ) In query: SELECT setting_name, setting_value FROM piwik_site_setting WHERE idsite = ? and plugin_name = ? Parameters: array (
ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] 0 => 11,
ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] 1 => ‘CnilPolicy’,
ERROR Piwik\Tracker\Handler[2026-07-07 11:59:22 UTC] [352c6] ) [Query: ?action_name

Seems like a database structure problem? Presumably when updating?

8

A successful upgrade doesn’t always mean the reporting data is being processed correctly. Since the problem started immediately after upgrading from Matomo 4.4.1 to 5.11.1, there are a few things I’d check first:

  • Verify whether new visits are actually being tracked by opening Visitors → Real-time and visiting your site yourself.

  • Check whether the archive reports are being generated. If you’re using cron archiving, make sure the archiving job is still running successfully after the upgrade.

  • Review Administration → System → Diagnostics (or the Matomo logs) for any database or archiving errors that may not appear in the basic System Check.

  • Clear the Matomo cache and, if available, trigger Invalidate archived reports so Matomo rebuilds them.

  • Since you’re upgrading across several major versions, it’s also worth running any pending database migrations again to ensure nothing was skipped.

If those don’t reveal the issue, it would help if you could share:

  • Do Real-time Visitors show new visits?

  • Are all websites affected or just one?

  • Is the visit count missing for only new data, or has all historical data disappeared as well?

  • Are you using browser archiving or a cron job for archiving?

Those details should make it much easier to identify whether this is a tracking, archiving, or database migration issue.

9

  1. Verify whether new visits are actually being tracked by opening Visitors → Real-time and visiting your site yourself.

No, they don’t, it’s all blocked at 14th June 2026. Nothing since.

Review Administration → System → Diagnostics (or the Matomo logs) for any database or archiving errors that may not appear in the basic System Check.

Yes, tons of errors in the logs (see my previous message).
No issue in the diagnosis though.

  1. Are all websites affected or just one?

    All.

  2. Is the visit count missing for only new data, or has all historical data disappeared as well?

    I can see former data.

Are you using browser archiving or a cron job for archiving?

Browser cache.

The log that I posted before show an issue in the database format, probably a failed update? So no data seems to be recorded because all MySQL requests fail.

10

I’m still stuck!

Is there anything I can do except deleting everything and restarting a fresh install?