Skip to content

Instantly share code, notes, and snippets.

@fbrnc
Last active January 10, 2019 12:54
Show Gist options
  • Star 9 You must be signed in to star a gist
  • Fork 4 You must be signed in to fork a gist
  • Save fbrnc/7645313 to your computer and use it in GitHub Desktop.
Save fbrnc/7645313 to your computer and use it in GitHub Desktop.
Reset Magento EE changelogs
truncate catalog_product_flat_cl;
truncate catalog_category_product_index_cl;
truncate catalog_category_product_cat_cl;
truncate catalog_category_flat_cl;
truncate catalogsearch_fulltext_cl;
truncate cataloginventory_stock_status_cl;
truncate catalog_product_flat_cl;
truncate catalog_product_index_price_cl;
truncate enterprise_url_rewrite_category_cl;
truncate enterprise_url_rewrite_product_cl;
truncate enterprise_url_rewrite_redirect_cl;
--update enterprise_mview_metadata set version_id = 0;
update enterprise_mview_metadata SET version_id = 0, status = 2;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment