Project Detail

OSCommerce SNQ syntax fix  

OSCommerce SNQ syntax fix is project number 376992
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: TakeReal

Budget: $30-250

Created: 01/27/2009 at 19:58 EST

Bid Count: 3

Average Bid:
N/A

01/28/2009 at 19:58 EST

Project Creator: greenblueblack
Employer Rating: 9.9286/109.9286/109.9286/109.9286/109.9286/109.9286/109.9286/109.9286/109.9286/109.9286/10 (14 reviews)

Bid On This Project
 

Description

On admin page,

Here are pending orders, but if you click it, got the page

Orders Order ID:
Status: All OrdersPendingProcessingDelivered


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 '-20, 20' at line 1

select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

Please fix it asap while keeping the pending order info

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

Bids are hidden by the project creator. Log in as the project creator or as one of the bidders to view bids. You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


    Bid on this Project