-
Notifications
You must be signed in to change notification settings - Fork 15
Description
After module installation, successful connection to allegro I'm getting 'Connection status: Active', i'm getting this error:
[2020-07-21 11:21:12] report.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.entity_id' in 'on clause', query was: SELECT
e.
entity_id,
t1.* FROM
catalog_product_entityAS
eINNER JOIN
catalog_product_entity_varcharAS
t1ON t1.entity_id = e.entity_id WHERE ((t1.value = :allegroOfferId) AND (t1.attribute_id = :attributeId)) AND (e.created_in <= 1) AND (e.updated_in > 1) {"exception":"[object] (Zend_Db_Statement_Exception(code: 42): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.entity_id' in 'on clause', query was: SELECT
e.
entity_id,
t1.* FROM
catalog_product_entityAS
eINNER JOIN
catalog_product_entity_varcharAS
t1 ON t1.entity_id = e.entity_id WHERE ((t1.value = :allegroOfferId) AND (t1.attribute_id = :attributeId)) AND (e.created_in <= 1) AND (e.updated_in > 1) at /home/web/www/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:110, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.entity_id' in 'on clause' at /home/web/www/vendor/magento/framework/DB/Statement/Pdo/Mysql.php:91)"} []
I went into db ant there is no column with that name, catalog_product_entity_varchar.entity_id, any idea where the problem can be there?
Module is set up to use MySQL MQ, and other settings as in README
and i fixed problem with error in admin by using this:
#54