Skip to content

Instantly share code, notes, and snippets.

View fwolfst's full-sized avatar
🐢
:

Felix Wolfsteller fwolfst

🐢
:
View GitHub Profile
@fwolfst
fwolfst / Magento 1.x Orphaned Records Cleanup.md
Last active April 16, 2018 11:50 — forked from dfelton/Magento 1.x Orphaned Records Cleanup.md
Deletes orphaned records from a Magento 1.x database.

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

@fwolfst
fwolfst / config_initializers_sprockets_patch.rb
Created September 20, 2023 10:58
rails initializer for sprockets patch
# Avoid a funky bug in Sprockets
# https://github.com/rails/sprockets/issues/749
# made serving files likes /assets/logos/layout-logo-compact.svg
# impossible under certain circumstances.
class MonkeyPatch🐒ObsoleteCheck < StandardError
end
CURRENT_SPROCKETS_VERSION_WITHOUT_PATCH = "4.2.1"