Skip to Content Skip to Menu

🕒 Save Time and Effort with CB Editor Assistant: Effortlessly create and refine content in Joomla 3, 4, & 5.
🎁 Limited Offer: Enjoy a 5-day FREE trial and save up to 30% afterward!
Try It!

[#3426] Cbsubs: SQL Deactivation Query seem to not work

  • dotcom22
  • dotcom22
  • OFFLINE
  • Posts: 522
  • Thanks: 14
  • Karma: 4
12 years 9 months ago #196755 by dotcom22
Replied by dotcom22 on topic Re: Cbsubs: SQL Deactivation Query seem to not work

krileon wrote: Have created bug ticket #3426 for further investigation. In the mean time please try to manually cancel a subscription from frontend instead of a refund to ensure your query then fires. If not it could be a problem with your query and ensure you're testing with debug mode enabled and maximum error reporting set so you can see fatal errors.


Ok I will try to cancel subscription and see what happen... However I remember to have set to disallow cancel subscription by user and I'm unable to find the related setting about that. I looked everywhere in all tab for 20min in plan and global settings... Where is that setting ?? :blush: :blush:
I use Joomla 3.3.6 - CB 2.0.4 - CBSubs 4 - Several Incubator plugins

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48689
  • Thanks: 8315
  • Karma: 1446
12 years 9 months ago #196762 by krileon
Replied by krileon on topic Re: Cbsubs: SQL Deactivation Query seem to not work
You can enable/disable unsubscribe from CBSubs > Settings > Display > Unsubscribe with the parameter "Show Unsubscribe buttons:".

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
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 CST to 4:00 PM CST. 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.

Please Log in or Create an account to join the conversation.

  • dotcom22
  • dotcom22
  • OFFLINE
  • Posts: 522
  • Thanks: 14
  • Karma: 4
12 years 9 months ago #196764 by dotcom22
Replied by dotcom22 on topic Re: Cbsubs: SQL Deactivation Query seem to not work

krileon wrote: You can enable/disable unsubscribe from CBSubs > Settings > Display > Unsubscribe with the parameter "Show Unsubscribe buttons:".


Many thank and sorry. Even if is now months I play with CBsubs is sometime difficult to find all settings because your stuff is a real factory. ;) But I like so much because only like that we can have a strong control and flexibility for do exactly what we really need... :woohoo:

In the mean time please try to manually cancel a subscription from frontend instead of a refund to ensure your query then fires.


Ok I tested and my query roll like expected when canceling subscription. So it seem a bug is present only when making refund...
I use Joomla 3.3.6 - CB 2.0.4 - CBSubs 4 - Several Incubator plugins

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 48689
  • Thanks: 8315
  • Karma: 1446
12 years 9 months ago #196778 by krileon
Replied by krileon on topic Re: Cbsubs: SQL Deactivation Query seem to not work

So it seem a bug is present only when making refund...

Ok, thank you; that was what I was looking for (very important when reviewing bug). Unfortunately I've no workaround at this time. Maybe first cancel the users subscription from backend then issue the refund?

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
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 CST to 4:00 PM CST. 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.

Please Log in or Create an account to join the conversation.

  • dotcom22
  • dotcom22
  • OFFLINE
  • Posts: 522
  • Thanks: 14
  • Karma: 4
12 years 9 months ago #196787 by dotcom22
Replied by dotcom22 on topic Re: Cbsubs: SQL Deactivation Query seem to not work
No problem right now for me... I noticed this just fortuitously when testing payment using Paypal. After making my payment I make a refund to myself and discover the issue. Normally I will not need to make refund to some customers right now. Even if I need in some rare case, I can manually do the task planned in my sql query..

Of course if you can solve the bug in some future release that nice.

cheers
I use Joomla 3.3.6 - CB 2.0.4 - CBSubs 4 - Several Incubator plugins

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon
Powered by Kunena Forum