loadSomething error codes

I am trying to discover the cause of a number of loadSomething: error codes. I know this refers to a conflict between plans, but I can't seem to locate the cause. There are no child plans and the four membership plans we do have are identical except pricing.

The errors we're seeing are variations of these two:

What I haven't been able to identify is the subid. Just what exactly does the subid refer to?

Thanks

J 1.5.26, CB 1.8.1, CBS 2.0.1

You have a subscription in your database for a plan with an id of 1 that does not exist. My guess is you deleted a plan while it still had subscriptions. Only way to fix this is to remove the broken subscriptions or add the plan back and giving it an id of 1 through database. subid is the subscription id.

Thanks for the quick reply krileon,

I thought that the subid might refer to the subscription id and I checked the cbsubs_subscription table and could not find the number referenced in the error. That explains why - it's missing.

No plans have been created or deleted - plan 1 (and the other three plans) has been active for 18 months or so.

Does the subid have any relation to the userid? In other words; how can I identify which member's subscription is in conflict or could the user have been delete and for some reason the subscription data remained?

Also the second error: planid 1 of subid 4086 does not match planid 11. I don't understand the relationship here. Each plan is independent of the other and there are no child plans. A member can only subscribe to one plan at a time, so I don't understand why a subscription would have to match both plans?

Can you clarify this?

Thank you.

Belay that last post. I have been able to locate some of the memberships in question.

However, in examining their records, I don't see what the conflict might be.

Example: planid 11 (subid 6686, identified as userid 7209) does not match planid 1.

This particular member does have plan 11 (member plus associate) and I see that on the date the error was thrown, an admin changed this member from planid 1 (member only) to planid 11.

This happens quite often as members switch plans, but why the error?

Thanks

[Update]

Since my last post, I spent some time examining the cbsubs_subscription table against the user records and the subscription error notices. Most, but not all, of the subid's in the error messages are missing/deleted from the cbsubs_subscription table. Those that were still there had activity from one of our admins at the same time as the error was thrown.

Here's what I think is happening; a member mails in a renewal form/check and requests a membership plan change. The admin initiates a renewal from the front end (because most of the members will not do so) and then processes the basket for payment. The admin then opens CB Paid Subscriptions: Subscriptions, locates the member and clicks the subscription ID opening the Edit Subscription panel where the membership plan is changed.

Not good and I'm trying to break her of this habit. But here is my question. In doing this, is the original plan deleted from the cbsubs_subscription table? My thought is that the missing subid's are from the original that was changed and no longer exists. If so, then that is the reason for the error and why I can't find the record in the table.

Am I on base here?

Thanks

Your admin is forcing database changes to subscriptions. Tell her to stop as she's corrupting your tables. That is purely there for fixing minor issues like wrong dates, it is not a way to pay or change a subscription.

Your admin is forcing a plan change only to the subscription. This does not change the basket or the payment. This causes basically a database sync error as seen in the error message. Basically, tell her to stop doing this and it'll be fine.

To fix those already broken you will need to check all of CBSubs tables and fix the basket, payment, etc.. of that purchase from pointing to the old planid 1.

The proper way to change a subscription is to edit the user in CB > User Management and give them a new subscription to the correct plan then delete the old using the same method. If the date needs to be adjusted it's fine to do so by editing the subscription directly through CBSubs > Subscriptions, but don't change the plan or you'll run into the same issues as above.