Magento 2.2.4

[Darren 2]

With the release of Magento Community Edition 2.2.4 this week, I would like to check if any testing has been done either by M2e or users who have installed the upgrade.

Any known issues so far?

[mat 0]

I'm getting this SQL error on Ebay settings screen.

Clean install 2.2.4, no migration done yet.

Fatal error occurred: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'count' in 'having clause', query was: SELECT `main_table`.`attribute_id` FROM `eav_attribute` AS `main_table` INNER JOIN `catalog_eav_attribute` AS `additional_table` ON additional_table.attribute_id = main_table.attribute_id INNER JOIN `eav_entity_attribute` AS `entity_attribute` ON entity_attribute.attribute_id = main_table.attribute_id WHERE (main_table.entity_type_id = 4) AND (`attribute_code` != 'quantity_and_stock_status') AND (`additional_table`.`is_visible` = '1') AND (entity_attribute.attribute_set_id IN (4)) GROUP BY `entity_attribute`.`attribute_id` HAVING (count = 1)".

 

[mat 0]

Extension is not working in 2.2.4. Amazon settings wizard stuck in step 2. Nothing to edit there.

Waiting for update now.

[Darren 2]

Thanks for the info mat. The m2e extension is excellent, it is just a shame they don't seem to do any testing with new versions of Magento, just wait until someone installs it and it doesn't work.

[SamBGB 0]

For anyone thats still having this issue here is the response I got from m2epro support.

Thank you for contacting M2E Pro Support Team.

 

The error is related to Magento functionality. It is a known Magento issue in versions under 2.2.0:

 

https://github.com/magento/magento2/issues/8721

https://github.com/magento/magento2/issues/9634

 

However, it should be fixed in the latest Magento versions (<2.2.0). And it was in the versions under 2.2.4. Our developers noticed, that for some reason, the code from versions 2.1.x is implemented in the version 2.2.4. Please see the solution below.

 

Change the contents of this method in the file:

 

vendor/magento/module-eav/Model/ResourceModel/Entity/Attribute/Collection.php

setInAllAttributeSetsFilter ()

 

This code should be:

https://github.com/pepe1518/magento2/blob/master/vendor/magento/module-eav/Model/ResourceModel/Entity/Attribute/Collection.php

setInAllAttributeSetsFilter ()