W-M Posted February 24, 2005 Report Share Posted February 24, 2005 Hallo, habe festgestellt, dass ich seit einiger Zeit immer nur SQL Fehler angezeigt bekomme, wenn ich zB die Bestellungen ansehen m?chte im Adminbereich 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 '-20, 20' at line 1 select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '2' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20 [XT SQL Error] Was kann das denn nun sein ? Link to comment Share on other sites More sharing options...
techway Posted February 24, 2005 Report Share Posted February 24, 2005 hallo, es liegt wohl an der MySQL-Version... diese unterst?tzt keine negative limits!! Gru? TechWay Link to comment Share on other sites More sharing options...
W-M Posted February 26, 2005 Author Report Share Posted February 26, 2005 Und wie kann man das ?ndern ?? Kann man da was in der Konfiguration der SQL umschreiben ? Habe auf diesem Server die Zend PHP 4.3.10 laufen und mysql 3.23.49 Vielleicht hat ja noch jemand nen Tip :cry: Link to comment Share on other sites More sharing options...
gusuval Posted February 26, 2005 Report Share Posted February 26, 2005 Hallo mein problem ist das selbe , ich habe 4.1.8 Mysql server und habe auch problemen was kan man tun ? Danke Link to comment Share on other sites More sharing options...
khan_thep Posted February 26, 2005 Report Share Posted February 26, 2005 http://www.xt-commerce.com/modules/ipboard...showtopic=10536 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.