top_controlls not visible

				  # Errors

* Error PHP cli Version:  (Your PHP cli version is not compatible with the <a  target="_blank">Matomo requirements</a>. Please upgrade your PHP cli version, otherwise, you might have some archiving errors)
* Error MySQLi support: missing (Your PHP cli does not load the MySQLi extension. You might have archiving problems in Matomo but also others problems in your WordPress cron tasks. You should enable this extension)

# Matomo

* Matomo-Plugin-Version: 4.13.5
* Config existiert und ist schreibbar.: Ja ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" )
* JS Tracker existiert und ist schreibbar.: Ja ("$abs_path/wp-content/uploads/matomo/matomo.js" )
* Plugin-Verzeichnisse: Yes ([{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/"},{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins","webrootDirRelativeToMatomo":"..\/..\/"}])
* Tmp-Verzeichnis schreibbar: Yes ($abs_path/wp-content/cache/matomo)
* Matomo-Version: 4.13.3
* Matomo Blog idSite: 2
* Installierte Matomo-Version: 4.13.3 (Install date: 2023-03-07 21:43:05)
* Upgrades outstanding: No
* Upgrade in progress: No

## Endpoints

* Matomo JavaScript Tracker URL:  ($site_url/wp-content/uploads/matomo/matomo.js)
* Matomo JavaScript Tracker - WP Rest API:  ($site_url/wp-json/matomo/v1/hit/)
* Matomo HTTP Tracking API:  ($site_url/wp-content/plugins/matomo/app/matomo.php)
* Matomo HTTP Tracking API - WP Rest API:  ($site_url/wp-json/matomo/v1/hit/)

## Crons

* Server-Zeit: 2023-03-07 21:57:09
* Blog-Zeit: 2023-03-07 21:57:09 (Die nachfolgenden Daten werden in der Blog-Zeitzone angezeigt)
* Sync users & sites: Next run: 2023-03-08 21:23:02 (23 Stunden 25 Minuten) ( Last started: 2023-03-07 21:45:06 (-12 Minuten 3s). Last ended: 2023-03-07 21:45:06 (-12 Minuten 3s). Interval: daily)
* Archive: Next run: 2023-03-07 22:23:02 (25 Minuten 53s) ( Last started: 2023-03-07 21:23:07 (-34 Minuten 2s). Last ended: 2023-03-07 21:23:07 (-34 Minuten 2s). Interval: hourly)
* Update GeoIP DB: Next run: 2023-04-06 21:23:02 (29 Tage 23 Stunden) ( Last started: 2023-03-07 21:43:41 (-13 Minuten 28s). Last ended: 2023-03-07 21:44:53 (-12 Minuten 16s). Interval: matomo_monthly)

## Vorgeschriebene Prüfungen

* PHP-Version >= 7.2.5: ok 
* PDO Erweiterung: ok 
* PDO\MYSQL Erweiterung: ok 
* MYSQLI Erweiterung: ok 
* Weitere erforderliche Anforderungen: ok 
* Erforderliche Funktionen: ok 
* Ben?tigte PHP Konfiguration (php.ini): ok 
* Verzeichnisse mit Schreibzugriff: ok 
* Verzeichnisse mit Schreibzugriff auf Tag Manager: ok 

## Optionale Prüfungen

* 64-bit PHP Bin?r: ok 
* Tracker-Status: ok 
* Speicherlimit: ok 
* Zeitzone: ok 
* ?ffnen einer URL: ok 
* GD > 2.x + FreeType (Grafiken): ok 
* Andere Erweiterungen: ok 
* Andere Funktionen: ok 
* Dateisystem: ok 
* Letzter erfolgreicher Abschluss der Archivierung: ok 
* Datenbankf?higkeiten: ok 
* Warning Maximale Packetgr??e: warning  (Es wird empfohlen die 'max_allowed_packet' Gr??e in Ihrer MySQL Datenbank auf mindestens 64MB zu erh?hen. Aktuell ist 16MB eingestellt. )
* Standorterkennung: ok 
* Update über HTTPS: ok 
* Supports Async Archiving: No
* Location provider ID: geoip2php
* Location provider available: Yes
* Location provider working: Yes
* Warning Proxy header: HTTP_X_REAL_IP (A proxy header is set which means you maybe need to configure a proxy header in the Advanced settings to make location reporting work. If the location in your reports is detected correctly, you can ignore this warning. <a  target="_blank">Mehr erfahren</a>)
* Had visit in last 5 days: Yes
* Matomo URL: Yes ($site_url/wp-content/plugins/matomo/app/)

