My webhosting provide complain about MYSQL abuse

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
muqeetsomro
Forum Newbie
Posts: 1
Joined: Tue Sep 13, 2011 10:41 am

My webhosting provide complain about MYSQL abuse

Post by muqeetsomro »

Last day I receive a mail from my webhosting provider that your account suspended due to following errors

Your Domain name *breakingnews24hrs.net* is suspended due to following reason.please contact us regarding.

** mysql abuse **

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 175 Lock_time: 1 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 174 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 169 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 169 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 175 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 170 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id = wp_posts.ID LEFT JOIN wp_postmeta As t2 ON t1.post_id = t2.post_id WHERE 1=1 AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND t1.meta_key = 'ratings_average' AND t2.meta_key = 'ratings_users' ORDER BY ratings_average desc, ratings_users desc LIMIT 0, 20;

# User@Host: muqeetsoomro[muqeetsoomro] @ localhost []

# Query_time: 169 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users FROM wp_posts LEFT JOIN wp_postmeta AS t1 ON t1.post_id =

--------------------------
  • => My site on WORDPRESS
    => I am not expert in MYSQL, so I don't know how I can fix it.
    => where is error please tell me
    => also i do not want delete data
    => while Install new MYSQL Database but with DATABASE Backup
User avatar
twinedev
Forum Regular
Posts: 984
Joined: Tue Sep 28, 2010 11:41 am
Location: Columbus, Ohio

Re: My webhosting provide complain about MYSQL abuse

Post by twinedev »

Googling the SQL, found the code in a plugin called WP-PostRatings

Either that is written poorly, or you site was getting visited heavily (had a client who'se WP site got on a list of URL for malware to overload with requests), or your site has vulnerabilities and just got hacked.

So, make sure your site and all plug ins are up to date. Check your log files for access around the time they told you about to see if you had an unusual spike in traffic to begin with. If so, try to get something in place that will try to stop attacks on your site.

Your provider said to contact them to resolve it, what did they tell you?

-Greg
Post Reply