Error: Lost connection to MySQL server during query

I recently installed the Import Export module (www.classicvintagetractors.co.uk/shop/) I was able to successfully export once, but whenever I try to do this again I get the following in Excel:

Error: Lost connection to MySQL server during query<br />Error No: 2013<br />SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `oc_url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `oc_manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `oc_weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `oc_length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `oc_product_related` pr ON pr.product_id=p.product_id LEFT JOIN `oc_product_tag` pt ON pt.product_id=p.product_id AND pt.language_id=1 GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;

I have tried altering the php.ini file, deleted explorer cache...any help would be appreciated.

Thank you.

Hi,
Even i am facing same error.If u find a solution, can u pls help me?

Same issue here....

Same issue here - v. 1.5.1.3... any one found a solution?

This comes down to your webhosts timeouts vs the size of your database call and allowed memory. Larger stores require more memory to parse the file and it times out.. not a lot can be done aside from getting a larger server or a smaller store.

This is hosted on a godaddy Virtual Dedicated Server with 3GB of RAM, linux.
the store has less than 400 products.
do I need more memory? should I upgrade MySql version from 5.1 to 5.5?

Godaddy sucks. The server may have that hardware but php.ini prolly has mem at like 8mb

Actually I'd you got root on vps just up the max memory in php.ini to like 512mb or something

I also find using php.ini files that come with oc do not work for larger stores when I update prods or feeds get read by search engines.

here is the link to the php info, any tips of what should I change besisdes the memory limit



thanks