View Single Post
  #1  
Old October 9th, 2011, 10:26 AM
LimitlessMktg LimitlessMktg is offline
 
Join Date: Sep 2011
Posts: 60
Default Datafeedr Plugin - Site Suspended...

Hostgator suspended one of my websites last night due to datafeedr plugin affecting the server.

Here is the snippet that I got from them showing the offending code:



The following query is the issue and you may need to present this information in order for the plugin creator/maintainer to resolve this issue.

mysql> explain SELECT DISTINCT wp_dfr_shop_products.* FROM wp_dfr_shop_products INNER JOIN wp_dfr_shop_p2c ON wp_dfr_shop_products.id=wp_dfr_shop_p2c.id WHERE wp_dfr_shop_p2c.cat_id IN(663390) AND (wp_dfr_shop_products.state=1) ORDER BY wp_dfr_shop_products.name ASC LIMIT 0, 3;
+----+-------------+----------------------+--------+---------------+---------+---------+----------------------------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------------------+--------+---------------+---------+---------+----------------------------------------------+------+----------------------------------------------+
| 1 | SIMPLE | wp_dfr_shop_products | ALL | PRIMARY | NULL | NULL | NULL | 6554 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | wp_dfr_shop_p2c | eq_ref | PRIMARY | PRIMARY | 12 | hallowee_wrdp1.wp_dfr_shop_products.id,const | 1 | Using index; Distinct |
+----+-------------+----------------------+--------+---------------+---------+---------+----------------------------------------------+------+----------------------------------------------+
2 rows in set (0.00 sec)




Plugin Version is:3.3.3583

Approximately 5700 products in the store.

Last edited by LimitlessMktg : October 9th, 2011 at 10:29 AM.