matomo-for-wordpress
matomo-for-wordpress copied to clipboard
matomo-org
4.10.0 - Multiple SQL errors in WP syslog
Hi, I installed matomo but over past few days I collected a number of error in the logs under my Wordpress 6.0.1 instance.
Indeed, I logged only a single site visit, otherwise something is broken.
The wp-admin/admin.php?page=matomo-about shoudl include a version number, if possible. Thank you for future fixes
Hi @mmokrejs
Thank you for your report, we investigate it. What do you mean by
Indeed, I logged only a single site visit, otherwise something is broken.
Could you share your system report available from the menu Matomo Analytics > Diagnostics?
Kind regards
Mat
After installing matomo one my visit got logged, then just nothing. I don't know if I screwed something in the config or not, hard to say. Maybe the issue is mysql-5.5.15 being too old? Meanwhile admin updated php to 7.3. Now recent accesses got recorded by matomo, so maybe you can expect the errors were related to too old php+mysql?
Current, after update, setup is as follows:
Hi @mmokrejs
After installing matomo one my visit got logged, then just nothing When you say nothing, does it means that you have no report data? Nothing updated in the visitor log?
So for now you don't have any problem anymore?
Kind regards
Mat
Hi @mattmary , I am sorry for the delay. Things are just stacking up ...
I think Matomo seems to work although I really had to get increaed memory for CGI processes to 1024MB.
I attach the current logs here with errors in there: matomo-errors.log.gz
Hello @mmokrejs
Thank you. Did you set up a crontask to manage your WordPress schedule tasks, or do you use the native behaviour? Could you please post your system report, available from the menu "Matomo Analytics > Diagnostics"?
Kind regards
Mat
Hi @mattmary , no I did not install any cronjob.
# Matomo
* Verze zásuvného modulu Matomo: 4.11.0
* Config existuje a je zapisovatelný.: Ano ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" )
* JS Tracker existuje a je zapisovatelný.: Ano ("$abs_path/wp-content/uploads/matomo/matomo.js" )
* Adresáře zásuvných modulů: Yes ([{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/"},{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins","webrootDirRelativeToMatomo":"..\/..\/"}])
* Adresář Tmp zapisovatelný: Yes ($abs_path/wp-content/cache/matomo)
* Verze systému Matomo: 4.11.0
* Matomo Blog idSite: 1
* Instalační verze Matomo: 4.10.0 (Install date: 2022-08-01 16:21:10)
* 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
* Čas serveru: 2022-10-10 21:36:49
* Čas blogu: 2022-10-10 23:36:49 (Níže uvedená data jsou zobrazena v časovém pásmu blogu)
* Sync users & sites: Next run: 2022-10-11 16:22:00 (16 hours 45 min) ( Last started: 2022-10-10 16:23:21 (-7 hours 13 min). Last ended: 2022-10-10 16:23:21 (-7 hours 13 min). Interval: daily)
* Archive: Next run: 2022-10-11 00:21:13 (44 min 24s) ( Last started: 2022-10-10 23:21:47 (-15 min 2s). Last ended: 2022-10-10 23:22:15 (-14 min 34s). Interval: hourly)
* Update GeoIP DB: Next run: 2022-10-30 15:21:48 (19 days 16 hours) ( Last started: 2022-09-30 16:24:16 (-10 days 7 hours). Last ended: 2022-09-30 16:24:22 (-10 days 7 hours). Interval: matomo_monthly)
## Povinné kontroly
* PHP version >= : 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
## Nepovinné kontroly
* 64-bit PHP Binary: ok
* Tracker status: ok
* Memory limit: ok
* Time zone: ok
* Open URL: ok
* PageSpeed is turned off: ok
* GD > 2.x + FreeType (graphics): ok
* Other extensions: ok
* Other functions: ok
* Filesystem: ok
* Last Successful Archiving Completion: ok
* Database abilities: ok
* Max Packet Size: ok
* Geolocation: ok
* Update over HTTPS: ok
* [GoogleAnalyticsImporter] Required PHP Functions: ok
* [GoogleAnalyticsImporter] Required Executables (php): ok
* [GoogleAnalyticsImporter] Required Executables (nohup): ok
* Supports Async Archiving: Yes
* Location provider ID: geoip2php
* Location provider available: Yes
* Location provider working: Yes
* 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.11.0, 4.10.0
* Core version: 4.11.0
* Last tracking settings update: 1662650228
* Last settings update: 1662650228
* Track content: all
* Track search: Yes
* Track user id: email
* Delete all data uninstall: No
## Logs
* Žádné:
# WordPress
* Home URL: $site_url
* Site URL: $site_url
* WordPress Version: 6.0.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: /%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/2022/10
* Custom upload_path:
* Custom upload_url_path:
* Compatible content directory: Yes
# WordPress Plugins
## MU Plugins
* DecaLog Early Loader: 3.x
## Plugins
* Akismet Anti-Spam: 5.0.1
* All in One SEO: 4.2.5.1
* All Meta Tags: 4.47
* Bing Webmaster Url Submission: 1.0.13
* Burst Statistics - Privacy-Friendly Analytics for WordPress: 1.2.1
* Classic Widgets: 0.3
* Complianz | GDPR/CCPA Cookie Consent: 6.3.3
* DecaLog: 3.6.0 (Network enabled)
* Device Detector: 3.3.0 (Network enabled)
* Disable & Remove Google Fonts: 1.4.2
* File Away: 3.9.9.0.1
* File Download: 1.0.2
* GD Mail Queue: 3.9.3
* Geo2 Maps Add-on for NextGEN Gallery: 2.0.5
* Give - Donation Plugin: 2.22.2
* Google Analytics Importer (Matomo Plugin): 4.2.0
* Google Keyword Suggest: 1.0.2
* Gutenberg: 14.2.0
* Image Widget RB: 1.0.9
* IP Locator: 3.6.0 (Network enabled)
* Log HTTP Requests: 1.3.2
* MapPress Maps for WordPress: 2.84
* Matomo Analytics - Ethical Stats. Powerful Insights.: 4.11.0
* Mongoose Page Plugin: 1.8.3
* NextGEN Gallery: 3.30
* NgSurvey: 1.1.3
* Referrer Analytics: 2.0.1
* Robo Gallery: 3.2.4
* Sessions: 2.8.0 (Network enabled)
* Shared Files: 1.6.84
* Simple File List: 4.4.13
* Simple History: 3.3.0
* Simple Yearly Archive: 2.1.8
* Site Kit by Google: 1.85.0
* Smart Slider 3: 3.5.1.11
* Spiffy Calendar: 4.9.1
* Super Simple Event Calendar: 1.4.2
* The Events Calendar: 6.0.1.1
* Traffic: 2.8.0
* User Activity Tracking and Log: 3.3.18
* Vibes: 1.4.0
* W3 Total Cache: 2.2.6 (Network enabled)
* Widget Options: 3.8.9.1
* Wordfence Security: 7.7.1 (Network enabled)
* Wordpress File Upload: 4.16.4
* WP-Sweep: 1.1.5
* WP BackItUp Community Edition: 1.43
* WP Clone: 2.3.4
* WP Event Manager: 3.1.32
* WP File Manager: 7.1.6
* WP Mail SMTP: 3.6.1
* WP Statistics: 13.2.6
* WP System Info: 1.5
* YellowPencil: 7.5.7
* Active Plugins: 43 (GoogleAnalyticsImporter akismet all-in-one-seo-pack all-meta-tags bing-webmaster-tools burst-statistics classic-widgets complianz-gdpr decalog device-detector disable-remove-google-fonts facebook-page-feed-graph-api file-away gd-mail-queue give google-keyword-suggest google-site-kit gutenberg image-widget-rb ip-locator log-http-requests matomo ngsurvey referrer-analytics robo-gallery sessions simple-history simple-yearly-archive smart-slider-3 super-simple-event-calendar the-events-calendar traffic user-activity-tracking-and-log vibes w3-total-cache widget-options wordfence wp-event-manager wp-file-manager wp-file-upload wp-statistics wp-system-info yellow-pencil-visual-theme-customizer)
* Theme: nature-bliss (nature-bliss)
# Server
* Server Info: Apache/2.4.46 (Ubuntu)
* PHP OS: Linux
* PHP Version: 7.4.30
* PHP SAPI: fpm-fcgi
* PHP Binary Name: php-fpm7.4
* PHP Error Reporting: 0 After bootstrap: 0
* PHP Found Binary: php -q
* Timezone: UTC
* WP timezone: Europe/Prague
* Locale: cs_CZ
* User Locale: en_US
* Memory Limit: 1024M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
* WP Memory Limit: 1024M
* WP Max Memory Limit: 1024M
* Timezone version: 0.system
* Time: 1665437810
* Max Execution Time: 35
* Max Post Size: 1024M
* Max Upload Size: 1073741824
* Max Input Vars: 1000
* Disabled PHP functions: Yes (pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority)
* zlib.output_compression is off: Yes
* Curl Version: 7.58.0, OpenSSL/1.1.1
* Suhosin installed: No
# Database
* MySQL Version: 5.5.5
* 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: 63
* DB tables exist: Yes
* Matomo users found: 5
* Matomo sites found: 1
* Požadovaná oprávnění: OK
# Browser
* Browser: (Mozilla/5.0 (X11; Linux x86_64; rv:104.0) Gecko/20100101 Firefox/104.0)
* Language: cs,sk,en-us,en
Hello @mmokrejs
Thank you.
Everything looks fine in your system report. Does these errors lines still happen in your debug log, or they happened only one time?
Kind regards
Mat
Hello @mmokrejs
Just wondering if you still have this issue with the latest plugin version?
Kind regards
Mat
Hi @mattmary , yes it is still there:
[2022-11-20T11:21:48.206000+01:00] WFRONT.CRITICAL: A database error was detected during the page rendering: “Table `foo.wp_matomo_logtmpsegmentfdd61566ce217be201bcb9740d657dd8` doesn`t exist“ in the query “SELECT /*+ MAX_EXECUTION_TIME(7200000) */ /* WP IGNORE ERROR */ 1 FROM wp_matomo_logtmpsegmentfdd61566ce217be201bcb9740d657dd8 LIMIT 1“. {"class":"db","component":"MariaDB","version":"10.6.8","phase":"","code":0,"environment":"production","traceID":"d7d7b7978753918182585728c27f457f","instance":"005a3074ff0f"} {"siteid":1,"sitename":"MY WEBSITE","sitedomain":"www.foo.org","userid":0,"username":"anonymous","ip":"127.0.0.1"}
[2022-11-20T01:36:42.852846+01:00] CRON.NOTICE: Error (E_NOTICE): “Undefined index: HTTP_ACCEPT_LANGUAGE“ at `./wp-content/plugins/matomo/app/core/Common.php:847`. {"class":"php","component":"PHP","version":"7.4.30","phase":"","code":8,"environment":"production","traceID":"9e6366fdff6473c17766018156e69a26","instance":"005a3074ff0f"} {"siteid":1,"sitename":"MY WEBSITE","sitedomain":"www.foo.org","userid":0,"username":"anonymous","ip":"172.0.0.0"}
[2022-11-20T01:59:50.902205+01:00] WFRONT.NOTICE: Error (E_NOTICE): “Undefined index: proxy_client_headers“ at `./wp-content/plugins/matomo/app/core/IP.php:49`. {"class":"php","component":"PHP","version":"7.4.30","phase":"","code":8,"environment":"production","traceID":"6e46674114991967d9ca42e62919b281","instance":"005a3074ff0f"} {"siteid":1,"sitename":"MY WEBSITE","sitedomain":"www.foo.org","userid":0,"username":"anonymous","ip":"40.0.0.0"}
[2022-11-20T22:24:24.549075+01:00] CRON.WARNING: Error (E_WARNING): “file_get_contents(/data/www/www.foo.org/htdocs_ann2/www/wp-content/cache/matomo/climulti/archive.sharedsiteids.pid): failed to open stream: No such file or directory“ at `./wp-content/plugins/matomo/app/core/CliMulti/Process.php:184`. {"class":"php","component":"PHP","version":"7.4.30","phase":"","code":2,"environment":"production","traceID":"556d501a5806c068807363d78d6a0575","instance":"005a3074ff0f"} {"siteid":1,"sitename":"MY WEBSITE","sitedomain":"www.foo.org","userid":0,"username":"anonymous","ip":"172.0.0.0"}
[2022-11-20T16:19:58.974199+01:00] WFRONT.WARNING: Error (E_WARNING): “preg_match(): Delimiter must not be alphanumeric or backslash“ at `./wp-content/plugins/matomo/app/core/UrlHelper.php:41`. {"class":"php","component":"PHP","version":"7.4.30","phase":"","code":2,"environment":"production","traceID":"9e644824abaf094881384c41f60c4044","instance":"005a3074ff0f"} {"siteid":1,"sitename":"MY WEBSITE","sitedomain":"www.foo.org","userid":0,"username":"anonymous","ip":"185.0.0.0"}
[2022-11-20T16:18:39.576916+01:00] WFRONT.WARNING: Error (E_WARNING): “mb_check_encoding(): Invalid encoding ""“ at `./wp-content/plugins/matomo/app/core/Tracker/PageUrl.php:249`. {"class":"php","component":"PHP","version":"7.4.30","phase":"","code":2,"environment":"production","traceID":"6763764606955bc9c48547265324e5f1","instance":"005a3074ff0f"} {"siteid":1,"sitename":"MY WEBSITE","sitedomain":"www.foo.org","userid":0,"username":"anonymous","ip":"185.0.0.0"}
Hi @mmokrejs
Thank you. I'm surprised that the errors are reported. Could you post again your system report please?
# Matomo
* Verze zásuvného modulu Matomo: 4.12.0
* Config existuje a je zapisovatelný.: Ano ("$abs_path/wp-content/uploads/matomo/config/config.ini.php" )
* JS Tracker existuje a je zapisovatelný.: Ano ("$abs_path/wp-content/uploads/matomo/matomo.js" )
* Adresáře zásuvných modulů: Yes ([{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins\/matomo\/plugins","webrootDirRelativeToMatomo":"..\/"},{"pluginsPathAbsolute":"$abs_path\/wp-content\/plugins","webrootDirRelativeToMatomo":"..\/..\/"}])
* Adresář Tmp zapisovatelný: Yes ($abs_path/wp-content/cache/matomo)
* Verze systému Matomo: 4.12.3
* Matomo Blog idSite: 1
* Instalační verze Matomo: 4.10.0 (Install date: 2022-08-01 16:21:10)
* 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
* Čas serveru: 2022-11-21 05:52:07
* Čas blogu: 2022-11-21 06:52:07 (Níže uvedená data jsou zobrazena v časovém pásmu blogu)
* Sync users & sites: Next run: 2022-11-21 15:22:00 (8 hours 29 min) ( Last started: 2022-11-20 15:34:50 (-15 hours 17 min). Last ended: 2022-11-20 15:34:50 (-15 hours 17 min). Interval: daily)
* Archive: Next run: 2022-11-21 07:21:13 (29 min 6s) ( Last started: 2022-11-21 06:22:38 (-29 min 29s). Last ended: 2022-11-21 06:22:50 (-29 min 17s). Interval: hourly)
* Update GeoIP DB: Next run: 2022-11-29 15:21:48 (8 days 8 hours) ( Last started: 2022-11-12 02:13:27 (-9 days 4 hours). Last ended: 2022-11-12 02:13:30 (-9 days 4 hours). Interval: matomo_monthly)
## Povinné kontroly
* PHP version >= : 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
## Nepovinné kontroly
* 64-bit PHP Binary: ok
* Tracker status: ok
* Memory limit: ok
* Time zone: ok
* Open URL: ok
* PageSpeed is turned off: ok
* GD > 2.x + FreeType (graphics): ok
* Other extensions: ok
* Other functions: ok
* Filesystem: ok
* Last Successful Archiving Completion: ok
* Database abilities: ok
* Max Packet Size: ok
* Geolocation: ok
* Update over HTTPS: ok
* [GoogleAnalyticsImporter] Required PHP Functions: ok
* [GoogleAnalyticsImporter] Required Executables (php): ok
* [GoogleAnalyticsImporter] Required Executables (nohup): ok
* Supports Async Archiving: Yes
* Location provider ID: geoip2php
* Location provider available: Yes
* Location provider working: Yes
* 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.12.0, 4.11.0, 4.10.0
* Core version: 4.12.3
* Last tracking settings update: 1662650228
* Last settings update: 1668215588
* Track content: all
* Track search: Yes
* Track user id: email
* Delete all data uninstall: No
## Logs
* Žádné:
# 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: 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: /%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/2022/11
* Custom upload_path:
* Custom upload_url_path:
* Compatible content directory: Yes
# WordPress Plugins
## MU Plugins
* DecaLog Early Loader: 3.x
## Plugins
* Akismet Anti-Spam: 5.0.1
* All in One SEO: 4.2.7.1
* All Meta Tags: 4.47
* Bing Webmaster Url Submission: 1.0.13
* Burst Statistics - Privacy-Friendly Analytics for WordPress: 1.2.3
* Classic Widgets: 0.3
* Complianz - Terms and Conditions: 1.1.3
* Complianz | GDPR/CCPA Cookie Consent: 6.3.5
* DecaLog: 3.6.2 (Network enabled)
* Device Detector: 3.3.0 (Network enabled)
* Disable & Remove Google Fonts: 1.4.7
* File Away: 3.9.9.0.1
* File Download: 1.0.2
* GD Mail Queue: 3.9.3
* Geo2 Maps Add-on for NextGEN Gallery: 2.0.6
* Give - Donation Plugin: 2.23.2
* Google Analytics Importer (Matomo Plugin): 4.2.0
* Gutenberg: 14.5.4
* Image Widget RB: 1.0.9
* IP Locator: 3.6.0 (Network enabled)
* Log HTTP Requests: 1.4
* MapPress Maps for WordPress: 2.84.15
* Matomo Analytics - Ethical Stats. Powerful Insights.: 4.12.0
* Mongoose Page Plugin: 1.8.3
* NextGEN Gallery: 3.30
* NgSurvey: 1.1.4
* Referrer Analytics: 2.0.1
* Robo Gallery: 3.2.5
* Sessions: 2.8.0 (Network enabled)
* Shared Files: 1.6.88
* Simple File List: 4.4.13
* Simple History: 3.3.1
* Simple Yearly Archive: 2.1.8
* Site Kit by Google: 1.87.0
* Smart Slider 3: 3.5.1.12
* Spiffy Calendar: 4.9.1
* Super Simple Event Calendar: 1.4.2
* The Events Calendar: 6.0.4
* Traffic: 2.8.0
* User Activity Tracking and Log: 3.3.18
* Vibes: 1.4.0
* W3 Total Cache: 2.2.7 (Network enabled)
* Widget Options: 3.8.9.1
* Wordfence Security: 7.7.1 (Network enabled)
* Wordpress File Upload: 4.16.4
* WP-Sweep: 1.1.5
* WP BackItUp Community Edition: 1.43
* WP Clone: 2.3.5
* WPCode - Insert Headers, Footers, and Code Snippets: 2.0.3
* WP Event Manager: 3.1.33
* WP File Manager: 7.1.6
* WP Mail SMTP: 3.6.1
* WP Statistics: 13.2.7
* WP System Info: 1.5
* YellowPencil: 7.5.7
* Active Plugins: 44 (GoogleAnalyticsImporter akismet all-in-one-seo-pack all-meta-tags bing-webmaster-tools burst-statistics classic-widgets complianz-gdpr complianz-terms-conditions decalog device-detector disable-remove-google-fonts facebook-page-feed-graph-api file-away gd-mail-queue give google-site-kit gutenberg image-widget-rb insert-headers-and-footers ip-locator log-http-requests matomo ngsurvey referrer-analytics robo-gallery sessions simple-history simple-yearly-archive smart-slider-3 super-simple-event-calendar the-events-calendar traffic user-activity-tracking-and-log vibes w3-total-cache widget-options wordfence wp-event-manager wp-file-manager wp-file-upload wp-statistics wp-system-info yellow-pencil-visual-theme-customizer)
* Theme: nature-bliss (nature-bliss)
# Server
* Server Info: Apache/2.4.46 (Ubuntu)
* PHP OS: Linux
* PHP Version: 7.4.30
* PHP SAPI: fpm-fcgi
* PHP Binary Name: php-fpm7.4
* PHP Error Reporting: 0 After bootstrap: 0
* PHP Found Binary: php -q
* Timezone: UTC
* WP timezone: Europe/Prague
* Locale: cs_CZ
* User Locale: en_US
* Memory Limit: 1024M (At least 128MB recommended. Depending on your traffic 256MB or more may be needed.)
* WP Memory Limit: 1024M
* WP Max Memory Limit: 1024M
* Timezone version: 0.system
* Time: 1669009927
* Max Execution Time: 35
* Max Post Size: 1024M
* Max Upload Size: 1073741824
* Max Input Vars: 1000
* Disabled PHP functions: Yes (pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority)
* zlib.output_compression is off: Yes
* Curl Version: 7.58.0, OpenSSL/1.1.1
* Suhosin installed: No
# Database
* MySQL Version: 5.5.5
* 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: 65
* DB tables exist: Yes
* Matomo users found: 5
* Matomo sites found: 1
* Požadovaná oprávnění: OK
# Browser
* Browser: (Mozilla/5.0 (X11; Linux x86_64; rv:107.0) Gecko/20100101 Firefox/107.0)
* Language: cs,sk,en-us,en
Hello @mmokrejs
Just wondering if your SQL user has the CREATE TEMPORARY TABLE permission? (In theory it should be reported in the system report, but we recently have identified there was a bug in the detection, #669, so depending on your version, the system report might not be accurate on this point). Kind regards
Mat
Hello @mmokrejs
Any chances you read my previous comment?
Kind regards
Mat
Hi @mattmary , well I did but the sysadmin did not answer. You should improve the automated installation checks to report eventual site-wide mis-configurations on your own. Please be more pro-active. Issue opened since Aug 3? Uhmm. Try to develop a test-case on your own, at first. There were enough errors to be chased down.
Hello @mmokrejs
I'm really sorry for the delay we spend to solve this issue. As I told you, I suspect that your MySQL user does not have the appropriate user rights. It should have been reported in your system report, but we identified recently a bug in this detection process which did not report all missing required grants. We have deployed a patch for this issue. Maybe you could try to update your plugin to the latest version and check if now you have a detected problem in your MySQL user rights? Please let me know, and thanks for your patience. Kind regards
Mat
Hi @mattmary , But I do have 4.13.0 installed.
BTW, please allow me to aggregate client visits based on IP address acrosse days.
Also, allow a simple resolving of their IP address and using WHOIS lookup. Why do I have to copy&paste their IP addres into my xterm and query host and whois utilities?
Hello @mmokrejs
Thank you. As your report is a bit old now, would you mind adding a recent one? Yours refers to lines which does not exist any more.
I've created a feature request in Matomo for the Whois integration: https://github.com/matomo-org/matomo/issues/20111 You may consider creating the one for the IP address aggregation: you'll be able to explicit your needs. https://github.com/matomo-org/matomo/issues/new?assignees=&labels=Enhancement%2CTo+Triage&template=feature_request.md
Kind regards
Mat
So far I see:
Fri Dec 16 17:40:59.183579 2022] [proxy_fcgi:error] [pid 7423:tid 139999503066880] [client myip:51526] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught malkusch\\lock\\exception\\TimeoutException: Timeout of 1 seconds exceeded. in /data/www/www.foo.bar/blah/wp-content/plugins/decalog/includes/libraries/lock/exception/TimeoutException.php:27\nStack trace:\n#0 /data/www/www.foo.bar/blah/wp-content/plugins/decalog/includes/libraries/lock/util/Loop.php(124): malkusch\\lock\\exception\\TimeoutException::create(1)\n#1 /data/www/www.foo.bar/blah/wp-content/plugins/decalog/includes/libraries/lock/mutex/FlockMutex.php(126): malkusch\\lock\\util\\Loop->execute(Object(Closure))\n#2 /data/www/www.foo.bar/blah/wp-content/plugins/decalog/includes/libraries/lock/mutex/FlockMutex.php(164): malkusch\\lock\\mutex\\FlockMutex->lockBusy()\n#3 /data/www/www.foo.bar/blah/wp-content/plugins/decalog/includes/libraries/lock/mutex/LockMutex.php(43): malkusch\\lock\\mutex\\FlockMutex->lock()\n#4 /data/www/www.foo.bar/blah/wp-content/plugins/vibes/i...'
The SQL database resides on a different vitual machine. I have no idea much much it is loaded but I feel the 1 sec timeout may be too short. Anyway, such errors should be rendered in the web admin interfce, anywhere. At least I have access to Apache's error_log.
The Dashboard generates for me in the error_log:
[Fri Dec 16 17:05:11.090469 2022] [proxy_fcgi:error] [pid 7423:tid 139999343605504] [client myip:45028] AH01071: Got error 'PHP message: [www.foo.bar] Error in Matomo: This user has super-user access. Embedding widgets with super-user token authentication is not allowed. Check the FAQ for more info.', referer: https://www.foo.bar/wp-content/plugins/matomo/app/index.php?module=CoreHome&action=index&idSite=1&period=range&date=last30
Please include a working URL pointing to the approriate FAQ entry. I found NONE!
Please show how you determined that the SQL user has admin rights. Include it in the error message. I doubt it is the case here but it is out of my control. I assume the current user has admin privs over the current database which does not mean it has the site-wide admin privs across all other db's, etc. Anyway, this smells like a false sanity check. What is the real problem? Having DROP privs across the tables in the current database? Or TRUNCATE privs?
Am on PHP 7.4 ad matomo 4.13.0, btw.
Hello @mmokrejs
Unfortunately, it looks like we can't do anything regarding your time-out problem: it concerns one of your others plugins and seems not related to Matomo. How did you get this timeout error? Is it related to an action in Matomo?
Regarding the missing link for the FAQ, I've created the following issue in Matomo: https://github.com/matomo-org/matomo/issues/20122. This error message is related to this FAQ: https://matomo.org/faq/troubleshooting/faq_147/. But it does not seem relevant in the WordPress plugin. Can you explain me the way you got it? A screenshot would be nice to understand this problem.
We check the grant access here: https://github.com/matomo-org/matomo-for-wordpress/blob/03db1ea2f16073c0d6a2c09b17a3953985a39b57/classes/WpMatomo/Admin/SystemReport.php#L1518-L1570 The required grant permissions for Matomo are:
- SELECT
- INSERT,
- UPDATE,
- INDEX,
- 'DELETE,
- CREATE,
- DROP,
- ALTER,
- CREATE TEMPORARY TABLES,
- LOCK TABLES,
I was thinking you may miss the create temporary tables grant, as that _logtmpsegment tables are temporary tables created during the segment archiving processes. But if you are in 4.13.0 and the system report does not report any problem with your db account, the problem may be somewhere else.
You did not report any other problems with these tables. Do you still encounter some issues during the archiving process? Do you have any irrelevant data in your segments in Matomo? Maybe it was a one shot problem?
Kind regards
Mat
Hello @mmokrejs
Without any answer, I close this issue. Feel free to open a new one if you require further assistance, happy to help. Kind regards
Mat