[SOLVED] Incorrect ID assigned to subscription

Dear,

Currently I am troubleshooting some issues with payments where it seems CBSUbs applies the incorrect ID towards the subscription.
Current situation is when a user pays, he activates the previous user subscription.

It makes sense it goes wrong as when I check the current index in my database it says:

Next Autoindex ID = 48

Where if I check the CB Paid Subscriptions: General plugin settings -> Invoices,
it says:

Next invoice [NUMBER] that will be used 47

How can it be the GUI says 47 and the database 48?

Thanks in advance!

As an addition.. I tried overwriting the thing by editing the "Reset next Invoice [NUMBER] to".

I used 50 just to test... but for some reaon it still used 47 ?! ...

one step further...

I altered the AutoIncrement index to -1.
I expect while editing the database a record was added or duplicate entered (not sure what happened.. but the database AutoIncrement index was 1 ahead of what CBSUbs Thought it was).

Eventually ending up in having to alter the AutoIncrement Index value in the database

SQL: alter table tablename AUTO_INCREMENT={value}

This seems to 'solve' the issue for now.. but I have my concerns regarding the $_POST value used to create the subscription.

Where does CBSubs get this value from?
It seems the invoice number is not the custom variable but just the invoice number and my guess is CBSubs Assumes the AutoIncrement is identical or am I incorrect?

For me, as said, it works for now.. but I don't want such a thing happening again in the future and trying to understand what the reason was for the mismatches.

Could you guys shed any light on this one?
Thanks!

Renewals do not generate a new invoice. For CBSubs a Basket = Invoice. Renewals simply renew the existing basket. Auto incremented ID is not the invoice number. The invoice number is stored in the invoice column of _cbsubs_payment_baskets. I highly suggest you do not alter the database.

To be complete:
- Autorecurring renewals do not generate a new invoice for 2nd to last payment.
- Manual renewals do generate a new basket and invoice, but not a new subscription (if it is a renewal or a re-activation and not an upgrade)

thanks guys for clearing that out.. I did indeed mistaken the invoice number with the id field in the database.

From your remarks I could see I made a wrong assumption based on maybe a bad explanation form my side .

When a user registers, a new user is added within '__cbsubs_subscriptions'.
As i had to create a own method for my users to be able to pay with a dutch payment gateway I simply used the $_POST-custom variable as i thought this was the ID used in '__cbsubs_subscriptions'.... but it is used for the payment_basket.

As these tables where 1 ID of (payment basket AI_number was 47 and cbsubs_subscriptions was 48_.. it would result in such a behavior that user #48 would activate the account of user#47 bij paying.

Unfortunately I don't have the money to invest so you guys could create a proper payment gateway.. but I understand that with my limited knowledge about CB Subs that would be great investment when we receive a couple of payments .

thanks again guys.