Datafeedr Support Forums  

Go Back   Datafeedr Support Forums > Current Version (V3) Forum > Problems
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Important - The support forums are now in "read-only" mode as we transition to an alternative help desk solution. Feel free to contact us here with any of your questions or search the forums for an existing solution.
 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Webhost Suspended our domain name. tkh378 Problems 1 May 31st, 2011 03:26 PM
Datafeedr Plugin 0.9.95 Released Eric News & Announcements 0 April 18th, 2008 09:07 PM


All times are GMT -5. The time now is 12:56 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.