False PHP cli version and MySQLi errors

Hi @ensemblet for us to gain more insight, could you please provide us a copy of your system check? How do I find and copy the system report in Matomo for WordPress?

Hello @varunmatomo we have the errors:

• Error PHP cli Version: (Your PHP cli version is not compatible with the Matomo requirements. 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)

too. How can I provide you our system check?

Sorry for my late reply…
Anyway, here is my system report:

				  # Errors

* Error Config exists and is writable.: No ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" Config does not exist. Config is not readable. Config is not writable. )
* Error Apache AddHandler support: To be confirmed (The AddHandler Apache directive maybe disabled. If you get a 500 error code when accessing Matomo, please read this <a  target="_blank">FAQ<a/>)
* 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)
* Error DB tables exist: No (Some tables may be missing: tqn_matomo_access, tqn_matomo_archive_invalidations, tqn_matomo_brute_force_log, tqn_matomo_changes, tqn_matomo_goal, tqn_matomo_locks, tqn_matomo_log_action, tqn_matomo_log_conversion, tqn_matomo_log_conversion_item, tqn_matomo_log_link_visit_action, tqn_matomo_log_profiling, tqn_matomo_log_visit, tqn_matomo_logger_message, tqn_matomo_option, tqn_matomo_plugin_setting, tqn_matomo_privacy_logdata_anonymizations, tqn_matomo_report, tqn_matomo_report_subscriptions, tqn_matomo_segment, tqn_matomo_sequence, tqn_matomo_session, tqn_matomo_site, tqn_matomo_site_setting, tqn_matomo_site_url, tqn_matomo_tracking_failure, tqn_matomo_twofactor_recovery_code, tqn_matomo_user, tqn_matomo_user_dashboard, tqn_matomo_user_language, tqn_matomo_user_token_auth, tqn_matomo_tagmanager_container, tqn_matomo_tagmanager_container_release, tqn_matomo_tagmanager_container_version, tqn_matomo_tagmanager_tag, tqn_matomo_tagmanager_trigger, tqn_matomo_tagmanager_variable)

# Matomo