## Matomo Settings

* Track mode: default
* Track codeposition: footer
* Track api endpoint: default
* Track js endpoint: default
* Version history: 4.13.5, 4.13.3, 4.13.0, 4.12.0
* Core version: 4.13.3
* Last tracking settings update: 1676542806
* Last settings update: 1678220018
* Show get started page: 0
* Delete all data uninstall: No

## Logs

* Warning archive_bootstrap: 2023-03-07 20:00:12 (WP DB Error: [1146] Table '$DB_NAME.option' doesn't exist SQL: SELECT option_value, option_name FROM option WHERE autoload = 1 => WordPress.php:407; WordPress.php:419; Db.php:302; Option.php:288; Option.php:178; Option.php:48; FrontController.php:354; Bootstrap.php:84; Bootstrap.php:110; ScheduledTasks.php:289; class-wp-hook.php:306; class-wp-hook.php:332; plugin.php:565; wp-cron.php:188;)
* Warning archive_main: 2023-03-07 20:00:12 (WP DB Error: [1146] Table '$DB_NAME.option' doesn't exist SQL: SELECT option_value, option_name FROM option WHERE autoload = 1 => WordPress.php:407; WordPress.php:419; Db.php:302; Option.php:288; Option.php:178; Option.php:48; CronArchive.php:1217; CronArchive.php:757; CronArchive.php:301; CronArchive.php:275; Access.php:670; CronArchive.php:282; ScheduledTasks.php:332; class-wp-hook.php:306; class-wp-hook.php:332; plugin.php:565; wp-cron.php:188;)

# WordPress

* Home URL: $site_url
* Site URL: $site_url
* WordPress Version: 6.1.1
* Number of blogs: 1
* Multisite Enabled: No
* Network Enabled: No
* WP_DEBUG: No
* WP_DEBUG_DISPLAY: Yes
* WP_DEBUG_LOG: No
* DISABLE_WP_CRON: -
* FORCE_SSL_ADMIN: Yes
* WP_CACHE: No
* CONCATENATE_SCRIPTS: -
* COMPRESS_SCRIPTS: -
* COMPRESS_CSS: -
* ENFORCE_GZIP: -
* WP_LOCAL_DEV: -
* WP_CONTENT_URL: $site_url/wp-content
* WP_CONTENT_DIR: $abs_path/wp-content
* UPLOADS: -
* BLOGUPLOADDIR: -
* DIEONDBERROR: -
* WPLANG: 
* ALTERNATE_WP_CRON: -
* WP_CRON_LOCK_TIMEOUT: 60
* WP_DISABLE_FATAL_ERROR_HANDLER: -
* MATOMO_SUPPORT_ASYNC_ARCHIVING: No
* MATOMO_TRIGGER_BROWSER_ARCHIVING: -
* MATOMO_ENABLE_TAG_MANAGER: -
* MATOMO_SUPPRESS_DB_ERRORS: -
* MATOMO_ENABLE_AUTO_UPGRADE: -
* MATOMO_DEBUG: -
* MATOMO_SAFE_MODE: -
* MATOMO_GLOBAL_UPLOAD_DIR: -
* MATOMO_LOGIN_REDIRECT: -
* Permalink Structure: /%year%/%monthnum%/%day%/%postname%/
* Possibly uses symlink: No
* Upload base url: $site_url/wp-content/uploads
* Upload base dir: $abs_path/wp-content/uploads
* Upload url: $site_url/wp-content/uploads/2023/03
* Custom upload_path: 
* Custom upload_url_path: 
* Compatible content directory: Yes

# WordPress Plugins

* Advanced Custom Fields: 6.0.7
* All-in-One WP Migration: 7.71 (Network enabled)
* All-in-One WP Migration Dropbox Extension: 3.71 (Network enabled)
* Autoptimize: 3.1.5
* Borlabs Cookie - Cookie Opt-in: 2.2.62
* Borlabs Font Blocker: 1.0.5
* Category Order and Taxonomy Terms Order: 1.7.4
* Contact Form 7: 5.7.4
* Custom Reports (Matomo Plugin): 4.0.15
* Duplicate Page: 4.5.1
* Duplicator: 1.5.2.1 (Network enabled)
* FileBird Lite: 5.1.4
* File Manager Advanced: 5.0.3
* LayerSlider WP: 6.11.7
* Matomo Analytics - Ethical Stats. Powerful Insights.: 4.13.5
* Really Simple SSL: 6.2.0
* Simple Custom CSS: 4.0.6
* Slider Revolution: 6.6.5
* Uncode Core: 2.7.2
* Uncode Privacy: 2.2.2
* Uncode Wireframes: 1.5.0
* Uncode WPBakery Page Builder: 6.9.0
* UpdraftPlus - Backup/Restore: 1.22.24
* Wordfence Security: 7.9.1 (Network enabled)
* WPBakery Page Builder Clipboard: 5.0.2
* WPML Multilingual CMS: 4.4.10
* Active Plugins: 26 (sitepress-multilingual-cms CustomReports LayerSlider advanced-custom-fields all-in-one-wp-migration-dropbox-extension all-in-one-wp-migration autoptimize borlabs-cookie borlabs-font-blocker contact-form-7 duplicate-page duplicator file-manager-advanced filebird matomo really-simple-ssl revslider simple-custom-css taxonomy-terms-order uncode-core uncode-js_composer uncode-privacy uncode-wireframes updraftplus vc_clipboard wordfence)
* Theme: uncode (uncode-child)

# Server

* Server Info: Apache
* PHP OS: Linux
* PHP Version: 8.1.14
* PHP SAPI: cgi-fcgi
* PHP Binary Name: /opt/plesk/php/8.1/bin/php-cgi
* PHP Maxmind DB extension: Not loaded
* PHP Error Reporting:  After bootstrap: 4437
* Timezone: UTC
* WP timezone: +00:00
* Locale: de_DE
* User Locale: de_DE
* Memory Limit: 512M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
* WP Memory Limit: 40M
* WP Max Memory Limit: 512M
* Timezone version: 0.system
* Time: 1678226231
* Max Execution Time: 1200
* Max Post Size: 500M
* Max Upload Size: 524288000
* Max Input Vars: 5000
* Disabled PHP functions: Yes (opcache_get_status)
* zlib.output_compression is off: Yes
* Curl Version: 7.29.0, NSS/3.53.1
* Suhosin installed: No

# PHP cli

* Error PHP cli Version:  (Your PHP cli version is not compatible with the <a  target="_blank">Matomo requirements</a>. Please upgrade your PHP cli version, otherwise, you might have some archiving errors)
* Error MySQLi support: missing (Your PHP cli does not load the MySQLi extension. You might have archiving problems in Matomo but also others problems in your WordPress cron tasks. You should enable this extension)

# Database

* MySQL Version: 10.6.11
* Mysqli Connect: Yes
* Force MySQL over Mysqli: No
* DB Prefix: wp_
* DB CHARSET: utf8mb4
* DB COLLATE: 
* SHOW ERRORS: No
* SUPPRESS ERRORS: No
* Uses Socket: No
* Uses IPv6: No
* Matomo tables found: 121
* DB tables exist: Yes
* Matomo users found: 4
* Matomo sites found: 2
* Erforderliche Berechtigungen: OK

# Browser

* Browser:  (Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/105.0.0.0 Safari/537.36)
* Language: en-gb,en

	

Hi @jurmac. For the top controls problem, it mostly happen where there are unexpected records in the Matomo site table in a non multisite context.
Can you please let us know if you are using WordPress as multisite or not?

@emermatomo thanks for the response!

I’m not using WordPress as multisite.

Hi @emermatomo, what can I do to solve this problem? ??

Hello @jurmac sorry for the delay.

Since you are not using a multisite, can you please try to execute the following query:
select idsite, name, main_url, ts_created from wp_matomo_site;

If you have more than one record, there is a problem.

You’ll have to investigate if there were some data for all sites or there is one which is just here for nothing. To do so, please run a query similar to:
select ’03’ as month, idsite, count(*) from wp_matomo_archive_blob_2023_03 group by idsite union select ’02’ as month, idsite, count(*) from wp_matomo_archive_blob_2023_02 group by idsite union select ’01’ as month, idsite, count(*) from wp_matomo_archive_blob_2023_01 group by idsite;

You must adapt it to include all months between the two ts_created you found in the previous query.

If you see in this SQL query output that there is an idsite which is never used and if this idsite is NOT the one you can find in his system report under “Matomo Blog idSite”, then? you can delete the record in the wp_matomo_site table which matches this idSite.

Hi @jurmac I assume that it worked since it’s been 2 weeks and will therefore mark the issue for now as resolved. If something is not working feel free to leave a comment and we continue following up.