Post by bmett » Tue Apr 05, 2011 1:15 pm

Hi everyone,

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:
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;
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.
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
Last edited by bmett on Mon Oct 10, 2011 2:25 pm, edited 1 time in total.

Newbie

Posts

Joined
Fri Sep 17, 2010 1:07 pm

Post by SXGuy » Tue Apr 05, 2011 3:23 pm

yes you are probably right, it probably is a strange char somewhere, this happend to me during importing my database, messed everything up, had to recover an old export.

I think the char that messed it up for me was " - " but i cant remember.

Best advise i can give, would be to export your database using phpmyadmin or something, then open the file in Notepad++ and do a search for any strange chars you can think of.

Active Member

Posts

Joined
Sun Nov 08, 2009 2:07 am

Post by bmett » Wed Apr 06, 2011 9:27 am

Thanks SXGuy,

I'll definitely try your suggestions, but I'm not that confident. The client has huge product descriptions etc, but hey maybe I'm lucky and I'll find something.

I'm more pissed (excuse my English) about the fact that the authoer (JNeuhoff) isn't replying to mails at all. Really annoying. >:(

Cheers,
Bjorn

Newbie

Posts

Joined
Fri Sep 17, 2010 1:07 pm

Post by bmett » Mon Oct 10, 2011 2:25 pm

Hi everyone,
I know, old thread, but I finally found a solution for above issue, so I thought I'd share it:

The issue results out not having enough space in the tmp folder. On cPanel servers, the TMP folder is by default not very big (512MB) which caused the above issue. Our TMP folder was to 88% full and since MySQL uses this folder too (unless you have MySQL configured otherwise) there was not enough space in the TMP folder.

Cleaning out the TMP folder or giving the partition more space solved the issue.

Hope that this maybe helps someone with the same problem.

Cheers,
Bjorn

Newbie

Posts

Joined
Fri Sep 17, 2010 1:07 pm
Who is online

Users browsing this forum: No registered users and 2 guests