dizzyatinnocraft
Forum Replies Created
-
@thecrazy1 Did you say you modified the Installer.php file to hardcode the charset/collation you need? If so, that change will be undone when you update the plugin. Or did you overwrite the Installer.php file with the contents of the link I posted?
@thecrazy1 In the core product it is possible to set the charset/collation (this affects all Matomo tables not just the archive tables). In Matomo for WordPress that setting is overwritten and set to
$wpdb->charset
and$wpdb->collate
, so in your case setting it wouldn’t have an effect. This is done in/path/to/wordpress/wp-content/plugins/matomo/config/config.php
.In the
/path/to/wordpress/wp-content/plugins/matomo/classes/WpMatomo/Installer.php
on line 349 there should be this:$collation = $wpdb->collate ? $wpdb->collate : 'utf8mb4_general_ci';
Would you be able to check if it is there?
If it is there, can you replace the Installer.php file mentioned above with this: https://raw.githubusercontent.com/matomo-org/matomo-for-wordpress/dea1f826bc1e734846fc59d12117e9933d25117f/classes/WpMatomo/Installer.php and see if it changes anything for you?
Apologies for the overly involved steps in diagnosing the problem here, I hope it’s not too inconvenient for you.
The issue I’m encountering is that Matomo’s archive tables seem to require utf8mb4 collation.
It shouldn’t require that, it should default to what is specified by WordPress, and if not specified, it defaults to
utf8mb4_general_ci
. It looks like the charset is being detected properly (as otherwise it would try to default the charset to utf8), but for some reason the collation isn’t being detected properly.Are you using the latest Matomo for WordPress version (5.1.5)?
- This reply was modified 3 weeks ago by dizzyatinnocraft.
Hi @thecrazy1, Matomo for WordPress should use the same charset/collation that WordPress is using. Do you set the DB_CHARSET and DB_COLLATE constants in your wp-config.php? If so, can you tell me what they’re set to?
@bpahe that’s great feedback, thanks! And yes, it indeed can be a too technical process getting things working on particular hosts/webserver configs. We’re definitely aware of the need to improve that. Out of curiosity, would you be able to share what documentation helped you?
Hi @koobm, thanks for the bug report! We’ll create a fix that should be released relatively soon (days at the latest).
Hi @bpahe, thanks for the 5 star review and input! Would you be willing to tell us what you found difficult in getting started with the plugin? We’re planning on making this part of the experience easier and would love to get your input on what’s lacking.
Forum: Reviews
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] Excellent !Hi @yanartus, many thanks for the five star review!
Marking this as resolved for now. Let us know if you need any more help or have any more questions.
Hi @agrain, since there hasn’t been a response and there should be a fix for this in the latest release, I’m marking this issue as resolved. If you still have a problem or need help with something else, don’t hesitate to ask.
Yes, that’s what I suggested. I would’ve expected that to work… You may want to look in the apache error logs (the location is platform dependent, on Ubuntu based machines it should be at /var/log/apache2/error.log).
EDIT: maybe remove this line
RewriteRule ^(.*)$
. Also if you’re still using nginx, the htaccess file won’t have an effect.- This reply was modified 1 month, 2 weeks ago by dizzyatinnocraft.
@kingfisher64 I think you would need to add:
RewriteCond %{REQUEST_URI} ^.*wp-content/.*\.php$
RewriteCond %{REQUEST_URI} !/matomo/app/
RewriteRule ^(.*)$
RewriteRule ^(.*)$ - [R=403,L]right before
</IfModule>
, without removing anything.Forum: Reviews
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] GenialThanks for the clarification! We’re planning on revamping the WordPress side of things. I’ve forwarded the feedback for our core product team for consideration. If you have any other feedback, don’t hesitate to post, we’re always eager to hear it.
Forum: Reviews
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] Отличная альтернативаHi @callipso78, thanks for the fantastic review, we’re glad you find the plugin useful!
Forum: Reviews
In reply to: [Matomo Analytics - Ethical Stats. Powerful Insights.] GenialHi @grizigi, thanks for the 5 star review! When you say the interface is getting old, do you mean the WordPress side or the Reporting/Tag Manager side? (Or both?)