Critical error (wp-admin/admin.php?page=matomo-reporting&goto=matomo-admin)

Hi,

This might be the same issue as https://github.com/matomo-org/wp-matomo/issues/78

Matomo requires the CREATE TEMPORARY TABLES MySQL permission and doesn’t yet have a proper error message when it is missing.

Have tried CREATE TEMPORARY TABLE XX –> no error message. It seems that I have the permission to do that

@knut2

Thanks for creating the issue!

Is there any chance you could paste the anonymised system report here or email it to us to wordpress at matomo.org ?

See
https://matomo.org/faq/wordpress/i-have-a-problem-how-do-i-troubleshoot-and-enable-wp_debug/

You will probably need to add this to your wp-config.php:

define( 'MATOMO_SAFE_MODE', true );

In order to avoid above error you are currently getting.

It seems like that Matomo config is maybe not loaded cause it should not use that Zend DB but WordPress DB.

Do you get this error directly after activating the plugin @knut2 ? Do you know if you see in the WordPress Dashboard the Matomo Analytics menu item?

@knut2 I’m trying some changes that might help. Just in case you are familiar with FTP or uploading files onto your server you could try and download https://github.com/matomo-org/wp-matomo/archive/updateinstalldb.zip then extract the files, and then upload these files into /customers/0/5/0/atactic.be/httpd.www/wp-content/plugins/matomo/

Now also seeing this path: /customers/0/5/0/atactic.be/httpd.www/matomo/libs/Zend/Db/Adapter/Mysqli.php in your comment. Is there a chance you already have Matomo On-Premise running on your WordPress server?

@tsteur Thanks for your quick reply.
You’re right, Matomo On-Premise is already running on my WordPress server, but it uses its own database (so I thought there was no links between the plugin and previously installed Matomo. Maybe I was wrong)

I have no access to https://github.com/matomo-org/wp-matomo/archive/updateinstalldb.zip (it seems that no “archive” folder exists), so I haven’t tried your proposal. Could you send me a new url to download the updateinstalldb.zip file ? Thanks

@tsteur I see the Matomo Analytics menu item in the WordPress Dashboard.
Some (very few) functionalities seems to work (“Get started”, “Access”)

Sorry about that. Could you try https://github.com/matomo-org/wp-matomo/archive/develop.zip ?

@tsteur After having uploaded/unzip, still not working.
I have sent the system report by email.

Thanks, I’ll have a look at the system report later and try to reproduce. I’d be curious to see if it works for you if you temporarily disable WP-Piwik/WP-Matomo.

While Matomo On-Premise has a separate DB, it seems to be loading the files from your Matomo On-Premise installation partially which may be due to WP-Piwik but not sure yet. I’ll try to find out more.

@tsteur Having disabled WP-Matomo, seems to be working ! I’m investigating further…

If I had to guess… from what I can see is that for example WP-Matomo is trying to extend the WordPress ToolBar to show some stats. This can be enabled in WP-Matomo in the “Show Statistics” tab. If then for example also the PHP API is configured, then WP-Matomo would bootstrap your regular Matomo On-Premise installation as part of every request when you are logged in.

You could likely create a user with a Matomo Super User role for example, and this error might not happen if that user is not allowed to view statistics as configured in WP-Matomo.

This is just a thought so far. Might be worth giving it a try. Generally, when you have Matomo for WordPress installed there should be no need to also use WP-Matomo.

It might even help in WP-Matomo in the “Connect to Matomo” tab to select for example “Self hosted HTTP API”. Can you confirm you have PHP configured in “Connect to Matomo: Matomo Mode”?

@knut2 I was able to reproduce it that way. Installed WP-Matomo, Configured PHP mode, enabled WordPress toolbar. Then WP-Matomo was loading the other Matomo and this causes issues. I have changed our system report to hopefully detect this use case in the future and show a warning right away. Be great if you could double check and confirm this behaviour and ideally mark the support thread as resolved. Hoping this helps.

@tsteur I confirm that disabling WP-Matomo solves the problem. On my side, enabling WordPress toolbar statistics does not have any influence.
So, many thanks for your help.