Skip to content

report.CRITICAL: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't1.entity_id' in 'on clause' #74

@wojmas

Description

@wojmas

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_entityASeINNER JOINcatalog_product_entity_varcharASt1ON 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: SELECTe.entity_id, t1.* FROM catalog_product_entityASeINNER JOINcatalog_product_entity_varcharASt1 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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions