Need Help URGENT store is not processing orders correctly

[Redeye_Joe]

Ok, I am freaking out, for some reason, all of a sudden my store is no longer working, when a order gets placed it adds items that were not purchased, and lists two subtotals and it also sets an old date for order and a bunch of false order status's. Here is the body of one of the orders:

Order # 1542
Order Date & Time 02/08/2006 17:05:31
Payment Method: PayPal (Credit Card / Debit)


Products Model Tax Price (ex) Price (inc) Total (ex) Total (inc)
1 x Mountain Goat Trommel Mountain Goa 0.00% $669.00 $669.00 $669.00 $669.00
1 x A52 Hand Sluice A52 0.00% $97.50 $97.50 $97.50 $97.50
Sub-Total: $669.00
Sub-Total: $97.50
United Parcel Service (1 x 42.9lbs) (Ground): $25.42
United Parcel Service (XML) (1 pkg x 26.4 lbs total) (UPS Ground, 2006-02-15): $18.25
Total: $694.42
Total: $115.75



Date Added Customer Notified Status Comments
01/28/2006 18:15:01 Pending Payment
01/28/2006 18:18:23 Shipped
02/08/2006 17:09:31 Received PayPal IPN Verified [Completed (Unverified; $115.75)]
02/08/2006 17:09:41 Preparing [PayPal IPN]

________________________
you can see how it also is show four colums for teh price.. I had some trouble with my database last night and I am wondering if something isnt screwed up in there?

Please Help site is live and I am freaking out..

[Redeye_Joe]

I think I under stand what is wrong but I dont know how to fix this, last night I messed with my orders table trying to fix the pending # of order because it shows 222 when there is really 0, while trying to fix this, I messed up my order table in my database, so I thought I had fixed it by importing a older order table that I had save about a week ago, which seemed to fix it but I had to manually add a few orders tht I had got since then, but I think what has happened is that it has brought the order number back a few orderes and is showing both the old status, and order along with the new one, that got assigned the same number. Like I was at say order 1528, and when I had to use older database info, it brought my order number back to 1525, and now when it makes an order it makes like 1526, and adds the info that was already in there for that number. I think I just need to move my order number up a couple so the next order will get it own fresh number and I am hoping this will fix this problem.
I am going to go and search my order history table, because I feel it is the culprate.
Any ideas?

[Redeye_Joe]

Found it, it was combining old order and new order with the same number, freaked out one of my customers, I just move the auto increment up to about where I was, and all is good now..
Shewwww