Em Andamento

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?

Habilidades: PHP

Ver mais: 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

Acerca do Empregador:
( 0 comentários ) Ann Arbor, United States

ID do Projeto: #35818

Premiar a:

twrsparks

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

$30 USD em 0 dias
(0 Avaliações)
1.0

2 freelancers estão ofertando em média $30 para este trabalho

kokosharov

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

$30 USD em 1 dia
(5 Comentários)
3.2