Customer Order info

[movado]

Everything seems to be working except for Customer orders in the admin panel.

This is what I get:

 

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 = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

 

Any one know what I need to change in the Syntax?

[dags]

strange I pasted that exact SQL into phpMyAdmin and it ran fine.

[movado]

I will try the same. Its just my luck though. its the things that are hard that come easy to me. and the trhings that are easy come hard. What version of mysql are you running?

[movado]

its the limit -20,20 that is messing things up. Maybe for my version the limit syntax is different I am using 4.1.1

[taz1]

Hi,

 

i have the same prob ..

 

Kunde 

Gesamtwert 

Bestelldatum 

Status 

Aktion 

1064 - You have an error in your SQL syntax near 'limit 0, 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 limit 0, 20

 

 

Does anyone have a clue what to change ???

[movado]

Place a false order and it should be workink and make sure you limit is correct!