admin/orders.php > You have an error in your SQL syntax

[fel_cr]

I got an order in my site (already paid) and when I go to the admin area to see the "Order" page I get this error:

Orders

 

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

 

[TEP STOP]

 

 

:blink: :blink:

SO I CANNOT SEE WHAT THE ORDER IS... >_< >_< CAN ANYBODY PLEASE PoINT ME IN THE CORRECT DIRECTION TO TRY AND FIX THIS..? I saw the code in admin/orders.php but I dont see anything...

Any help would be appreciated.

Thanks

 

regards

 

Felipe

[wheeloftime]

I got an order in my site (already paid) and when I go to the admin area to see the "Order" page I get this error:

Orders

 

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

 

[TEP STOP]

:blink: :blink:

SO I CANNOT SEE WHAT THE ORDER IS... >_< >_< CAN ANYBODY PLEASE PoINT ME IN THE CORRECT DIRECTION TO TRY AND FIX THIS..? I saw the code in admin/orders.php but I dont see anything...

Any help would be appreciated.

Thanks

 

regards

 

Felipe

 

No need to SHOUT :P

Take a look here (last post) and see if it solves your PROBLEM !

[fel_cr]

UUPPPSSSSSSS !! :-" :-" :-" :-" :-"

 

Found the answer myself. http://www.oscommerce.com/forums/index.php?sho...26entry697026

 

sorry guys I didnt see it !

 

 

Actually THANKS a MILLION !! This community is awesome