In Progress

OSC error puchase order - Urgent !!

I just received 2 orders on one of my customer website, built with OSC 2.2, Cre-loaded, but the client did not receive the Purchase order.

When we verified in the admin area, for the clients order, we received this error.

Orders Order ID:

Status: All OrdersPendingProcessingDeliveredPaypal ProcessingAllow DownloadOn HoldCanceledAwaiting CC Processing

Customers Order Total Date Purchased Status Action

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 '-10, 10' 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 = '59' 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 -10, 10

[TEP STOP]

We need this fixed ASAP.

Skills: PHP

See more: this error, error 0, urgent website, urgent one, urgent mysql, syntax, purchase order, oscpro, order, order processing, need order, mysql error, error, error php, desc, asap urgent, php sql syntax error, urgent check, urgent line, 1064 php, admin error, website error, sql syntax error, php mysql 1064, sql select order

About the Employer:
( 88 reviews ) Montreal, Canada

Project ID: #32283

Awarded to:

oscpro

I can fix this very quickly for you.

$30 USD in 1 day
(88 Reviews)
6.8

7 freelancers are bidding on average $63 for this job

ndinfosys

Let Me make it. Having enough experience with OSC. Done many work in OSC for design integration and Bug Fixing. More in pmb kindly chek it. -Thanking you Andey.

$30 USD in 0 days
(47 Reviews)
6.3
campbeld

As a professional, you cannot afford to let this problem persist. Choose a provider who can guarantee rapid problem resolution or your money-back. Is your business worth it?

$90 USD in 1 day
(10 Reviews)
4.7
robelsoft

Hi, I can do this for you. I have worked on several oscommerce sites. So, surely I can do it. Payment via escrow. Thanks

$60 USD in 3 days
(4 Reviews)
4.0
extremewebindia

HI, We can provide best solution for your site.We are expert in developing of opensources like PHPBB, Mambo,zencart,Oscommerce,Tikiwiki.... Please see our site: www.extremewebworld.com thanks sandeep

$100 USD in 2 days
(1 Review)
3.8
solutionmentor

will fix it in 20 minutes and i need 20dollars

$30 USD in 1 day
(7 Reviews)
2.9
idiotphp

We are quite experienced in os commerce so can fix it within few hours.

$100 USD in 1 day
(1 Review)
2.0