That sounds promising. I have never scripted a raw transaction before and am a bit puzzled what exactly to put into the the fields at
https://coinb.in/.
Would you (or anyone) be able to assist me with this as I do not want to make any errors. Feeling bad enough already that I created this mess in the first place.
Before that, you can try abandontransaction to see if it'll remove the transactions as well as the descendant transactions to see if it'll remove them and mark them as spendable.
bitcoin-cli abandontransaction de188ec7d50032773a43af8703b2f17d6bde2ae701b64934bce3e8850cd6a904
If you're running anything older than 0.21.0, can you try restarting your full node and running it with -zapwallettxes as a flag at startup?
If neither of them works, then you'll have to try to create a raw transaction manually and it can be slightly tedious. I was trying it out for myself and their own server doesn't seem to be working so you'll have to select a different source at https://coinb.in/#settings. Select Blockchair (Bitcoin Mainnet) under Unspent Outputs. At
https://coinb.in/#newTransaction, you can enter the address that contains the inputs from (de188ec7...). After which, you should see that the inputs tab is populated with the unspent inputs associated with that address like so:
After which, you have to paste the desired address in the Address column as well as the output amount. Take note that any Bitcoins that is not spent will be used as a transaction fees so you have to spend all of it less the transaction fee or just add another output to use as a change address. If you're unsure as to how much transaction fees to include, here's a nifty website that gives you the fees to include (
https://bitcoindata.science/plot-your-transaction-in-mempool.html).
After which, you can click on submit and there should be a box with a long string. Copy that down.
bitcoin-cli decoderawtransaction "COPIED STRING"
Check if the transaction details are correct. You should be able to see the virtual size as well. Divide your fees in satoshi by that to get your fee rate which should be what you have entered in the site above. If it is, you can sign it/
bitcoin-cli signrawtransactionwithwallet "COPIED STRING"
You should be given a signed raw transaction. Decode it at
https://coinb.in/#verify and you can broadcast it using
https://coinb.in/#Broadcast.