I am getting the following error in my OS Commerce program when I try to view a customers order in the admin/orders ares:
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.customers_id, o.payment_method, o.date_purchased, o.last_modified, [url removed, login to view], o.currency_value, s.orders_status_name, [url removed, login to view] as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '9' and o.orders_status = s.orders_status_id and s.language_id = '1' and [url removed, login to view] = 'ot_total' order by orders_id DESC limit -20, 20
I received payment confirmation from this person, but did not receive the order confirmation from my OS Commerce install, so I know the amount of their order but not what they ordered. What would it cost to fix this problem?
this is an easy one. im new to this site owuld be willing todo the job for 10
Bu iş için 2 freelancer ortalamada $30 teklif veriyor
Hi I dont know how is businnes logic of program, I must see, but find the error. Please contact in PMB