Antwort #4 am: 04. Dezember 2019, 16:51:46
Hallo,
ich habe versucht den Code in meinen 1.06 Shop einzubauen. Der Eintrag Hersteller wird auch im Drop Down angezeigt. Aber ich bekomme diesen SQL-Fehler angezeigt wenn ich die Sortieren einem Artikel zuweise:
1054 - UNKNOWN COLUMN 'm.manufacturers_name' IN 'order clause'
-- /includes/modules/default.php SELECT p.products_manufacturers_model, p.products_id, p.products_ean, p.products_quantity, p.products_shippingtime, p.products_model, p.products_zusatz_info, p.products_video_1, p.products_video_2, p.products_video_3, p.products_image, p.products_price, p.products_discount_allowed, p.products_weight, p.products_tax_class_id, p.manufacturers_id, p.products_fsk18, p.products_vpe, p.products_vpe_status, p.products_vpe_value, pd.products_name, pd.products_description, pd.products_short_description FROM products_description pd JOIN products p JOIN products_to_categories p2c on p2c.products_id = pd.products_id WHERE p.products_status = '1' AND p.products_id = pd.products_id AND pd.language_id = '2' AND p2c.categories_id = '449' ORDER BY m.manufacturers_name ASC
[MOD SQL Error]
Gruß und danke im voraus
Andreas