matomo-org / matomo-org/matomo-for-wordpress

PHPcli and MySQLi support missing, but host claims we're up to date

Open
#809 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
PHP
Stars
145
Forks
35
Avg merge
2d 2h
Merged PRs (30d)
6

Description

# 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)

# Matomo

* Matomo Plugin Version: 4.14.2
* Config exists and is writable.: Yes ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" )
* JS Tracker exists and is writable.: Yes ("$abs_path/wp-content/uploads/matomo/matomo.js" )
* Plugin directories: Yes ([{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/"}])
* Tmp directory writable: Yes ($abs_path/wp-content/cache/matomo)
* Matomo Version: 4.14.2
* Matomo Blog idSite: 1
* Matomo Install Version: 4.14.2 (Install date: 2023-06-20 09:55:09)
* 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 time: 2023-06-22 08:25:37
* Blog time: 2023-06-22 10:25:37 (Below dates are shown in blog timezone)
* Sync users & sites: Next run: 2023-06-23 09:57:12 (23 hours 31 min) ( Last started: 2023-06-22 09:58:07 (-27 min 30s). Last ended: 2023-06-22 09:58:07 (-27 min 30s). Interval: daily)
* Archive: Next run: 2023-06-22 10:55:12 (29 min 35s) ( Last started: 2023-06-22 09:56:07 (-29 min 30s). Last ended: 2023-06-22 09:56:23 (-29 min 14s). Interval: hourly)
* Update GeoIP DB: Next run: 2023-07-20 09:56:12 (27 days 23 hours) ( Last started: 2023-06-20 09:56:13 (-2 days 0 hours). Last ended: 2023-06-20 09:56:14 (-2 days 0 hours). Interval: matomo_monthly)

## Mandatory checks

* PHP version >= 7.2.5: ok
* PDO extension: ok
* PDO\MYSQL extension: ok
* MYSQLI extension: ok
* Other required extensions: ok
* Required functions: ok
* Required PHP configuration (php.ini): ok
* Directories with write access: ok
* Directories with write access for Tag Manager: ok

## Optional checks

* 64-bit PHP Binary: ok
* Tracker status: ok
* Memory limit: ok
* Time zone: ok
* Open URL: ok
* GD > 2.x + FreeType (graphics): ok
* Other extensions: ok
* Other functions: ok
* Filesystem: ok
* Last Successful Archiving Completion: ok
* Database abilities: ok
* Warning Max Packet Size: warning (It is recommended to configure a 'max_allowed_packet' size in your MySQL database of at least 64MB. Configured is currently 32MB. )
* Geolocation: ok
* Update over 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. Learn more)
* 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.14.2
* Core version: 4.14.2
* Last tracking settings update: 1687418462
* Last settings update: 1687418498
* Track ecommerce: No
* Track 404: Yes

## Logs

* None:

# WordPress

* Home URL: $site_url
* Site URL: $site_url
* WordPress Version: 6.2.2
* 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: Yes
* 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: -
* 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/06
* Custom upload_path: No
* Custom upload_url_path: No
* Compatible content directory: Yes

# WordPress Plugins

* Admin Columns: 4.6.1
* Admin Menu Editor: 1.11
* Advanced Custom Fields PRO: 6.1.6
* Advanced Post Types Order: 4.8
* Complianz | GDPR/CCPA Cookie Consent: 6.4.7
* Disable Feeds: 1.4.4
* Email Address Encoder: 1.0.22
* Events Manager: 6.3
* ManageWP - Worker: 4.9.17 (Network enabled)
* Matomo Analytics - Ethical Stats. Powerful Insights.: 4.14.2
* Nuts and Bolts Theme Functions: 2.0
* Restricted Site Access: 7.4.0
* Show Current Template: 0.4.6
* SiteGround Optimizer: 7.3.1
* SiteGround Security: 1.4.5
* WP Migrate: 2.6.8 (Network enabled)
* WP Migrate DB Pro Tweaks: 0.1
* Yoast SEO: 20.9
* Active Plugins: 15 (worker admin-menu-editor advanced-custom-fields-pro advanced-post-types-order codepress-admin-columns complianz-gdpr disable-feeds email-address-encoder events-manager matomo ntn-functionality sg-cachepress sg-security wordpress-seo wp-migrate-db-pro)
* Theme: aeca (aeca)

# Server

* Server Info: Apache
* Apache AddHandler support: Supported
* PHP OS: Linux
* PHP Version: 8.0.29
* PHP SAPI: apache2handler
* PHP Maxmind DB extension: Not loaded
* PHP Error Reporting: After bootstrap: 4437
* Timezone: UTC
* WP timezone: Europe/Amsterdam
* Locale: en_US
* User Locale: en_US
* Memory Limit: 768M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
* WP Memory Limit: 256M
* WP Max Memory Limit: 768M
* Timezone version: 2022.6
* Time: 1687422337
* 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 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)

# Database

* MySQL Version: 5.7.39
* Mysqli Connect: Yes
* Force MySQL over Mysqli: No
* DB Prefix: b0adl_
* DB CHARSET: utf8
* DB COLLATE:
* SHOW ERRORS: No
* SUPPRESS ERRORS: No
* Uses Socket: No
* Uses IPv6: No
* Matomo tables found: 59
* DB tables exist: Yes
* Matomo users found: 1
* Matomo sites found: 1
* Required permissions: OK

# Browser

* Browser: (Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Safari/537.36 Edg/114.0.1823.51)
* Warning Browser Compatibility: Yes (Because you are using MS Edge browser, you may see a warning like "This site has been reported as unsafe" from "Microsoft Defender SmartScreen" when you view the Matomo Reporting, Admin or Tag Manager page. This is a false alert and you can safely ignore this warning by clicking on the icon next to the URL (in the address bar) and choosing either "Report as safe" (preferred) or "Show unsafe content". We are hoping to get this false warning removed in the future.)
* Language: nl,en,en-gb,en-us

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the PHP cli checks described in the issue and compare their output with the server PHP and mandatory MySQLi checks. Trace the entry point that produces the PHP cli Version and MySQLi support messages; done means the diagnostic accurately reflects the CLI environment and its required extensions.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, php
Domain
backend, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.