hungpham

Thanks for the answer. Actually, it’s from WooCommerce in my cookie report

Initiator: Script tag, page source line number 1363
Source: https://mydomain.com/wp-content/plugins/woocommerce/assets/js/sourcebuster/sourcebuster.min.js?ver=9.3.3

Now I found this page, confirming it’s WooCommerce cookies. You might want to update the cookies page.

Thanks for suggestion. The object cache is running. But there is a failed setting with Store Transients when wp-admin cache is off. Correcting it, the wp-admin is faster now.

About Yoast, not sure if the reason is Store Transients also, but tried to monitor again, I didn’t see that request. Will monitor a few more times.

Thanks again.

Thanks for answering. The troubleshooting steps… no problem with any of that.

Anyway, there is no more error in the last few days. I am not sure if it’s a temporary issue on Facebook’s side, or something else. Will keep checking in the next few more days. Hopefully there is no more error like that.

In case of shared hosting, you will need to contact your hosting provider. cPanel doesn’t provide log for MySQL or MariaDB.

It’s happening before the plugin tries to add new keys. You might want to repair the table first, for example, with phpMyAdmin

Thanks a lot for the info. I forgot to check the MariaDB optimization. Have increased innodb_buffer_pool_size and turned on Redis. Let’s see if the performance is better ??

Thanks again.

Sorry, missed this. The post 4443 doesn’t have many downloads. But I just added an index to post_id and it seems help. No more long time query from sdm_downloads table. Thanks a lot.

The reason of select all is because the site owner wants to show the total downloads.

Now, there are several long time queries related to postmeta table. Can you take a look at the new upload, please?

Thank you.

Sth likes this

domain.com/?gl=12kx3m8sdm_upMQ.._gaJ8SHI1MTk3M08Ni4xNzESSDk2ODE3_ga_HSHWJYUSG*MTcxMDQ59SKJH4xSHJ72MTcxMDQ5NjgxNi4wshj28jMA..

• This reply was modified 8 months, 1 week ago by hungpham.
• This reply was modified 8 months, 1 week ago by hungpham.

Just wanted to mention that even with the first party cookies, if the cookies are not necessary for website function, it still requires consent. This order attribution tracking is an add-on, I think, it’s not strictly necessary for the website, so it should be blocked before visitors give consent.

Pref. link here

Huge JS? I don’t think so. Browser cache shows 3 files: 119 kB, 102 kB and 150 kB. From other domains, yes, from Google Tag Manager and Facebook. No more.

There is no error. And your code is clearly using subtotal, which is the revenue already. That’s why the item price in purchase event is incorrectly. Here is the code I copy from src/Google/GoogleiteTag.php

foreach ( $order->get_items() as $item_id => $item ) {
$product_id = $item->get_product_id();
$product_name = $item->get_name();
$quantity = $item->get_quantity();
$price = $item->get_subtotal();
$item_info [] = sprintf(
‘{
id: “gla_%s”,
price: %f,
google_business_vertical: “retail”,
name: “%s”,
quantity: %d,
}’,
esc_js( $product_id ),
$price,
esc_js( $product_name ),
$quantity,
);
}

Can you check with your developer why they use get_subtotal() function there?

Great. Thanks for answering and info ??

Any update on this?

Thanks.

Yes, I am using the latest version 4.1.8. Thank you.