I'm offical confused and at wits end with this one.
Okay, so I've been fighting with getting PayPal orders to work. Thought I got it fixed. Logged in with my "test customer's name" after sucessfully sending money and purchasing items. Got the Order Sucess, got the emails, ect. So I log into 'My Account', click on Order History and bam!
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.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from orders o, orders_total ot, orders_status s where o.customers_id = '20' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '1' order by orders_id DESC limit -10, 10
So, I look this error, find this thread. Try the fix.
Now I'm getting negative page numbers, no error, and 0 of 0 orders in admin. When I first log into admin, it actually says 2 pending orders, but when I try to view them.... nothing 0 of 0.
What did I do and how do I fix it?
Edited by LadyShelly, 02 April 2006 - 09:07 PM.