jezkerw

I realized this can be done in a number of ways using any type of form or upload functions.

I asked ChatGTP and it says…

The error log you’re seeing indicates that your WordPress site is encountering a problem when trying to process a database query that includes regular expressions (REGEXP). The specific error message “Regex error ‘quantifier does not follow a repeatable item at offset 2′” suggests there’s an issue with how the regular expression is constructed, likely due to the input it’s trying to process.

From the context provided, it indeed appears that some bot or malicious user is trying to inject code or manipulate your site’s behavior through the search functionality. They’re attempting to use complex regular expressions within the search terms, which your WordPress site then incorporates into a database query. This type of activity is a form of attack known as SQL Injection, which aims to exploit security vulnerabilities in the database layer of an application.

Sorry my post looks a bit messed up

I am getting this regularly in my error log and I think it’s related to Ivory search somehow. Doesn’t necessarily mean it’s your plugin that is the issue, but could it simply be that some bot is just trying to add this into the search box an execute it?

[08-Mar-2024 03:44:07 UTC] WordPress database error Regex error 'quantifier does not follow a repeatable item at offset 2' for querySELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.ID
FROM wp_posts LEFT JOIN wp_term_relationships AS tr ON (wp_posts.ID = tr.object_id)
WHERE 1=1 AND (
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (792)
)
AND
wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (792)
)
) AND ( ((wp_posts.post_title REGEXP '\b試験の準備方法-実用的なMB-220|試験の準備方法-実用的なMB-220\b')) AND ((wp_posts.post_title REGEXP '\b資格模擬試験-真実的なMB-220|資格模擬試験-真実的なMB-220\b')) AND ((wp_posts.post_title REGEXP '\b認定テキスト|認定テキスト\b')) AND ((wp_posts.post_title REGEXP '\b??|??\b')) AND ((wp_posts.post_title REGEXP '\b?|?\b')) AND ((wp_posts.post_title REGEXP '\bwww.spamurl .com|www.spamurl .com\b')) AND ((wp_posts.post_title REGEXP '\b??で《|??で《\b')) AND ((wp_posts.post_title REGEXP '\bMB-220|MB-220\b')) AND ((wp_posts.post_title REGEXP '\b》を検索し、無料でダウンロードしてくださいMB-220受験対策|》を検索し、無料でダウンロードしてくださいMB-220受験対策\b'))) AND ( ( wp_posts.ID NOT IN ( SELECT wp_term_relationships.object_id FROM wp_term_relationships WHERE wp_term_relationships.term_taxonomy_id IN ( 792) ) )) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit'))
GROUP BY wp_posts.ID
ORDER BY (CASE WHEN wp_posts.post_title LIKE '%試験の準備方法-実用的なMB-220 資格模擬試験-真実的なMB-220 認定テキスト ?? ? www.goshiken.com ??で《 MB-220 》を検索し、無料でダウンロードしてくださいMB-220受験対策%' THEN 1 WHEN wp_posts.post_excerpt LIKE '%試験の準備方法-実用的なMB-220 資格模擬試験-真実的なMB-220 認定テキスト ?? ? www.spamurl .com ??で《 MB-220 》を検索し、無料でダウンロードしてくださいMB-220受験対策%' THEN 4 WHEN wp_posts.post_content LIKE '%試験の準備方法-実用的なMB-220 資格模擬試験-真実的なMB-220 認定テキスト ?? ? www.spam url.com ??で《 MB-220 》を検索し、無料でダウンロードしてくださいMB-220受験対策%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
LIMIT 0, 8
made by require('wp-blog-header.php'), wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts

• This reply was modified 7 months, 2 weeks ago by jezkerw.

So are you saying nothing is wrong at all with the way your plugin operates? Just to confirm.

Maybe I can clear selected pages based on tag/category or keyword?

Having thought about it, I actually think checking the “auto purge all pages” is the best approach here as there are several pages that do not get updated when a new game is added to the Content Views.

Would this be the best approach or do you recommend something else? ?? I guess ultimately what I was trying to do was to avoid clearing cache on pages that don’t need to be cleared.

By the way, I don’t have “auto purge” on for all pages. I only have it for the front page if that makes a difference.

Hi @qtwrk

There is no way to just enter a url somewhere in the cache plugin to instruct it to clear cache on that page when it’s updated? I dunno, it feels like I’m just going to be sent back and forth here lol.

Hi @qtwrk they responded to me:

“The cache is stored by?LSCache plugin. Our plugin doesn’t store any cache. So this is out of our?control.

The?LSCache plugin should clear its cache whenever a new post is added. Please ask their support if there is any code snippet?to clear the cache automatically whenever a new post is added.”

Hi Vinod. I forwarded your message to my developer and he said…

“Well, in theory he can be right, but he can also add some conditions to avoid the error. What he describes is correct but also a “painful” procedure.
In addition it can also be other things causing the error. In my opinion there are two ways to go…

1. Do as he says.
2. Replace the plugin with a similar one.”

Hi, I don’t think this has anything to do with other plugins. It happens on both my sites. Both developers who checked said it was bad coding in the Ivory plugin and should be patched.

I am using latest WordPress and latest PHP.

• This reply was modified 7 months, 2 weeks ago by jezkerw.

Excellent. Thank you.

Ok, nice ??

Looks perfect now! ?? Thank you