Jaybeeh Posted April 28, 2006 Report Share Posted April 28, 2006 Das erscheint wenn man eine Kategorie anklickt! 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_vpe, p.products_vpe_status, p.products_vpe_value, 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 = '2' ORDER BY p.products_price ASC [XT SQL Error] Link to comment Share on other sites More sharing options...
Sid Posted April 28, 2006 Report Share Posted April 28, 2006 Das Problem hab ich auch. Das liegt an der Version der Datenbank. Ich habe XAMPP auf meinem Server installiert, der eine die Datenbank MySQL Version 5.0.20 enth?lt. Damit kommt XT:Commerce nicht klar. Der braucht eine ?ltere Version, wahrscheinlich Version 4.x Hat da jemand ne L?sung? Gibt es einen Patch? Ich nutze Version 3.04 Link to comment Share on other sites More sharing options...
Sid Posted April 28, 2006 Report Share Posted April 28, 2006 Tja die L?sung ist die XAMPP Version 1.4.16 zu installieren. Eventuell bestehende Datenbanken musst du aus der phpMyAdmin-Oberfl?che nach Version 4 exportieren und dann sp?ter wenn du XAMPP 1.4.16 eingespielt hast, wieder importieren. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.