First thanks for the extensive post which took you a while.
But in my case as I said they tried several times in the past and deleted some plans and they look like they are orphaned.
As for subscriptions failing to delete, I believe that may be caused because the subscription is still seen as active, aka "incomplete." Find the last status, and change it to "EXPIRE NOW." Then you should be able to "DELETE" it.
There is not a field to select in transactions to delete., It is blank
Probably due to groups or subscriptions were deleted prior.
That is why I want to clean it up.
I have read that link from a prior post that you looked up.
But in my case it was not auto return that was turned on but IPN notification going to a non valid link with nothing to do with UBB.
As I said I am at ubb V 7.7.3 and just want to wipe it all out due to I can't with the cp interface.
And start fresh
I can deal with the few members that are actual subscribers and fat finger them back in.
I was unsure if the two tables are tied to anything else if I empty them.
It appears that they are not.
Other than some members may loose the group assignment. Which I can deal with manually.
