sunscreen Posted January 26, 2006 Report Share Posted January 26, 2006 Hallo zusammen, bin hier noch relativ neu und habe soweit alle Installationsh?rden genommen... Meine Umgebung: Xampp, lokal, V3.04 SP1 Ich habe folgende Fehlermeldung aus dem Hersteller-Pull-Down: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join specials s on p.products_id = s.products_id ' at line 20 select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, manufacturers m, products p, left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '2' Gibt es dazu auch ein ?hnliches Bugfix wie zum Fehler 1054??? Vielen Dank im Voraus... Greez sunscreen Link to comment Share on other sites More sharing options...
sunscreen Posted January 26, 2006 Author Report Share Posted January 26, 2006 Hi, ich m?chte ja nicht dr?ngeln, aber ist das Thema gar so heikel, dass ich ja so gar keine Antwort ( nicht einmal " zu schwieriges Thema") erhalte... Ich bin ja ?ber fast jede Antwort dankbar... :sad: Link to comment Share on other sites More sharing options...
sunscreen Posted January 27, 2006 Author Report Share Posted January 27, 2006 Schade, dass hier keine Antwort kommt... Ist das bei Euch normal oder einfach nur jetzt mal so...???? Link to comment Share on other sites More sharing options...
Alieha Posted January 27, 2006 Report Share Posted January 27, 2006 Hi sunscreen Du solltest als Sponsor wohl besser im Sponsor Forum posten, da hier im Forum ?usserst selten mal einer der XTC Entwickler reinschauen... zauberhafte Gr?sse Alieha Link to comment Share on other sites More sharing options...
Alieha Posted January 27, 2006 Report Share Posted January 27, 2006 versuchs mal damit.... http://www.xt-commerce.com/forums/index.ph...t=entry140973 Link to comment Share on other sites More sharing options...
SiL3NC3 Posted March 20, 2006 Report Share Posted March 20, 2006 und gibts da schon ne l?sung f?r die 3.04sp1 ?? w?re nett, wenn ihr uns ein ansatz h?ttet ... danke Link to comment Share on other sites More sharing options...
lci75 Posted October 11, 2007 Report Share Posted October 11, 2007 habe den gleichen fehler, gibts dazu eine loesung? Link to comment Share on other sites More sharing options...
sunshinie Posted October 12, 2007 Report Share Posted October 12, 2007 Bei meinem shop ist es auch das gleiche, egal was ich für einen Suchbegriff eingebe - es kommt: 1064 - You have an error in your SQL syntax near '' at line 1 SELECT p.products_id, p.products_price, p.products_model, p.products_quantity, p.products_shippingtime, p.products_fsk18, p.products_image, p.products_weight, p.products_tax_class_id, pd.products_name, pd.products_short_description, pd.products_description FROM products AS p LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id) LEFT OUTER JOIN specials AS s ON (p.products_id = s.products_id) AND s.status = '1' WHERE p.products_status = '1' AND pd.language_id = '2' AND ( ( pd.products_keywords LIKE ('%bikini%') OR pd.products_name LIKE ('%bikini%') OR pd.products_name2 LIKE ('%bikini%') OR p.products_model LIKE ('%bikini%') ) [XT SQL Error] Viele Grüße Yvonne Gibt es zu diesem Thema vielleicht auch Hilfe ohne ein Sponsor zu sein. BITTE. Link to comment Share on other sites More sharing options...
lci75 Posted October 16, 2007 Report Share Posted October 16, 2007 in der includes/module/default.php .... TABLE_MANUFACTURERS." m, ".TABLE_PRODUCTS." p, left join ".TABLE_SPECIALS." s on p.products_id = s.products_id .... durch : TABLE_MANUFACTURERS." m, ".TABLE_PRODUCTS." p left join ".TABLE_SPECIALS." AS s ON (p.products_id = s.products_id) ersetzen. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.