I'm having an issue with the Export/Import tool in one of our shops. Unfortunately the export stopped working and it only produces the following error message:
The catalog is about 2500 products big. I'm pretty sure the client put some strange characters or similiar inside a product description or similiar, but going through 2500 and checking every single one is simply not going to happen.Error: Incorrect key file for table '/tmp/#sql_2534_0.MYI'; try to repair it
Error No: 126
SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR "," ) AS categories, p.sku, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, 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_keywords, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, p.cost, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR "," ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR "," ) AS tags, GROUP_CONCAT( DISTINCT CAST(pa.attribute_id AS CHAR(11)) SEPARATOR "," ) AS attributes FROM `product` p LEFT JOIN `product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `product_to_category` pc ON p.product_id=pc.product_id LEFT JOIN `url_alias` ua ON ua.query=CONCAT('product_id=',p.product_id) LEFT JOIN `manufacturer` m ON m.manufacturer_id = p.manufacturer_id LEFT JOIN `weight_class_description` wc ON wc.weight_class_id = p.weight_class_id AND wc.language_id=1 LEFT JOIN `length_class_description` mc ON mc.length_class_id=p.length_class_id AND mc.language_id=1 LEFT JOIN `product_related` pr ON pr.product_id=p.product_id LEFT JOIN `product_tags` pt ON pt.product_id=p.product_id AND pt.language_id=1 LEFT JOIN `product_to_attribute` pa ON pa.product_id=p.product_id GROUP BY p.product_id ORDER BY p.product_id, pc.category_id;
Interesting though, the whole rest of the shop works just fine. It only effects the export.
Importing doesn't work either.
Unfortunately, JNeuhoff (author of the extension), isn't replying to any of my mails for over 2 weeks now. Not sure whats going on there.
Maybe someone out there has an idea whats wrong and can help. And yes repairing the database tables didn't do anything

Cheers,
Bjorn