cancel
Showing results for 
Search instead for 
Did you mean: 

Errors changing mode index

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

1 REPLY

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