1054 Unknown column

[pketam2]

Hi

I installed the module without issues however when i browse the site i get error

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mgti_smile_productlabel_store.store_id' in 'where clause', query was: SELECT main_table.* FROM mgti_smile_productlabel AS main_table INNER JOIN mgti_smile_productlabel_store AS smile_productlabel_store ON main_table.product_label_id = smile_productlabel_store.product_label_id WHERE (is_active = '1') AND (mgti_smile_productlabel_store.store_id IN(1, 0)) GROUP BY main_table.product_label_id

May you please assist

Rgds Paul

[Dim3nsioneer]

same issue here. M2.4.6-p3.

[Dim3nsioneer]

found the issue in the sql statement: it uses the full table name instead of the alias in the where statement.