[SOLVED] CBSubs recurring payment problem

I deleted a user in CB some days ago, but today the basket of that user is still triggering a recurring payment through the Quickpay gateway!?? - how is that possible, when the user is deleted ?? Why is the basket not deleted together with the user ?
Or at least the subscription should be terminated upon deletion in CB.

But! To fix this problem, could I create an auto action og the type CBSubs with the trigger "OnBeforeDeleteUser", to delete the subscription or should i use the trigger "OnAfterDeleteUser" ??
And is the basket set inactive when a subscription is deleted or will the basket still trigger a recurring payment ?

Now I see another error ocurring when paying with recurring through Quickpay.

I get this error:"FAILED (Error) Auto-recurring payment DKK 1100.00 for basket 807 Order_id njord807 for xxxxxx xxxxxx (username xxxxxxxxx- user id 488) used quickpay due to error . Nex payment attempt is scheduled for 2022-01-01 13:00:06"

The amount is Wrong as 1100 is only the first payment and not the recurring. AND i can see at quickpay that an amount of DKK 600 HAS been withdrawn for this basket, but the users subscription has not been updated in CBSubs ! This is not good.

See Quickpay overview here:

I have looked into the db table cbsubs_payment_baskets and I can see that on the 6 users where the payment has gone throgh but without registering correct in cbsubs the mc_amount1 is set to 1100 and not 600, which it is on all the other baskets - how can that happen ? The number 1100 is the initial payment for the first signup - after that the recurring is 600.

I deleted a user in CB some days ago, but today the basket of that user is still triggering a recurring payment through the Quickpay gateway!?? - how is that possible, when the user is deleted ?? Why is the basket not deleted together with the user ?

We don't touch payments during user delete. Those should be cancelled before you delete them. Baskets aren't deleted either because they're needed for invoices, which are needed for financial records, which are then needed for tax purposes in most countries.

Within _cbsubs_payment_baskets find the basket of the deleted user and set scheduler_state to C and scheduler_next_maturity to NULL to cancel the scheduler.

Please be sure to cancel payments by editing the user and under the Subscriptions tab cancelling it before deleting them. Have added a bug ticket to review blocking user delete until payments are cancelled or cancelling them automatically. Best to probably just block the delete to prevent accidental recurring payments loss if delete was done by mistake.

forge.joomlapolis.com/issues/8823

I get this error:"FAILED (Error) Auto-recurring payment DKK 1100.00 for basket 807 Order_id njord807 for xxxxxx xxxxxx (username xxxxxxxxx- user id 488) used quickpay due to error . Nex payment attempt is scheduled for 2022-01-01 13:00:06"

Are there any further details regarding the error in the CBSubs History Log?

I have looked into the db table cbsubs_payment_baskets and I can see that on the 6 users where the payment has gone throgh but without registering correct in cbsubs the mc_amount1 is set to 1100 and not 600, which it is on all the other baskets - how can that happen ? The number 1100 is the initial payment for the first signup - after that the recurring is 600.

mc_amount1 is the first payment. It's correct being 1100. mc_amount3 is the recurring amount and it should be set to 600 unless you made that change before they subscribed.

Are there any further details regarding the error in the CBSubs History Log?

No - not really.

What about my question

But! To fix this problem, could I create an auto action of the type CBSubs with the trigger "OnBeforeDeleteUser", to delete the subscription or should i use the trigger "OnAfterDeleteUser" ??
And is the basket set inactive when a subscription is deleted or will the basket still trigger a recurring payment ?

Could this do the trick for me ?