Jaro

The same issue applies for the free plugin ?? one line of code can prevent fatal error, what’s the issue to implement it?

Hello Tahmid,
I can’t replicate this issue. I’ve used the original SQL query and now it works. I tried to rollback to older version of the plugin but it still it was working fine. Maybe it’s related to given version of MariaDB. What I would suggest is to review if used COLLATE is good one for all modern emojis and used characters. As well avoid PHP fatal error on that part of the code if DB return an error.

Thank you very much for looking into it.

yes, thank you!

My bad, I didn’t realize that domain name is not enough, // must be in the beginning.

5.3.3 and I replicated it on blank website with just LS plugin. Thank you

@rbabt thank you for letting me know. I’m curious why not. If you want I can debug it, see why it happened and fix it. If you like to, please contact me via Contact us page on my website.

All the best!

Hi,
I looked at it closely and realised that the vast majority of URLs on this blacklist are non-existing images. They have been removed by us but probably there are still records in the DB. On some point, I can clean up DB but I’m too busy now. Not sure what’s the solution for storing blacklist in the wp_options. If there are few, makes sense, in our case it could be harmful. Maybe add a warning that “Your blacklist is unusually large”? Just a suggestion… ??

But there are images that are working fine and I can’t see a reason to exclude them. Please check on https://pastebin.com/WTzEhBWt

Thank you for your help!

• This reply was modified 2 years, 4 months ago by Jaro.

I don’t know, it’s been added automatically, we didn’t do it for sure.

Hi,
I’ve developed a tool and methodology of how to identify missing CSS classes. It could be a bit complex but so far it worked for everyone. Try it and let me know if it helped.

https://wpspeeddoctor.com/online-tools/litespeed-ucss-helper/

Regards,
Jaro

Hi @danieledezi
this works for me to get Cloudflare Polish work.

#set header for Cloudflare image compression
<IfModule mod_headers.c>
<FilesMatch “\.(jpg|jpeg|png|gif)$”>
Header set Vary: Accept-Encoding
</FilesMatch>
</IfModule>
#the end of set header for Cloudflare image compression

Make sure that quotes are standard ones, here are converted to left-right side
I hope that will help

• This reply was modified 2 years, 6 months ago by Jaro.

Can you provide the link you got this information that WP 6 has implemented automatic webp conversion? I can’t find it in any reference. And I’ve tested it and no webp images been generated.

Thank you

thank you very much, this is working now and the plugin did user indexes. Time to test it.

Hi, I ran this query but there is an error #1054 – Unknown column ‘user_id’ in ‘field list’
Simplified query SELECT * FROM wp_postmeta WHERE meta_key LIKE ‘wp_iufsr%’ doesn’t show any match. I think in my case it never ran.

Thank you!

I just found in debug.log this DB error

It’s a long query, starting:

Lock wait timeout exceeded; try restarting transaction. Konkrétní dotaz: INSERT INTO wp_usermeta (user_id, meta_key) SELECT user_id, meta_key FROM (SELECT a.user_id, 'wp_iufsr:administrator' meta_key
         FROM wp_usermeta a
         LEFT JOIN wp_usermeta b
                ON a.user_id = b.user_id 
               AND b.meta_key = 'wp_iufsr:administrator'
        WHERE a.meta_key = 'wp_capabilities'

And finishing with:
WHERE a.meta_key = ‘wp_capabilities’
AND a.meta_value LIKE CONCAT(‘%’, ‘advanced\\_ads\\_user’, ‘%’)
AND b.user_id IS NULL) a WHERE a.user_id >= 5999 AND a.user_id < 7999. P?íslu?ná funkce: do_action_ref_array(‘index_wp_users_for_speed_task’), WP_Hook->do_action, WP_Hook->apply_filters, IndexWpUsersForSpeed\index_wp_users_for_speed_do_task, IndexWpUsersForSpeed\Task->doTaskStep, IndexWpUsersForSpeed\PopulateMetaIndexRoles->doChunk.

Thank you, that’s probably it.