Error trying to change status to delivered

[]NoMaD[]

I switch from "Pending" to "Delivered" in the status drop-down menu, and when I hit the update button, I get:

 

1064 - You have an error in your SQL syntax near 'from orders where orders_id = '2'' at line 1

 

select customers_name, customers_email_address, orders_status, date_purchased, ipaddy, from orders where orders_id = '2'

 

 

How do I fix this?

[Patty]

I have the exact same problem. I believe it's due to a IP mod I installed. Does anyone know how to fix this? Any clues, please?

 

Tks for any replies. ;)

[Guest]

There is an error in the query:

 

date_purchased, ipaddy, from orders

 

should be:

 

date_purchased, ipaddy from orders

 

just a stray comma :D

 

Matti

[Patty]

Tks for your help, Matti. I have found just about the same fix at another thread: http://www.oscommerce.com/forums/index.php?showtopic=123741&hl=. That one fixed the error, while just removing the coma after ipaddy didn't. Now I wonder if the customer IP will be recorded or shown. :rolleyes:

[Guest]

Removing the last comma after ipaddy is the ONLY way the query will be executed on the admin side while changing the status.

 

Bobby

[Patty]

The instructions on the thread I mentioned above worked just fine for me. IP is showing, no problems at all. All fixed! :thumbsup: