I gang

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.

Færdigheder: PHP

Se mere: 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

Om arbejdsgiveren:
( 8 bedømmelser ) Clearwater Beach, United States

Projekt-ID: #79748

Tildelt til:

NubKnacker

Please see PMB.

$30 USD in 0 dage
(13 bedømmelser)
4.0

21 freelancere byder i gennemsnit $31 for dette job

hautu

Please check PMB.

$30 USD in 0 dage
(246 bedømmelser)
7.6
TakeReal

I can repair your SQL statements today.

$30 USD på 1 dag
(1254 bedømmelser)
7.5
neoconcepts

i'm sendin PM to you.

$30 USD in 0 dage
(96 bedømmelser)
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 på 1 dag
(83 bedømmelser)
7.0
auroramedia06

Pelase check PMB for details

$30 USD in 0 dage
(25 bedømmelser)
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. Mere

$30 USD in 0 dage
(20 bedømmelser)
6.6
netexbd

I can start right now. thans

$30 USD in 0 dage
(24 bedømmelser)
6.6
ITRACK

Pls see PMB

$50 USD på 1 dag
(110 bedømmelser)
5.9
IeD3vil

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

$30 USD in 0 dage
(65 bedømmelser)
5.7
thepro

See my PM /the Pro

$30 USD in 0 dage
(5 bedømmelser)
4.9
ontun

Sir, Lets try... Thanks.

$30 USD på 1 dag
(37 bedømmelser)
4.5
brunodp

I can solve your problem in a little while

$30 USD in 0 dage
(3 bedømmelser)
3.6
aveenav

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

$30 USD in 0 dage
(2 bedømmelser)
3.2
pr0digy

i can help you in fixing this error.

$40 USD in 0 dage
(1 bedømmelse)
1.6
$30 USD in 0 dage
(3 bedømmelser)
1.6
aind

hello, its very simple.. quotes..

$30 USD på 1 dag
(0 bedømmelser)
0.0
bsdadmin3

can be done!

$30 USD in 0 dage
(0 bedømmelser)
0.0
tnlsolutions

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

$30 USD in 0 dage
(0 bedømmelser)
1.6
iflash

Some here is correct, check PM

$30 USD in 0 dage
(0 bedømmelser)
0.0
business2asia

Please check your PM!

$30 USD in 0 dage
(0 bedømmelser)
0.0