Import says Success but Subscriptions don't change

8 years 3 months ago - 8 years 3 months ago #179168 by steve2simpson
Hi All,
I have spent a few days searching this site trying to find out what I am doing wrong.

I am trying to expire all users in a plan using the CBSubs Import function. I use the import plan by selecting:
1. The current plan and "Active" status.
2. Then select the same plan with a "Expire" status. (also tried with "unsubscribed")
3. Select today's date.
4. Select "Yes" to import behavior

Imported runs and show success but there is no change in subscription status. All user subscriptions still show active both in CBSubs and CB usermanager.

CBSubs 1.2.2
CB 1.7
Joomla 1.5.22

Thank you in advance for your help,

See supporting screen shots.
8 years 3 months ago #179180 by nant
Well the import functionality is not meant to do this.
Its not a batch processing function for existing subscriptions.
8 years 3 months ago #179181 by steve2simpson
Thanks for the quick reply Nick.

What would be the best way to expire all users in a plan?
8 years 3 months ago #179183 by nant
You would have to run a query on the database - Kyle needs to propose query.
8 years 3 months ago #179186 by krileon
Query wouldn't be appropriate as none of the triggers would fire meaning if you have any plans using any of the integrations to perform actions on expiration they wouldn't execute. If that's not a problem for you then the below would expire every active subscription of a given plan.
UPDATE `jos_cbsubs_subscriptions` SET `status` = 'X', `expiry_date` = NOW() WHERE `plan_id` = PLAN_ID AND `status` = 'A'

Please replace PLAN_ID with your plans actual ID and replace jos_ if it's not your database prefix. This is to be run on your database via phpmyadmin or other database management software.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Templates - CBSubs - Hosting - Forge - Incubator - GroupJive
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
8 years 3 months ago - 8 years 3 months ago #179187 by steve2simpson

Can you provide the same SQL statement against one user ID?

I'd like to test against one first.

To confirm, after the user is "expired" they will be able to login and select a new membership. Correct?

Thank you for "dumbing it down" for me. Sometimes this stuff is a little over my head.
Moderators: beatnantkrileon
Time to create page: 0.429 seconds

Facebook Twitter LinkedIn