nfdieter Posted June 26, 2006 Report Share Posted June 26, 2006 NAchdem ich die anderen Fehlermeldungen jetzt weg habe, kommt bei Aufruf einer Kategorie folgender Fehler: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total 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 = '2' ORDER BY pd.products_name DESC [XT SQL Error] Der erscheint nur bei einer Kategorie, nicht im Katalog bei Artikeln, da funkt. alles! Auch eine Bestellung! Schon mal Danke Dieter Link to comment Share on other sites More sharing options...
nfdieter Posted June 26, 2006 Author Report Share Posted June 26, 2006 Datenbank MySQL 5.0.22-Debian_1.dotdeb.1 Link to comment Share on other sites More sharing options...
nfdieter Posted June 27, 2006 Author Report Share Posted June 27, 2006 ok, habs gefunden... wohl erst die Version 3.04 SP2 ist kompatibel mit MYSQL 5 ??????? Link to comment Share on other sites More sharing options...
74deluxe Posted June 28, 2006 Report Share Posted June 28, 2006 <div class='quotetop'>QUOTE(nfdieter @ Jun 26 2006, 03:57 PM) Quoted post</div><div class='quotemain'> NAchdem ich die anderen Fehlermeldungen jetzt weg habe, kommt bei Aufruf einer Kategorie folgender Fehler: 1054 - Unknown column 'p.products_id' in 'on clause' select count(p.products_id) as total 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 = '2' ORDER BY pd.products_name DESC [XT SQL Error] Der erscheint nur bei einer Kategorie, nicht im Katalog bei Artikeln, da funkt. alles! Auch eine Bestellung! Schon mal Danke Dieter Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.