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.
The screenshot I posted above, I believe does the same thing as the last part of my reply above it... which was:
or 2/
You can also modify the database directly and remove the undesirable lines from SUBSCRIPTION_DATA.
This will also remove the subscription history (and detail) from the forum user's dashboard and the admin's dashboard. This should be a last resort.
Doing this should "batch" accomplish what you're looking to complete
First thanks for the extensive post which took you a while.
thank you