Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
wojmas opened this issue Jul 21, 2020 · 0 comments

Comments

@wojmas
Copy link

wojmas commented Jul 21, 2020

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant