Skip to Content Skip to Menu

a lot of CBsubs users still Active in DB despite expiration date

  • ThePiston
  • ThePiston
  • OFFLINE
  • Posts: 334
  • Thanks: 26
  • Karma: 1
9 years 7 months ago #262848 by ThePiston
Can anyone tell me why I'd find this in the database? The user is Active but way past expiration date:


CB 2.3, CBsubs 4.3, PHP 7.1, J! 3.9.X
Attachments:

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

9 years 6 months ago - 9 years 6 months ago #264366 by jered@saverexpress.com
Replied by jered@saverexpress.com on topic a lot of CBsubs users still Active in DB despite expiration date
I have the same issue, I have over 3,000 accounts that should have been expired but they are still set as "A" despite their expiry dates being past...

If we update these directly on the databases.. Will the emails, baskets and invoices still be generated correctly?

Should we upgrade to the RC version of CbSubs?

System:
CBSubs 3.0
CB: 1.9.1
Joomla 3.4.1
Apache Version 2.4.10
PHP Version 5.5.18
MySQL Version 5.5.42-cll
Architecture x86_64
cPanel Version 11.48.4 (build 2)
Attachments:
Last edit: 9 years 6 months ago by jered@saverexpress.com.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48548
  • Thanks: 8290
  • Karma: 1445
9 years 6 months ago #264680 by krileon
You need to trigger expiration. By default this is done by visiting the Payments Center in CBSubs. Ideally you should setup CRON to run the expiration URL found in CBSubs > Settings > Global on a daily basis.


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.

9 years 6 months ago - 9 years 6 months ago #264704 by jered@saverexpress.com
Replied by jered@saverexpress.com on topic a lot of CBsubs users still Active in DB despite expiration date

krileon wrote: You need to trigger expiration. By default this is done by visiting the Payments Center in CBSubs. Ideally you should setup CRON to run the expiration URL found in CBSubs > Settings > Global on a daily basis.


Hi Krileon.
I tried using the url in there.. but the error log grows insanely repeating these lines:

[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 2
[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 8
[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 14
[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 20
[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 26
[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 32
[03-Oct-2014 14:14:47 America/Chicago] PHP Notice: Undefined index: HTTP_HOST in <span>/</span>home<span>/</span>xxxx/public_html/index.php on line 38


the strange part is the path to the index.php file.

Our files are not in that directory
but in the public_html/v1/index.php
always have been.
No idea why its requesting information from the root's index.php
Last edit: 9 years 6 months ago by jered@saverexpress.com.

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

9 years 6 months ago - 9 years 6 months ago #264706 by jered@saverexpress.com
Replied by jered@saverexpress.com on topic a lot of CBsubs users still Active in DB despite expiration date
addenum on this..15 minutes later, I'm getting the first emails of expirations.
but not all accounts were set to expire.


heres the error in the admin log of cbsubs.
Code:
CAUGHT EXCEPTION: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/XXXXXX/public_html/v1/administrator/components/com_comprofiler/comprofiler.class.php on line 1687 Trace:called in class cbpaidErrorHandler::_error_handler_callable(8192, "preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead", "/home/XXXXXX/public_html/v1/administrator/components/com_comprofiler/comprofiler.class.php", 1687, array("source" => "Saver", "_CB_framework" => object(CBframework), "charset" => "UTF-8")) called in function preg_replace("/&#x([a-f0-9]+);/mei", "utf8_encode(chr(0x\1))", "Saver") on line 1687 in file comprofiler.class.php called in function cb_html_entity_decode_all("Saver") on line 4998 in file comprofiler.class.php called in class cbNotification::sendFromSystem(object(moscomprofilerUser), "Subscription Expiration Warning!", "Dear Debra, The annual membership fees for your Saver membership is now due. In order to continue your membership with us, please go to the website www.XXXXXX.com log into your account and submit your renewal payment. Once your payment has been processed you will be able to enjoy the Saver Website, our concierge service and all the other travel benefits and services available through Saver . We look forward to receiving your renewal payment and to assisting you with your next holiday in the near future. Your plan type: 1 Year Saver Membership - Standard Plan Validity until: 14/05/2015 Yours sincerely, Saver ", true, 0, NULL, array(0 => "cesar@XXXXXX.com"), NULL) on line 654 in file cbpaidSomething.php called in class cbpaidSomething::sendNewStatusEmail(object(moscomprofilerUser), "Denied", NULL, 0) on line 1014 in file cbpaidUsersubscriptionRecord.php called in class cbpaidUsersubscriptionRecord::setBlockPaidUser(object(moscomprofilerUser), "Denied", NULL, NULL, NULL, 0) on line 889 in file cbpaidUsersubscriptionRecord.php called in class cbpaidUsersubscriptionRecord::deactivate(object(moscomprofilerUser), "X") on line 774 in file cbpaidUsersubscriptionRecord.php called in class cbpaidUsersubscriptionRecord::expireIfExpired() on line 199 in file cbpaidUserExtension.php called in class cbpaidUserExtension::checkUserSubscriptions(false, NULL, "X", true) on line 202 in file cbpaidProductUsersubscription.php called in class cbpaidProductUsersubscription::checkAllSubscriptions(100) on line 184 in file cbpaidPlansMgr.php called in class cbpaidPlansMgr::checkAllSubscriptions(100) on line 159 in file cbpaidControllerCBComponent.php called in class CBplug_cbpaidsubscriptions::getCBpluginComponent(NULL, object(moscomprofilerUser), 1, array()) called in function call_user_func_array(array(0 => object(CBplug_cbpaidsubscriptions), 1 => "getCBpluginComponent"), array(0 => NULL, 1 => object(moscomprofilerUser), 2 => 1, 3 => array())) on line 583 in file plugin.class.php called in class cbPluginHandler::call("500", "getCBpluginComponent", "CBplug_cbpaidsubscriptions", array(0 => NULL, 1 => object(moscomprofilerUser), 2 => 1, 3 => array()), NULL) on line 4187 in file comprofiler.class.php called in class cbTabs::_callTabPlugin(NULL, object(moscomprofilerUser), "CBplug_cbpaidsubscriptions", "getCBpluginComponent", "500", array()) on line 4274 in file comprofiler.class.php called in class cbTabs::tabClassPluginTabs(object(moscomprofilerUser), array(), "cbpaidsubscriptions", "CBplug_cbpaidsubscriptions", "getCBpluginComponent") on line 780 in file comprofiler.php called in function tabClass("com_comprofiler", "pluginclass", 604) on line 275 in file comprofiler.php called in function require_once("/home/XXXXXX/public_html/v1/components/com_comprofiler/comprofiler.php") on line 391 in file helper.php called in class JComponentHelper::executeComponent("/home/XXXXXX/public_html/v1/components/com_comprofiler/comprofiler.php") on line 371 in file helper.php called in class JComponentHelper::renderComponent("com_comprofiler") on line 191 in file site.php called in class JApplicationSite::dispatch() on line 230 in file site.php called in class JApplicationSite::doExecute() on line 252 in file cms.php called in class JApplicationCms::execute() on line 40 in file index.php $_GET = array ( 'option' => 'com_comprofiler', 'task' => 'pluginclass', 'plugin' => 'cbpaidsubscriptions', 'do' => 'massexpire', 'key' => 'd41d8cd98f00b204e9800998ecf8427e', 'format' => 'raw', ) $_POST = array ( )
Last edit: 9 years 6 months ago by jered@saverexpress.com.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48548
  • Thanks: 8290
  • Karma: 1445
9 years 5 months ago #266428 by krileon
Not sure what to advice regarding your issues jered as they've been addressed by CB 2.x and CBSubs 4.x. Best I can suggest is to update as soon as possible. We've already fixed the errors you're seeing in your log.


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.

Moderators: beatnantkrileon
Powered by Kunena Forum