This is a discussion on Error Customer Orders Admin Panel within the osCMax v1.7 Discussion forums, part of the osCMax v1.7 Forums category; Whenever I am in the admin section and I click on the "Customers" and either the "Orders" or "PayPal IPN" ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| Whenever I am in the admin section and I click on the "Customers" and either the "Orders" or "PayPal IPN" link I get the following error? Code: 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 '-10, 10' 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 -10, 10 [TEP STOP] Thanks! |
| Sponsored Links | ||
| ||
| |
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 1064 - error in your SQL syntax admin customer search | webwolfe | osCMax v1.7 Discussion | 0 | 11-10-2006 06:13 AM |
| my admin panel is all screwed up! | chuan | osCMax v2 Installation issues | 1 | 10-07-2006 06:29 PM |
| Changing maximum number of orders displayed in admin panel | markymrk22 | osCommerce 2.2 Installation Help | 1 | 09-03-2005 10:56 AM |
| edit customer in admin error, heelllppp | battleaxe | osCMax v1.7 Discussion | 0 | 10-07-2004 02:38 AM |
| Please help!!! Error in admin tool with Customer info | Rosina | osCommerce 2.2 Installation Help | 2 | 09-22-2004 03:22 PM |