cancel
Showing results for 
Search instead for 
Did you mean: 

Smart Label Product indexer process unknown error

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

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

Smart Label Product indexer process unknown error

Hello,

 

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

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?