carly Posted December 17, 2008 Report Share Posted December 17, 2008 hallo, ich habe ein problemm, und zwar wenn ich auf meinen neue artikel button klicke bekommen ich immer diese meldeung 1054 - Unknown column 'p.manufacturers_id' in 'on clause' select distinct p.products_id, p.products_fsk18, pd.products_name, pd.products_short_description, p.products_image, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p, categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' and p.products_date_added > '2008.12.02' order by p.products_date_added DESC kann mir vielleicht jemand sagen was das zu bedeuten hat, zum anschauen einfach auf www.ebook-infos.de klicken und dann auf neue artikel dann kommt der fehler, thanks carly Link to comment Share on other sites More sharing options...
carly Posted December 30, 2008 Author Report Share Posted December 30, 2008 schade das mir bei diesem problemm keiner helfen kann :confused: carly Link to comment Share on other sites More sharing options...
Saladin Posted February 22, 2011 Report Share Posted February 22, 2011 1054 - Unknown column 'p.manufacturers_id' in 'on clause' select distinct p.products_id, p.products_fsk18, pd.products_name, pd.products_short_description, p.products_image, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p, categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '2' where c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' and p.products_date_added > '2010.11.24' order by p.products_date_added DESC [XT SQL Error] Link to comment Share on other sites More sharing options...
Saladin Posted February 22, 2011 Report Share Posted February 22, 2011 Ich habe das selbe Problem in der default.php beseitigt und auch in der adavanced_search_result.php wie in folgender Anleitung http://www.xt-commerce.com/forum/installation-und-konfiguration/33817-sql-error.html Jetzt besteht das Problem aber noch in der new_products.php, gibts jemanden der da was machen kann? Link to comment Share on other sites More sharing options...
Saladin Posted February 22, 2011 Report Share Posted February 22, 2011 Das ist der richtige Link http://www.xt-commerce.com/forum/allgemeine-diskussionen/48052-error-1054-hier-eine-allroundl-sung-gefunden-13.html Viel Erfolg, wenn hier jemand weiß wie ich das für die new_products.php anwende bitte melden... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.