search

akeneo / magento2-connector-community

Akeneo Connector for Magento 2
Open Software License 3.0
88 stars 90 forks source link

Error on import: 1052: Column product_id in on clause is ambiguous on setUIrlRewrite function #670

Open denniselgentos opened 11 months ago

denniselgentos commented 11 months ago

While importing products there is a error occuring on the Set Url Rewrite function:

image

In version 103.x.x it's working properly. In version 104.x.x it's not working properly.

The error is coming from: https://github.com/akeneo/magento2-connector-community/blob/master/Job/Product.php#L3671C29-L3671C55

 $productsSelect
->joinInner(
    ['pw' => $productWebsiteTable],
    '_entity_id = product_id',
    []
)
->where('website_id = ?', $store['website_id']);