Skip to content

Instantly share code, notes, and snippets.

Set status

Felix Wolfsteller fwolfst

Set status
  • econya
  • Ecovillage Sieben Linden, Germany
View GitHub Profile
fwolfst / Magento 1.x Orphaned Records
Last active Apr 16, 2018 — forked from dfelton/Magento 1.x Orphaned Records
Deletes orphaned records from a Magento 1.x database.
View Magento 1.x Orphaned Records


The purpose of this SQL script is to clean up a Magento 1.x database by deleting orphaned records from database tables which cause foreign key contraint failures. This happens when at some point in time records where deleted from the database while FOREIGN_KEY_CHECKS = 0 and the person performing the delete operations failed to delete all related records pertaining to related tables of the primary table.

This script can be helpful when encountering foreign key constraint failures using the Data Migration Tool to migrate your

You can’t perform that action at this time.