cancel
Showing results for 
Search instead for 
Did you mean: 

Errors changing mode index

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

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 1

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