Showing results for 
Search instead for 
Did you mean: 

Smart Label Product indexer process unknown error

Smart Label Product indexer process unknown error



I have issue like this. Can someone help me ? thank you.


[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
INSERT IGNORE INTO `smart_label_product_cl` (`entity_id`) VALUES (NEW.`smart_label_id`);

Re: Smart Label Product indexer process unknown error

Hi @luki76,


It seems you're using a paid extension (I'm not sure which one but isn't an out-of-the-box feature). Won't be better if you try to ask the vendor about the error?

If you've found one of my answers useful, please give "Kudos" or "Accept as Solution"