One says 6/comfirmed which is good, other says 0/offline? which I'm hoping it caught the mistake and invalidated it.
However, now the 0/offline is back at 0/uncomfirmed, how do I get rid of that one? I think the system took a crap on me for my mistake.
It sounds to me like it did a double spend attempt. The first one spend probably went through eventually, after it was included in a block. Thus what you are seeing is your second attempt stuck at 0/unconfirmed. It will never confirm because it has already been spent.
[Upate: I'm not sure how that database wouldn't know that the first transaction had been made. Perhaps the database rolled back the transaction when it recovered after the crash?]
I don't think there is anything you can do about it other than send any coin balance to a new wallet and
toss [Update: "archive" never toss, in case you receive payments to it] the old one. (though once merge wallet is available that would be an option too:
http://forum.bitcoin.org/index.php?topic=8091.0 ).
I may be wrong on all this, but from the info you provided this sounds plausible.
You should check block explorer also. I would bet the unconfirmed spend was not included in any block there either.
