Errors nur Fehler nach Update

22.10.2014 11:24
#1
Fischwaage
Joomshopping forum user no avatar
Name: Gelord
03.04.2014
Posts: 87
Quote
Errors nur Fehler nach Update

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?! :(

 
22.10.2014 12:06
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16494
Quote
Aw: Errors nur Fehler nach Update

http://www.webdesigner-profi.de/joomla-webdesign/joomla-shop/forum/posts/7/286.html?lang=en#3

 
Copyrights MAXXmarketing GmbH. All Rights Reserved