Đang Thực Hiện

1064 - You have an error in your SQL syntax;

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?

Kỹ năng: PHP

Xem thêm: line problem, cost problem, amount received, sql server admin, on sql, error 0, you, syntax, sql mysql, sql c, mysql error, error, error php, desc, php sql syntax error, 1064 php, admin error, payment error, sql syntax error, php mysql 1064, sql select order, sql select, text sql, mysql sql syntax, sql problem

Về Bên Thuê:
( 0 nhận xét ) Ann Arbor, United States

Mã Dự Án: #35818

Đã trao cho:


this is an easy one. im new to this site owuld be willing todo the job for 10

$30 USD trong 0 ngày
(0 Đánh Giá)

2 freelancer đang chào giá trung bình $30 cho công việc này


Hi I dont know how is businnes logic of program, I must see, but find the error. Please contact in PMB

$30 USD trong 1 ngày
(5 Đánh Giá)