* Matomo Plugin Version: 4.13.3
* Error Config exists and is writable.: No ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" Config does not exist. Config is not readable. Config is not writable. )
* Warning JS Tracker exists and is writable.: No ("$abs_path/wp-content/uploads/matomo/matomo.js" JS Tracker does not exist. JS Tracker is not readable. JS Tracker is not writable. )
* Plugin directories: Yes ([{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/"}])
* Tmp directory writable: Yes ($abs_path/wp-content/cache/matomo)
* Matomo Blog idSite: 0
* Matomo Install Version: No

## Endpoints

* Matomo JavaScript Tracker URL:  ($site_url/wp-content/plugins/matomo/app/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 time: 2023-02-19 22:06:47
* Blog time: 2023-02-19 23:06:47 (Below dates are shown in blog timezone)
* Sync users & sites: Next run: Unknown ( Last started: Unknown. Last ended: Unknown. Interval: daily)
* Archive: Next run: Unknown ( Last started: Unknown. Last ended: Unknown. Interval: hourly)
* Update GeoIP DB: Next run: Unknown ( Last started: Unknown. Last ended: Unknown. Interval: matomo_monthly)

## Matomo Settings

* Track mode: disabled
* Track codeposition: footer
* Track api endpoint: default
* Track js endpoint: default

## Logs

* None: 

# 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: No
* 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: -
* MATOMO_TRIGGER_BROWSER_ARCHIVING: -
* MATOMO_ENABLE_TAG_MANAGER: -
* MATOMO_SUPPRESS_DB_ERRORS: -
* MATOMO_ENABLE_AUTO_UPGRADE: -
* MATOMO_DEBUG: -
* MATOMO_SAFE_MODE: Yes
* MATOMO_GLOBAL_UPLOAD_DIR: -
* MATOMO_LOGIN_REDIRECT: -
* Permalink Structure: /%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/02
* Custom upload_path: 
* Custom upload_url_path: 
* Compatible content directory: Yes

# WordPress Plugins


## MU Plugins

* Health Check Troubleshooting Mode: 1.8.1

## Plugins

* 3D FlipBook : Dflip Lite: 1.7.35
* Admin Menu Editor Pro: 2.18.1
* Ajax Search Lite: 4.11
* Code Snippets: 3.2.2
* Complianz | GDPR/CCPA Cookie Consent: 6.4.1
* Disable Admin Notices Individually: 1.3.2
* DynamicConditions: 1.6.0
* Elementor: 3.11.1
* Elementor Pro: 3.11.1
* Feed Them Social - for Twitter feed, Youtube, and more: 3.0.2
* FileBird: 5.1.4
* Google Analytics for WordPress by MonsterInsights: 8.12.1
* GTranslate: 2.9.15
* H5P: 1.15.6
* Health Check & Troubleshooting: 1.5.1
* JetElements For Elementor: 2.6.9
* JetEngine: 3.1.1
* JetPopup: 2.0.0
* JetSmartFilters: 3.0.4
* Loco Translate: 2.6.3
* Matomo Analytics - Ethical Stats. Powerful Insights.: 4.13.3
* PDF viewer for Elementor: 2.9.3
* Perfmatters: 2.0.5
* Plausible Analytics: 1.2.4
* Post Duplicator: 2.28
* Premium Addons for Elementor: 4.9.48
* PublishPress Future: 2.8.3
* Rank Math SEO: 1.0.108
* SiteGround Optimizer: 7.3.0
* SiteGround Security: 1.4.0
* Stream: 3.9.2
* Super Page Cache for Cloudflare: 4.7.3
* Tooltips Pro: 15.1.2
* User Role Editor: 4.63.2
* White Label CMS: 2.5
* WordPress Toolbar Editor: 1.4.2
* WP Crontrol: 1.15.1
* Active Plugins: 34 (3d-flipbook-dflip-lite admin-menu-editor-pro ajax-search-lite code-snippets complianz-gdpr disable-admin-notices dynamicconditions elementor-pro elementor feed-them-social filebird-pro google-analytics-for-wordpress gtranslate h5p jet-elements jet-engine jet-popup jet-smart-filters loco-translate matomo pdf-viewer-for-elementor perfmatters plausible-analytics post-duplicator post-expirator premium-addons-for-elementor seo-by-rank-math sg-cachepress sg-security stream tooltips-pro white-label-cms wp-cloudflare-page-cache wp-toolbar-editor)
* Theme: hello-elementor (hello-elementor)

# Server

* Server Info: Apache
* Error Apache AddHandler support: To be confirmed (The AddHandler Apache directive maybe disabled. If you get a 500 error code when accessing Matomo, please read this <a  target="_blank">FAQ<a/>)
* PHP OS: Linux
* PHP Version: 7.4.33
* PHP SAPI: cgi-fcgi
* PHP Binary Name: php
* PHP Maxmind DB extension: Not loaded
* PHP Error Reporting: 0 After bootstrap: 0
* Timezone: UTC
* WP timezone: Europe/Copenhagen
* Locale: da_DK
* User Locale: da_DK
* Memory Limit: 768M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
* WP Memory Limit: 512M
* WP Max Memory Limit: 768M
* Timezone version: 2022.1
* Time: 1676844408
* Max Execution Time: 120
* Max Post Size: 256M
* Max Upload Size: 268435456
* Max Input Vars: 3000
* Disabled PHP functions: No
* zlib.output_compression is off: Yes
* Curl Version: 7.85.0, OpenSSL/3.0.8
* 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: 5.7.39
* Mysqli Connect: Yes
* Force MySQL over Mysqli: No
* DB Prefix: tqn_
* DB CHARSET: utf8
* DB COLLATE: 
* SHOW ERRORS: No
* SUPPRESS ERRORS: No
* Uses Socket: No
* Uses IPv6: No
* Matomo tables found: 0
* Error DB tables exist: No (Some tables may be missing: tqn_matomo_access, tqn_matomo_archive_invalidations, tqn_matomo_brute_force_log, tqn_matomo_changes, tqn_matomo_goal, tqn_matomo_locks, tqn_matomo_log_action, tqn_matomo_log_conversion, tqn_matomo_log_conversion_item, tqn_matomo_log_link_visit_action, tqn_matomo_log_profiling, tqn_matomo_log_visit, tqn_matomo_logger_message, tqn_matomo_option, tqn_matomo_plugin_setting, tqn_matomo_privacy_logdata_anonymizations, tqn_matomo_report, tqn_matomo_report_subscriptions, tqn_matomo_segment, tqn_matomo_sequence, tqn_matomo_session, tqn_matomo_site, tqn_matomo_site_setting, tqn_matomo_site_url, tqn_matomo_tracking_failure, tqn_matomo_twofactor_recovery_code, tqn_matomo_user, tqn_matomo_user_dashboard, tqn_matomo_user_language, tqn_matomo_user_token_auth, tqn_matomo_tagmanager_container, tqn_matomo_tagmanager_container_release, tqn_matomo_tagmanager_container_version, tqn_matomo_tagmanager_tag, tqn_matomo_tagmanager_trigger, tqn_matomo_tagmanager_variable)
* Matomo users found: table not exists
* Matomo sites found: table not exists
* Required permissions: OK

# Browser

* Browser:  (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36)

	

As you might notice, I have installed and activated the Plausible plugin. This wasnt installed when I encountered the original errors.

Thanks!

Hi @lrocz can you please use a compatible PHP version and can you enable the MySQLi extension

How do I find and copy the system report in Matomo for WordPress?

Hi @ensemblet similar to above can you address these 2 errors by?using a updating your PHP cli version and can you enable the MySQLi extension for PHP-CLI (your hoster may be able to help)

This can happen when Matomo is trying to archive reports in the background using the CLI (command line interface) but your PHP is not configured to have MySQL available when the CLI is used. This may be the case because PHP can be configured differently for the web and cli.

The solution is usually to disable the usage of background report generation and instead force the archiving using a web request. In most cases this does not have any disadvantage for users. You can do this by adding below line to your “wp-config.php”

define(‘MATOMO_SUPPORT_ASYNC_ARCHIVING’, false);

Hi. I have the same problems running on compatible PHP Version: 8.0.27.
I was advised to install 8.1 but I am reluctant to do so. I am not so sure if this helps and might run into other problems with other plugin’s.

Hello @schaipau I have replied to our thread. Please check my response on this link https://www.ads-software.com/support/topic/unable-to-reinstall-after-crash/.

Hi @ensemblet I just want to follow up if this issue has been resolved. If there’s still an issue feel free to comment and we’re happy to follow up.

I’m afraid the issue was never solved…
I did indeed have a compatible PHP cli version installed and MySQLi support was activated.
Nevertheless I never managed to make my setup able to work with Matamo, so I am now running a solution from one of your competitors.

However, thanks for following up on the issue;-)

Yes, here the same – issue not solved and the code define(‘MATOMO_SUPPORT_ASYNC_ARCHIVING’, false
produces a critical error in the website. The host does not see a problem on their side. And Matomo seems to work, though, so I just wait… ??

I’m sorry to hear that @ensemblet.

@wppraesenz kindly follow the steps on this guide https://matomo.org/faq/on-premise/how-to-set-up-auto-archiving-of-your-reports/ to fix the error you are getting.

Hi?@wppraesenz 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.

If you’re facing inaccurate errors with Matomo setup despite proper PHP cli version and MySQLi support, and you’ve isolated the issue to Elementor and Matomo plugins, it might be worth investigating compatibility concerns relevant to Qatar visa websites and consulting Matomo support if needed.