distwe65 Posted December 22, 2005 Report Share Posted December 22, 2005 Hallo, ich habe das System neu aufgesetzt (sowohl 3.0.3 als auch 3.0.4). Rufe ich in der Kategorie-?bersicht eine "End-"Kategorie (enth?lt keine weiteren Unterkategorien) auf, dann erhalte ich die Fehlermeldung: 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_discount_allowed, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '3' ORDER BY p.products_price ASC [XT SQL Error] Irgendwelche Hinweise? Danke im Voraus! ?Dirk Link to comment Share on other sites More sharing options...
distwe65 Posted December 23, 2005 Author Report Share Posted December 23, 2005 Das Problem tritt ?brigens mit MySQL 4.1.7 nicht auf (e-novative wamp) Vorher hatte ich xampp mit MySQL 5.0 getetstet. ?Dirk Link to comment Share on other sites More sharing options...
mcfly Posted December 30, 2005 Report Share Posted December 30, 2005 Den gleiche Fehler habe ich leider bei mir auch ich w?rde gerne ebenfalls erfahren wie das zu beheben ist. Was kann man da tun? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.