alexoa Posted July 23, 2009 Report Share Posted July 23, 2009 Hallo, ich habe folgende Fehlermeldung: 1054 - Unknown column '3FXTCsid' in 'where clause' SELECT content_title FROM content_manager WHERE languages_id='2' AND content_group = 4%3FXTCsid%3Drj08o4nkstlsfpoq0c73pl7g92 [XT SQL Error] wenn ich z. B. Impressum oder Kontakt öffne Die Lösung im Thread http://www.xt-commerce.com/forum/installation-und-konfiguration/31959-1054-unknown-column-fehler.html funktioniert leider nicht. Das Feld "products_shipping_time" ist bei mir schon vorhanden und es steht auf "null". Ein Umstellen auf DEFAULT '' NOT NULL" ist leider nicht möglich, da eine Fehlermledung kommt. Wer kann mir einen Tipp geben. Danke. Alexandra Link to comment Share on other sites More sharing options...
larry69 Posted March 2, 2010 Report Share Posted March 2, 2010 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 p.group_ids LIKE '%c_1_group%' and pd.language_id = '2' and p2c.categories_id = '54' ORDER BY p.products_price ASC [XT SQL Error] Kann das mit der Umstellung auf php5 zu tun haben??? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.