_Jo

Thanks for your reply, @emermatomo – I can only work on this in my free time (weekend) and will take a look at your links.

——

Can you please ty to check if you are able to access any other private pages on your wordpress site with the application password. That could confirm if its an issue with the authentication or something specific with Matomo.

I’m not sure what to access, as there is nothing similar to this. (No problems with WP data). I’m happy to test other stuff though, if you maybe can give me a hint.

Here’s the code I use for testing (PHP/Curl) – sensitive data removed:

<?php

include('/___________/wp-load.php');

$ch = curl_init();

$username = '________';
$application_password = '____ ____ ____ _____ _____';


$url = 'https://www.________.com/index.php?rest_route=/matomo/v1/api/processed_report';
 
$dataArray = [
'period' => 'day',
'date' => 'today',
'filter_limit' => 50,
'apiModule' => 'Actions',
'apiAction' => 'getPageUrls',
'flat' => 1
];

$data = http_build_query($dataArray);

$getUrl = $url."&".$data;

curl_setopt($ch, CURLOPT_USERPWD, $username.':'.$application_password);
curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, TRUE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_URL, $getUrl);
curl_setopt($ch, CURLOPT_TIMEOUT, 80);

$response = curl_exec($ch);

if(curl_error($ch)){
    echo 'Request Error:' . curl_error($ch);
} else {
    //echo $response."\n\n";
    $responsearray = json_decode($response);
}

curl_close($ch);

echo '<pre>';
print_r($responsearray);
echo '</pre>';

?>

additional heads up:
with the update (and reactivation) my GA tracking ID was not there anymore. I had dual tracking enabled (GA3 + GA4) and the GA4 ID showed up when I entered the normal one. no tracking for that hour or so, not sure if there’s a bug or not.

Okay, I made a backup of the file and uploaded your new cache.php file to the server.

Saving/Updating a post has gone down from almost 2 minutes to the normal 5-6 seconds. Related posts seem to still work as well.

Thank you very much!

I’ll keep an eye on it for a few days more, but I’m very happy right now!

Thanks!
I’ll try the cache.php first and will report back.

(And yes, lots of posts, probably more than your average plugin user)

Thanks for your reply!

—

MySQL is 5.7.30 but the cache is the default of

innodb ft result cache limit 2,?000,?000,?000

So I’ll keep that in mind if it happens again, thank you!

—

I completely missed that word limit, duh! I’ll have to experiment with that.

—

What I did try though was to completely remove every quotation mark from the text. That worked wonders and the error didn’t show up.

Original:
320 words | 1,714 characters | 38 times ” (quotation mark)
load time preview 38s | DB error and no related posts

Without quotation marks:
load time 13s | no DB error and related posts

Not sure if is only a problem with the ” or if it affects DB requests with all masked entities.

Thanks again & I hope this was a little bit helpful for you as well!
Jo