Skip to content

Instantly share code, notes, and snippets.

@peterjaap

peterjaap/rowsizefix.sql

Last active December 26, 2015 14:39
Show Gist options
  • Save peterjaap/7167637 to your computer and use it in GitHub Desktop.
Save peterjaap/7167637 to your computer and use it in GitHub Desktop.
Download ZIP
Row size too large fix - replace ezbase% with your attribute code prefix
Raw
rowsizefix.sql
UPDATE catalog_eav_attribute SET is_used_for_promo_rules = 0, is_visible_on_front = 1, is_searchable = 1, is_filterable = 0, is_visible = 1, is_used_for_price_rules = 0, is_filterable_in_search = 0, used_in_product_listing = 0, used_for_sort_by = 0 WHERE attribute_id IN (SELECT attribute_id FROM eav_attribute WHERE attribute_code LIKE 'ezbase%');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment