Thomas

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.

Thanks for the feedback @wpfan1000 very appreciated!

I can totally see what you mean. Do you have maybe some thoughts how it would have been more clear?

Generally, when you configure the tracking code and set it eg to “Default tracking” or “Tag Manager” or “Manually” then everything will be taken care of for you and you don’t need to embed any code into your site as the plugin does everything for you.

I’ve already made two tweaks to improve things a bit but be great to hear from your perspective what would help?

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?

Great to hear it’s now working @denisit71 and @nielspilon Thanks for all your help

Hi @manishvcn
thank you for clarifying. I’ve added a new feature request here: https://github.com/matomo-org/wp-matomo/issues/420 as tracking search category is a not yet implemented feature. We hope to support this feature in future.

> But anyway is there any way I can stop tracking for particular file extensions?

In WP Admin Dashboard -> Matomo Analytics -> Settings as part of the tracking settings you find an option “Define all file types for download tracking”. There you can define which ones should be tracked. Please note that this overwrites any default extension which currently are: 7z|aac|apk|arc|arj|asf|asx|avi|azw3|bin|csv|deb|dmg|doc|docx|epub|exe|flv|gif|gz|gzip|hqx|ibooks|jar|jpg|jpeg|js|mobi|mp2|mp3|mp4|mpg|mpeg|mov|movie|msi|msp|odb|odf|odg|ods|odt|ogg|ogv|pdf|phps|png|ppt|pptx|qt|qtm|ra|ram|rar|rpm|rtf|sea|sit|tar|tbz|tbz2|bz|bz2|tgz|torrent|txt|wav|wma|wmv|wpd|xls|xlsx|xml|z|zip. So you would simply remove the ones you don’t want and save that value.

I can now see that the file extensions are in the list of downloads and it’s indeed the reason why it is tracked as a download. To fix this, you would want to set the following download extension option:

7z|aac|apk|arc|arj|asf|asx|avi|azw3|bin|csv|deb|dmg|doc|docx|epub|exe|flv|gz|gzip|hqx|ibooks|jar|js|mobi|mp2|mp3|mp4|mpg|mpeg|mov|movie|msi|msp|odb|odf|odg|ods|odt|ogg|ogv|pdf|phps|ppt|pptx|qt|qtm|ra|ram|rar|rpm|rtf|sea|sit|tar|tbz|tbz2|bz|bz2|tgz|torrent|txt|wav|wma|wmv|wpd|xls|xlsx|xml|z|zip

@volkhardv thanks for sending us the email. It seems indeed related to Windows or MS IIS. Could also be related to WP Memory Limit of 40MB maybe (not sure if WordPress would assign on demand more memory should this be needed). Increasing memory might be a worth a try. And do you usually also update WordPress itself without any issues through the UI?

I’ve been trying to search for this topic and finding eg where they recommend to update manually like you’ve been doing. https://wordpress.org/support/topic/updating-wp-core-fails-on-local-install/

I’ve looked through the WordPress code how they update plugins etc and the logic is pretty much straight forward. It simply extracts the zip file and writes the new files. There isn’t anything our plugin could interfere with by the looks. I can see though that WordPress would stop extracting the zip file as soon as one file couldn’t be written or a directory couldn’t be created (in https://github.com/WordPress/WordPress/blob/5.6.1/wp-admin/includes/file.php#L1572-L1602 ).

Maybe it would help if you could somehow find out all the files it did extract when updating the plugin to see where it stopped extracting the files. Maybe it’s one particular file that it fails to extract or write to disk and then WP stops extracting any other file.

Note to myself: Related code is in https://github.com/WordPress/WordPress/blob/5.6.1/wp-admin/includes/class-wp-upgrader.php#L304-L328 and https://github.com/WordPress/WordPress/blob/5.6.1/wp-admin/includes/file.php#L1466-L1476

Hi @janerio sorry for the late reply. Could you maybe send me a link to our site either as a comment here or by email to wordpress@matomo.org ? I’d then try to debug and see if I find the issue there maybe.

Hi @kbam sorry about all that. It seems WordPress had some issue there. I’m not sure what WP is doing when they are deleting a plugin but we’re basically deleting data only when the plugin is uninstalled. Meaning for example you click on “WP Admin -> Plugins -> Select our plugin -> Uninstall”.

We do have a setting in “WP Admin Dashboard -> Matomo Analytics -> Settings -> Advanced” to not delete all data on uninstall but I’m assuming you can’t change this setting currently because you might need to reinstall it again.

If you can make changes to your wp-config.php then you could force to not delete any data by adding the following entry:

define('MATOMO_REMOVE_ALL_DATA', false);

I have generally no idea what could have caused this problem in the first place unfortunately. There could be many different issues and I’m not sure what WordPress does exactly during an update.

If you can, I would recommend to remove the files manually (wp-content/plugins/matomo) and then following the steps for option 2 in https://matomo.org/installing-matomo-for-wordpress/ . Alternatively, maybe also option 3 would work. If you can add the above entry to wp-config.php then also option 1 should safely work. In any case I would recommend to edit wp-config.php if you can.

Does this help?