Sedang Disiapkan

1064 - You have an error in your SQL syntax;

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.

Kemahiran: PHP

Lihat lebih lanjut: syntax error access violation 1064 error sql syntax, 1064 error sql syntax, error sql syntax, syntax error access violation 1064, 1064 error sql oscommerce, where you do, intext sql error, error sql, intextyou hacve error, sql syntaxfor right syntax use near, 1064 error sql syntax reviews, oscommerce 1064 error, 1064 error sql syntax oscommerce, osc action 1064 error sql syntax, syntax error access violation 1064 limit, 1064 error sql syntax comerce, intext sql syntax check, inurlerror sql syntax, 1064 sql error saving, 1064 error sql showthread showtopic forums article, oscommerce 1064, sql error 256 1064, fixing 1064 error sql syntax, fixing error sql syntax, error sql syntax feedback

Tentang Majikan:
( 8 ulasan ) Clearwater Beach, United States

ID Projek: #79748

Dianugerahkan kepada:

NubKnacker

Please see PMB.

$30 USD dalam 0 hari
(13 Ulasan)
4.0

21 pekerja bebas membida secara purata $31 untuk pekerjaan ini

hautu

Please check PMB.

$30 USD dalam 0 hari
(246 Ulasan)
7.6
TakeReal

I can repair your SQL statements today.

$30 USD dalam sehari
(1254 Ulasan)
7.5
neoconcepts

i'm sendin PM to you.

$30 USD dalam 0 hari
(96 Ulasan)
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 dalam sehari
(83 Ulasan)
7.0
auroramedia06

Pelase check PMB for details

$30 USD dalam 0 hari
(25 Ulasan)
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. Lagi

$30 USD dalam 0 hari
(20 Ulasan)
6.6
netexbd

I can start right now. thans

$30 USD dalam 0 hari
(24 Ulasan)
6.6
ITRACK

Pls see PMB

$50 USD dalam sehari
(110 Ulasan)
5.9
IeD3vil

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

$30 USD dalam 0 hari
(65 Ulasan)
5.7
thepro

See my PM /the Pro

$30 USD dalam 0 hari
(5 Ulasan)
4.9
ontun

Sir, Lets try... Thanks.

$30 USD dalam sehari
(37 Ulasan)
4.5
brunodp

I can solve your problem in a little while

$30 USD dalam 0 hari
(3 Ulasan)
3.6
aveenav

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

$30 USD dalam 0 hari
(2 Ulasan)
3.2
pr0digy

i can help you in fixing this error.

$40 USD dalam 0 hari
(1 Ulasan)
1.6
$30 USD dalam 0 hari
(3 Ulasan)
1.6
aind

hello, its very simple.. quotes..

$30 USD dalam sehari
(0 Ulasan)
0.0
bsdadmin3

can be done!

$30 USD dalam 0 hari
(0 Ulasan)
0.0
tnlsolutions

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

$30 USD dalam 0 hari
(0 Ulasan)
1.6
iflash

Some here is correct, check PM

$30 USD dalam 0 hari
(0 Ulasan)
0.0
business2asia

Please check your PM!

$30 USD dalam 0 hari
(0 Ulasan)
0.0