Bad Order Record in Database

[mdegeiso]

I have been doing some testing with my site and entered, then deleted a purchase. Something didn't quite work right on the deletion and now the order is gone but it still shows that I have one order "processing" when in fact I don't.

What I would like to know is how I can querry the database so that I can look at all the purchases and then delete the bad record. I run vers 5 of mySQL and use mySQLAdmin. Just not up to speed on SQL commands etc.

Thanks
Mike

[DrByte]

How many languages on your site?
You might check in these tables:
- orders
- orders_status_history
- orders_status
and perhaps other tables related to order-processing:
http://www.zen-cart.com/wiki/index.p...#Order_History