Hi again.
I have issue with RSS feed in magento 2.4.1 i get following errors when clicking for New Products.
(Laminas\Feed\Writer\Exception\InvalidArgumentException): Invalid parameter: parameter must be a non-empty string
Special Products.
Exception #0 (Zend_Db_Statement_Exception): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous, query was: SELECT 1 AS `status`, `e`.`entity_id`, `e`.`attribute_set_id`, `e`.`type_id`, `e`.`created_at`, `e`.`updated_at`, `e`.`sku`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `e`.`name`, `e`.`short_description`, `e`.`description`, `e`.`price`, `e`.`thumbnail`, `e`.`special_price`, `e`.`special_to_date`, `e`.`msrp_display_actual_price_type`, `e`.`msrp`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_flat_1` AS `e`
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = '1' AND price_index.website_id = '1'
INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (final_price < price) ORDER BY `e`.`name` asc
Exception #1 (PDOException): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'price' in where clause is ambiguous
Discount /Coupons
Exception #0 (Laminas\Feed\Writer\Exception\InvalidArgumentException): Invalid parameter: parameter must be a non-empty string
I found a solution ( i guess ) but i have no idea how to implement on my site . any info would be appreciated . thanks.
