roxer82 on "URGENT: stop searches if it has ".pl" to avoid MySql to crash"

ساخت وبلاگ

My MySql is constantly crashing because someone (or something) is accessing a lot to my site with urls like http://www.mysite.com/?s=piramidalny.pl
My error_log file says

[1-Jul-2016 18:21:19 UTC] Error Lost connection to MySQL server during query de la base de datos de WordPress para la consulta SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND (((wp_posts.post_title LIKE '%piramidalny.pl%') OR (wp_posts.post_excerpt LIKE '%piramidalny.pl%') OR (wp_posts.post_content LIKE '%piramidalny.pl%'))) AND (wp_posts.post_password = '') AND wp_posts.post_type IN ('post', 'page', 'attachment') AND (wp_posts.post_status = 'publish') ORDER BY wp_posts.post_date DESC LIMIT 0, 10 realizada por require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/iconic-one-pro/search.php'), query_posts, WP_Query->query, WP_Query->get_posts

I tried to do a redirect with htaccess

RewriteCond %{QUERY_STRING} s=(.+).pl
RewriteRule ^ /pagina.html? [R=301,L]

But even if the redirect works ok, the search is done anyway.
Do you know how to stop a search if it contains a text like ".PL"?
Thanks in advance.

WordPress ...
ما را در سایت WordPress دنبال می کنید

برچسب : نویسنده : استخدام کار wpss بازدید : 251 تاريخ : شنبه 12 تير 1395 ساعت: 10:33