xlegends Posted September 24, 2018 Share Posted September 24, 2018 latest whmcs stock, no mods/php71/centos7/nginx+php-fpm --------------------------------- About 3 weeks ago, I created a demo product X for purchase $10 (one time purchase) Yesterday, I manually converted it to a monthly cycle product and painstakingly manually changed it for all of the 93 customers to 1 month cycle .. My first renewal invoice generation is set for 10 days before due date for all products globally. Crons are running fine and other products, invoices, suspensions and terminations are working good. However, this product X, the first set of renewals should be coming due on 10/3 which is within 10 days so they never got a renew invoice I waited over night to see if crons will generate an renew invoice for them but it didnt.. How can I force generate them an invoice without globally changing the 10 day invoice setting (I dont want other products to be affected) 0 Quote Link to comment Share on other sites More sharing options...
xlegends Posted September 24, 2018 Author Share Posted September 24, 2018 [root@epic ~]# php -q /home/admin/web/mydomain.com/whmcs777/crons/cron.php -F all -vvv WHMCS Automation Task Utility: all ================================== Daily Cron Automation Mode Queuing Tasks ------------- Force run any tasks: ignore "in progress" and "is due" Task queues ready Executing Application Queue --------------------------- 0/26 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% < 1 sec/< 1 sec 20.0 MiB Currency Exchange Rates 1/26 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░] 3% < 1 sec/< 1 sec 20.0 MiB Product Pricing Updates 2/26 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░] 7% < 1 sec/< 1 sec 20.0 MiB Invoices 3/26 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░] 11% 11 secs/1 min 32.0 MiB Late Fees 4/26 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░] 15% 11 secs/1 min 32.0 MiB Credit Card Charges 5/26 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░] 19% 11 secs/57 secs 32.0 MiB Invoice & Overdue Reminders 6/26 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░] 23% 12 secs/52 secs 34.0 MiB Domain Renewal Notices 7/26 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░] 26% 13 secs/48 secs 34.0 MiB Cancellation Requests 8/26 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░] 30% 13 secs/42 secs 34.0 MiB Overdue Suspensions 9/26 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░] 34% 13 secs/38 secs 34.0 MiB Overdue Terminations 10/26 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░] 38% 13 secs/34 secs 34.0 MiB Fixed Term Terminations 11/26 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░] 42% 13 secs/31 secs 34.0 MiB Inactive Tickets 12/26 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░] 46% 13 secs/28 secs 34.0 MiB Delayed Affiliate Commissions 13/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░] 50% 13 secs/26 secs 34.0 MiB Affiliate Reports 14/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░] 53% 13 secs/24 secs 34.0 MiB Email Marketer Rules 15/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░] 57% 13 secs/23 secs 34.0 MiB Credit Card Expiry Notices 16/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░] 61% 13 secs/21 secs 34.0 MiB Server Usage Stats 17/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░] 65% 14 secs/21 secs 34.0 MiB Overage Billing Charges 18/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░] 69% 14 secs/20 secs 34.0 MiB Client Status Update 19/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░] 73% 14 secs/19 secs 34.0 MiB Domain Expiry 20/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░] 76% 14 secs/18 secs 34.0 MiB Ticket Escalation Rules 21/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░] 80% 14 secs/17 secs 34.0 MiB Data Retention Pruning 22/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░] 84% 14 secs/17 secs 34.0 MiB WHMCS Updates 23/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░] 88% 16 secs/18 secs 42.0 MiB Run Jobs Queue 24/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░] 92% 16 secs/17 secs 42.0 MiB Domain Transfer Status Synchronisation 25/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░] 96% 17 secs/18 secs 42.0 MiB Domain Expiry Synchronisation 26/26 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 17 secs/17 secs 42.0 MiB Sending Daily Cron Digest email Executing System Queue ---------------------- 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 1 min/1 min 60.0 MiB [OK] Completed [root@epic ~]# 0 Quote Link to comment Share on other sites More sharing options...
Brad (SaneChoice Limited) Posted September 24, 2018 Share Posted September 24, 2018 It’s an interesting issue! When you changed the renewal dates, did it fall within the 10 days or was it 11,12 etc? I am wondering whether WHMCS does not trigger if within the 10 days but would trigger if it counted down to 10 days. 0 Quote Link to comment Share on other sites More sharing options...
xlegends Posted September 24, 2018 Author Share Posted September 24, 2018 Ok after running that command 56/93 invoices were generated of those 93 clients who are within 10 days of expiry. Looks like its working now. I think what happened was I made the change after the daily crons digest daily cut off time last night. I would have generated them later tonight. 0 Quote Link to comment Share on other sites More sharing options...
yggdrasil Posted September 25, 2018 Share Posted September 25, 2018 Since I updated WHMCS to the latest version, the cron generates an invoice before the actual date which is very strange. Example, the cron is set to run at midnight, but exactly 1 hour before at 11PM, it generates the invoices for tomorrow. In the past users received the invoice exactly at midnight, now they receive it one hour before, or the day before which is really strange. I never had a problem with the cron until I updated WHMCS. Both PHP and the server time are correct and match. I'm not sure if this is related to your issues but there is something screwed up about WHMCS is now calculating dates. 0 Quote Link to comment Share on other sites More sharing options...
xlegends Posted September 26, 2018 Author Share Posted September 26, 2018 in my case I converted the cycle from one-time to monthly and just didnt wait long enough for next cron process.. Be sure u uncomment ; timezone in PHP. Ive made that mistake before. check help - system health to see if it complains about time zone You may also want to use a time-sync server. Webmin has a built in module for this under hardware. 0 Quote Link to comment Share on other sites More sharing options...
yggdrasil Posted September 26, 2018 Share Posted September 26, 2018 1 hour ago, xlegends said: in my case I converted the cycle from one-time to monthly and just didnt wait long enough for next cron process.. Be sure u uncomment ; timezone in PHP. Ive made that mistake before. check help - system health to see if it complains about time zone You may also want to use a time-sync server. Webmin has a built in module for this under hardware. Timezone is not commented in my PHP settings. This started to happen after I upgraded PHP and WHMCS. Its not a big issue, its just generating invoices exactly 1 hour before the actual date at 11 PM instead of 12 PM. This can confuse some people if they happen to read the new invoice email immediately, since its still the date before. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.