Smart Label Product indexer process unknown error


#1

Hello,

I use Magento 2.1.7 from Template Monster. I have issue “Smart Label Product indexer process unknown error”

[master_bzxmyuncyj]:public_html$ php bin/magento indexer:info
design_config_grid Design Config Grid
customer_grid Customer Grid
catalog_product_flat Product Flat Data
catalog_category_flat Category Flat Data
catalog_category_product Category Products
catalog_product_category Product Categories
catalog_product_price Product Price
catalog_product_attribute Product EAV
cataloginventory_stock Stock
catalogrule_rule Catalog Rule Product
catalogrule_product Catalog Product Rule
catalogsearch_fulltext Catalog Search
smart_label_product Smart Label Product
smart_product_label Smart Product Label

[master_bzxmyuncyj]:public_html$ php bin/magento indexer:status smart_label_product
Smart Label Product: Ready

[master_bzxmyuncyj]:public_html$ php bin/magento indexer:show-mode
Design Config Grid: Update by Schedule
Customer Grid: Update by Schedule
Product Flat Data: Update by Schedule
Category Flat Data: Update by Schedule
Category Products: Update by Schedule
Product Categories: Update by Schedule
Product Price: Update by Schedule
Product EAV: Update by Schedule
Stock: Update by Schedule
Catalog Rule Product: Update by Schedule
Catalog Product Rule: Update by Schedule
Catalog Search: Update by Schedule
Smart Label Product: Update on Save
Smart Product Label: Update by Schedule

[master_bzxmyuncyj]:public_html$ php bin/magento indexer:set-mode schedule smart_label_product
Smart Label Product indexer process unknown error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘smart_label_id’ in ‘NEW’, query was: CREATE TRIGGER trg_smart_label_rule_product_after_insert AFTER INSERT ON smart_label_rule_product FOR EACH ROW
BEGIN
INSERT IGNORE INTO smart_label_product_cl (entity_id) VALUES (NEW.smart_label_id);
END

any ideas?

thank you
Luke