Plugin Author
Thomas
(@tsteur)
Hi @wpfan1000
these other reports are being generated in the background approx once per hour (but depending on your traffic or how often your WP Cron is being executed it may take longer).
I’m assuming that the reports should become available say in the next hour or so. could you check if that’s the case?
Hi @tsteur,
Thanks again for the quick support.
I will let you know what happens.
I am getting:
WP DB Error: [1044] Access denied for user ‘wp_reviseelbow’@’localhost’ to database ‘wp_reviseelbow’ SQL: CREATE TEMPORARY TABLE wp_matomo_logtmpsegment322aaec665fed9a1bc24ffdc3b1fa124 (idvisit BIGINT(10) UNSIGNED NOT NULL, PRIMARY KEY (idvisit))
Presumably because this is a disposable test site not under my ownership…..
So this may affect me getting reports….
Plugin Author
Thomas
(@tsteur)
Hi @wpfan1000 unfortunately our plugin actually requires the MySQL permission to create temporary tables.
There is one workaround available though if you are familiar editing files in your WordPress. You would need to change the file wp-content/uploads/matomo/config/config.ini.php and add the following line:
enable_segments_cache = 0
below the line that says [General]. So it would look like this:
[General]
enable_segments_cache = 0
I’m sorry this is a bit complicated. It’s really only a workaround and usually this permission is always granted and it’s not an issue. Things would still work after adding this but generating reports can be a bit slower under circumstances if you have a lot of visitors on your website.
Hi Thomas,
Thanks for the support.
This is entirely not your plugin’s fault.
I should have explained more but when I said earlier that this is disposable test site not under my ownership – I meant a disposable test site at tastewp.com.
There you can create sandboxed test sites and they are not exactly like running a normal WordPress site and so there will be eg permission issues. And there is no way to access files.
But any problems are due to me using this site, not the plugin’s fault.
Hi, I setup Matomo in a full WordPress site that I control, (Not a sandboxed test site like above) so that there would be no issues with permissions.
I then let Geopeeker take a look at the site about 7 hours ago which creates visits.
The visits are recorded in the plugin’s Dashboard:
Visits in Real-time
Date
Visits
Actions
Last 24 hours 6 6
But all other reports say zero or No data, eg:
Visits Overview
0 visits, 0 unique visitors
0s average visit duration
0% visits have bounced (left the website after one page)
0 actions (page views, downloads, outlinks and internal site searches) per visit
0 max actions in one visit
0 pageviews, 0 unique pageviews
0 total searches on your website, 0 unique keywords
0 downloads, 0 unique downloads
0 outlinks, 0 unique outlinks
You mentioned above it should take an hour for data to appear in other parts of the plugin but it hasnt.
Please help.
Plugin Author
Thomas
(@tsteur)
Hi @wpfan1000
could you check the system report (see https://matomo.org/faq/wordpress/how-do-i-find-and-copy-the-system-report-in-matomo-for-wordpress/ how to access it) if there is any entry under the “Matomo” category and then the section “Logs”? If there is an error it should also show it at the very top of the system report additionally.
Additionally, on the same page as the system report there is a second tab called “Troubleshooting”. Can you go to this page and click on the first report which says “Archive reports”? Do the reports appear afterwards or is maybe any error shown?
Thanks for this @wpfan1000
