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
