activation for free subscriptions before approval

Hi, I have been searching this forum but couldn't find a solution to my problem:
I have 3 different "free lifetime" subscription plans and set up CB to require admin approval and user email confirmation. The problem is that with free subscriptions the user gets an email (set up for that plan in cbsubs) that his account has been activated, although he did not even have to confirm his email address or be approved by an admin.
Is there a way to change this and only activate the plan AFTER it has been approved by the admin? I do not want an subscription plan to be activated unless the admin approves it.

Please edit your plans and ensure you've set User Approval by Moderator: on the Workflows tab Yes, before payment (override CB). This would mean the user must be approved before their plan can be paid for (thus active). I Recommend doing the same for User Email Confirmation: if you wish to use email activation as well.

this is exactly how I have set it up. however, because it's a free plan, the activation happens immediately, BEFORE it is being approved by the admin or confirmed by the user.
I need actions (SQL and emails) AFTER it has been approved by an admin. Can you please test this with a free lifetime subscription?

this is exactly how I have set it up. however, because it's a free plan, the activation happens immediately, BEFORE it is being approved by the admin or confirmed by the user.

I see, please ensure you've configured Free Lifetime plans to create subscriptions within CBSubs > Settings > Global. This should prevent such an issue from happening and allow free lifetime plans to behave the same as any other plan.

this also has been set to: "Create Subscriptions also for free lifetime plans: yes"
I have tried with "Require Admin Approval" and "Require Email Confirmation" both set to yes for the main CB and also overrides for the individual plans but it still sends an activation email straight away before any user or admin interaction. I'm using CB 1.3.1 and CBsubs 1.1.2

Believe is working as intended as there is no payment process for free plans as is configured to "Yes, before payment (override CB)"; thus plan is becoming active immediately. In this scenario the user should receive their Email Confirmation email, but should not be informed they have been activated. Please check that the user is not just receiving the Pending email.

I need actions (SQL and emails) AFTER it has been approved by an admin

You could use the two incubator projects CB Queries and CB Emails which allow executing database queries and emails on various CB triggers such as after approval.