- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2016
02:10 PM
04-12-2016
02:10 PM
Errors changing mode index
Hi all,
we are experiencing an issue while trying to update our indexer modes.
$ php bin/magento indexer:set-mode schedule catalog_product_attribute Product EAV indexer process unknown error: Table catalog_product_attribute_cl already exist $ php bin/magento indexer:set-mode schedule catalog_product_flat catalog_category_flat catalog_category_product catalog_product_category Product Flat Data indexer process unknown error: Table catalog_product_flat_cl already exist Category Flat Data indexer process unknown error: SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable), query was: DROP TRIGGER IF EXISTS `trg_catalog_category_entity_after_insert` Category Products indexer process unknown error: Table catalog_category_product_cl already exist Product Categories indexer process unknown error: Table catalog_product_category_cl already exist
This is our indexs settings:
$ php bin/magento indexer:show-mode Customer Grid: Update by Schedule Product Flat Data: Update on Save Category Flat Data: Update on Save Category Products: Update on Save Product Categories: Update on Save Product Price: Update on Save Product EAV: Update on Save Stock: Update on Save Catalog Search: Update on Save Catalog Rule Product: Update on Save Catalog Product Rule: Update on Save
Could you help, please?
Many Thanks
Labels:
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2016
08:00 PM
04-12-2016
08:00 PM
Re: Errors changing mode index
How to fix the «You do not have the SUPER privilege and binary logging is enabled» issue? https://mage2.pro/t/1224