jalop123j

Thanks, the issue is solved. I have exported the comments directly from the database without the images but this is enough for me.
I can not increased the memory to 512MB, it is hosting limitation.

• This reply was modified 1 month, 3 weeks ago by jalop123j.

Got them with this query:

SELECT  
TRIM(REGEXP_REPLACE(REGEXP_REPLACE( c.comment_content, '[\\t\\r\\n]', ' '), '\\s+', ' ')) AS review_content,
    cm.meta_value AS review_score,
    c.comment_date AS date,
    c.comment_post_ID AS product_id,
    c.comment_author AS display_name,
    c.comment_author_email AS email
FROM wpprefix_comments c
INNER JOIN wpprefix_posts p ON p.ID = c.comment_post_ID
INNER JOIN wpprefix_commentmeta cm ON cm.comment_id = c.comment_ID 
WHERE c.comment_approved = '1' 
AND (p.post_type = 'product') 
AND cm.meta_key ='rating'

AND (c.comment_post_ID = 9990 or c.comment_post_ID = 6416);

The cron job is running out of memory.

2024/09/19 01:07:55 [error] 1281#1281: *1388425 FastCGI sent in stderr: “PHP message: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 917504 bytes) in /www/oremcommx_742/public/wp-includes/class-wpdb.php on line 2315” “POST /wp-admin/admin-ajax.php?action=wp_1_cr_exporter&nonce=1793ce60b1 HTTP/2.0”, upstream: “fastcgi://unix:/var/run/php8.3-fpm-oremcommx.sock:”,

Can we configure smaller chunks? Is there a export query I can run directly in the database to get the export file?

HI @pear8398, export is getting stuck on “Export is in progress (5100/5911 completed)”

I’m using Aelia and it’s been working ok after 1 month of usage in production site.

Thanks. The inline width and height is created by PHP, so I’m planning to set it using CSS media queries. Two questions:

1. Would optimole take the image size based on CSS?
2. What if the image is specified as w:100% h:auto, how would optimole calculates the actual size?

Hi, I have removed the widht and height tags from the image but it is still showing up in pagespeed report.
<img src=”https://mljohmraiyvy.i.optimole.com/w:auto/h:auto/q:mauto/f:avif/https://o…&#8221; data-srcset=”” sizes=”(max-width: 360px) 330px, (max-width: 800px) 100vw, 800px” alt=”Agenda sin fechas planifesting” itemprop=”thumbnail” class=”pdp-img swiper-lazy wp-post-image swiper-lazy-loaded”>

Optimole image: https://mljohmraiyvy.i.optimole.com/w:auto/h:auto/q:mauto/f:avif/https://orem.com.mx/wp-content/uploads/2021/03/Estilo-6.jpg

Thank you!

I have confirmed from code declaration is there. Thanks you can slose this ticket.

add_action( ‘before_woocommerce_init’, function() {
if ( class_exists( \Automattic\WooCommerce\Utilities\FeaturesUtil::class ) ) {
\Automattic\WooCommerce\Utilities\FeaturesUtil::declare_compatibility( ‘custom_order_tables’, FILE, true );
}
} );

Hi, this is not a plugin, instead a Woocommerce feature that will be enabled by default by September on new installs as mentioned in the link I sent earllier.

In my store this is on already.

• This reply was modified 1 year, 7 months ago by jalop123j.

thank you for the prompt response.

https://woocommerce.com/document/high-performance-order-storage/

????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????

Is there any support?

Never mind, I understand this is a paid function.

Hello,

I don’t have other GA plugins, tag manager is only used to inject Gads conversions,GA is not configured.
Furthermore I only see this problem on some transactions, less than 10%. IE: July 31st I can see 5 orders ok, and one associated with 4 transactions.

Aug 1st – 12 transaction ok, one order id reflects 2 transactions.

Is the plugin handled to not send event when customer refresh thank you page? Before using the plugin I was using tag manager, around for 3 weeks, I never experienced duplicated transactions.

Please see images below:

https://1drv.ms/u/s!Alwja3EWw4TWt6Aff4r_JNccvtt8kQ?e=1VJFID