Thomas
Forum Replies Created
-
@volkhardv we still couldn’t reproduce it yet. We have tried to replicate your system based on https://wordpress.org/support/topic/mail-without-attachment-while-sending-matomo-report/#post-13350410 Maybe something changed since then (like maybe you started using a new plugin or a newer WordPress version)?
Also some plugins we couldn’t install because they weren’t found on the WP plugins directory like “real-media-library”, “us-core”, “wp-google-maps-pro”, “js_composer” and “form-maker-webhooks”. We’re testing this on a Mac though and not a Windows. It could make a difference too although might not. Is there maybe a chance you could send a zip of these plugins to wordpress@matomo.org ? Be also great to post an updated System Report in case anything changed otherwise.
Is there otherwise any chance for you to enable PHP error logging? That would likely help us.
Hi @nielspilon
thanks for your reply. It seems there is a conflict with the “sitepress-multilingual-cms” where they are using a same piece of code that we are using too but they are using a much older version.
I’m running here the latest version of the plugin and I don’t have any problem. Be great indeed to give the update a try as well to see if it resolves the issue.
@janerio any chance you can update to the version we just released and then in the WP Admin dashboard go to
Matomo Analytics -> Diagnostics -> Troubleshooting
And click on the “Archive reports” button there? Just in case it is somehow related to the bug we fixed. You could then check if reports appear or if it shows any error message.
Hi @janerio to better understand do you mind posting your system report? See https://matomo.org/faq/wordpress/how-do-i-find-and-copy-the-system-report-in-matomo-for-wordpress/ and the output should be anonymised automatically
Hi @nielspilon have you had a chance to look at my previous comment maybe?
@timherinckx I’ll mark this as resolved for now as the question is answered. If there’s any issue with it feel free to comment any time and we’ll be happy to help.
Hi @volkhardv thanks for bringing this up. We’ve been able to reproduce this and we’ll release an update fixing this issue very soon. In the meantime you can ignore these logs because it’s actually expected this query to sometimes fail and it generally won’t cause any issue.
Hi @janerio thanks for bringing this up. We’ve been able to reproduce this and we’ll release an update fixing this issue very soon. In the meantime you can ignore these logs because it’s actually expected this query to sometimes fail and it generally won’t cause any issue.
Hi @tim-reeves thanks for your patience and your help. We were finally able to reproduce this and are releasing an update with a fix soon. You can then remove the added setting again. Basically, it looked like there was an error but it was basically expected that this query might sometimes fail as we’re trying to detect if the table exists or not. WordPress would then “falsely” log the query failed even when we expected it to fail. We’ve now applied a fix again that will detect this particular query and it should be all good in the future. Thanks for your help again and be great to let us know in case it still happens after the update. All the best, Thomas
Hi @tim-reeves thanks for detailed analysis so far.
The table is generated in https://github.com/matomo-org/wp-matomo/blob/develop/app/core/DataAccess/LogAggregator.php#L292 (this seems to succeed). It’s a temporary table. From the error message I can unfortunately not tell where the query is being executed as the query is not fully visible and different plugins within the Matomo plugin may execute such a query. If I had to guess I would say that it looks like some plugin or somehow the WP DB connection is closed at some point and then reconnected or so. That be so far the only way I could explain this. That’s because it looks like the temporary table is created, but doesn’t exist later. Temporary tables only exists for one specific DB connection. Meaning if a new DB connection is created at some point, the table will be no longer there.
There would be a workaround to disable using this table. You could edit the file
wp-content/uploads/matomo/config/config.ini.phpand as part of the[General]section add a new line sayingenable_segments_cache = 0. The next time it should work if you could try this?The system report looks otherwise all good and couldn’t find anything yet that could cause this otherwise. Sorry about all the trouble @tim-reeves
Hi @timherinckx if you have enabled the plugin, then you would find it in the Matomo Admin UI under “System -> Invalidate Reports”.
You can get to the Matomo Admin UI by clicking in the WP Admin Dashboard on “Matomo Analytics -> Matomo Reporting” and then click on the cog icon in the top right.
Does this help @timherinckx ?
Hi @volkhardv I’m afraid an online-session will likely not help all that much as I will need a way to regularly reproduce this to get to the bottom of the problem. I’m still trying to reproduce this here but it’s quite difficult because of always needing to reset the database etc. I’ll keep you updated. If you can otherwise somehow enable PHP error logging (eg in your php.ini or your webhoster config) then this would likely show us the error directly in the php error log but this might not be easily doable.
Great, thanks @nam1962 our email is wordpress@matomo.org
@nam1962 I suppose the Matomo instance you used to have is no longer active to compare if it was much faster there? Just wondering if the server is the issue maybe. For example if it has a very slow disk it could maybe explain it.
Is there otherwise any chance to access the files on your server where your Matomo is installed so I could try and find out why it’s so slow?
I noticed it seems a bit faster now like less than 2s instead of last time 5s but of course that’s still fairly slow and it shouldn’t take that long.
Glad it works now @brandondove 🙂