Hi,
Habe meinen Shop (der super lief...) heute auf die aktuellste Version von JoomShopping geupdatet und nun gibts nur noch Fehlermeldungen!
Wenn ich ein Produkt als Kunde aufrufe kommt:
1054 - Unknown column 'relation.id' in 'order clause' SQL=SELECT prod.product_id, pr_cat.category_id, prod.`name_de-DE` as name, prod.`short_description_de-DE` as short_description, prod.product_ean, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.delivery_times_id FROM `yjoaq_jshopping_products_relations` AS relation INNER JOIN `yjoaq_jshopping_products` AS prod ON relation.product_related_id = prod.product_id LEFT JOIN `yjoaq_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = relation.product_related_id LEFT JOIN `yjoaq_jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE relation.product_id = '3' AND cat.category_publish='1' AND prod.product_publish = '1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) group by prod.product_id order by relation.id
Wenn ich im Admin Bereich ein Produkt editieren will / anschauen will kommt:
1054 Unknown column 'relation.id' in 'order clause' SQL=SELECT relation.product_related_id AS product_id, prod.`name_de-DE` as name, prod.image as image FROM `yjoaq_jshopping_products_relations` AS relation LEFT JOIN `yjoaq_jshopping_products` AS prod ON prod.product_id=relation.product_related_id WHERE relation.product_id = '1' order by relation.id
Was ist da nur los?! :(
