Skip to content

Instantly share code, notes, and snippets.

Felix Wolfsteller fwolfst

  • econya
  • Ecovillage Sieben Linden, Germany
Block or report user

Report or block fwolfst

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@fwolfst
fwolfst / Magento 1.x Orphaned Records Cleanup.md
Last active Apr 16, 2018 — forked from dfelton/Magento 1.x Orphaned Records Cleanup.md
Deletes orphaned records from a Magento 1.x database.
View Magento 1.x Orphaned Records Cleanup.md

Purpose

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.