Import Data... Loading 99% fail. Help

I have problems when importing data. What can I do to fix it ? 99% loading.... fail :( enter image description here


Add below line at beginning of sql file

SET foreign_key_checks = 0;


SET foreign_key_checks = 1;

at the end of sql file and try to import again.

read more here MySQL – Disable Foreign Key Checks or Constraints

Tags: Database / Import

Similar questions

Save Config Fail
I'm just getting familiar with Magento after many years of using X-Cart, and after not working on my test site for a two weeks it developed a problem. None of the SAVE CONFIG buttons, or the ability to save anything for that matter, now works on the site. I successfully installed the PHP 5.4 Patch, the APPSEC-212, patch for the CMS, and the SUPEE-2...
Merge CSS and JS Files make my "add to cart" fail
after i change Merge CSS and JS Files to yes, the add to cart button is not working so the customer can not add products to the cart.
Lock wait timeout causing subsequent saves to fail
But of an odd one this, wondering if anyone else has come across it. I am running into strange behaviour when saving a number of new models in a row. If the first model fails to save due to a lock wait timeout on the database (and the exception is caught), all subsequent saves on the other models then fail even with the lock removed. There is no in...
Magento Connect Manager Connect Error: Fail to open a file
I'm using Magento Community on my Win8.1 with Apache2. I've been using Magento Connect Manager install a lot of plugins. I'm trying to install M2E Pro today and I got a problem, which is the error below: " Checking dependencies of packages Starting to download m2epro_ebay_magento-6.2.1.tgz ... ...done: 2,347,484 bytes Installing package community/m...
Orders where credit card payments fail are not showing up in orders list
My question is, if a credit card payment fails with (for instance)... does it not show in the dashboard under Sales > Orders because it failed? In other words, does the orders section only show orders that were authorized and/or captured successfully? With my old cart, the orders list would show all orders including orders that failed...
Updating stock causing foreign key constraint fail
So, I'm trying to update product quantities programmatically. On a standard magento install, it works flawlessly, but on the actual magento shop I'm developing it for, it fails with a SQLSTATE[23000]: Integrity constraint violation. It happens when I save the alterations I made on the product. The relevant bit of code, which returns the exception, ...

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.