1064 - You have an error in your SQL syntax;

Em Andamento Postado Aug 9, 2006 Pago na entrega
Em Andamento Pago na entrega

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 do not receive order information or payment.

A few of the orders come through as they should, but the majority do not.

PHP

ID do Projeto: #79748

Sobre o projeto

21 propostas Projeto remoto Ativo em Aug 9, 2006

Concedido a:

NubKnacker

Please see PMB.

$30 USD em 0 dias
(13 Comentários)
4.0

21 freelancers estão ofertando em média $31 nesse trabalho

hautu

Please check PMB.

$30 USD in 0 dias
(246 Comentários)
7.6
TakeReal

I can repair your SQL statements today.

$30 USD em 1 dia
(1254 Comentários)
7.5
neoconcepts

i'm sendin PM to you.

$30 USD in 0 dias
(96 Comentários)
7.1
cheapbestsoft

Hi! We are a team of experienced programmers and we will be glad to help you! We guarantee that you will not regret if you will choose us! Thanks!

$30 USD em 1 dia
(83 Comentários)
7.0
auroramedia06

Pelase check PMB for details

$30 USD in 0 dias
(25 Comentários)
6.6
garex

I don`t request any money and this query is working on my server, but I ask you to give me your code or any access to investigate this strange bug... I don`t asks you any reviews - just intresting unusual case here. Mais

$30 USD in 0 dias
(20 Comentários)
6.6
netexbd

I can start right now. thans

$30 USD in 0 dias
(24 Comentários)
6.6
ITRACK

Pls see PMB

$50 USD em 1 dia
(110 Comentários)
5.9
IeD3vil

Hello :-) i`ll do it for free for gods sake Razvan

$30 USD in 0 dias
(65 Comentários)
5.7
thepro

See my PM /the Pro

$30 USD in 0 dias
(5 Comentários)
4.9
ontun

Sir, Lets try... Thanks.

$30 USD em 1 dia
(37 Comentários)
4.5
brunodp

I can solve your problem in a little while

$30 USD in 0 dias
(3 Comentários)
3.6
aveenav

Dear Sir, I can do this for anything but a good review. Please check PMB. Regards, Abhinav

$30 USD in 0 dias
(2 Comentários)
3.2
pr0digy

i can help you in fixing this error.

$40 USD in 0 dias
(1 Comentário)
1.6
$30 USD in 0 dias
(3 Comentários)
1.6
business2asia

Please check your PM!

$30 USD in 0 dias
(0 Comentários)
0.0
tnlsolutions

Dear Sir, Let me do it - I can provide you the best services. Thank you

$30 USD in 0 dias
(0 Comentários)
1.6
bsdadmin3

can be done!

$30 USD in 0 dias
(0 Comentários)
0.0
aind

hello, its very simple.. quotes..

$30 USD em 1 dia
(0 Comentários)
0.0
iflash

Some here is correct, check PM

$30 USD in 0 dias
(0 Comentários)
0.0