TakCloud Posted September 24, 2017 Share Posted September 24, 2017 hi when run cron jobs is not suspend overdue service auto suspend is enabled how can fix problem? 0 Quote Link to comment Share on other sites More sharing options...
TakCloud Posted October 2, 2017 Author Share Posted October 2, 2017 Nobody help? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted October 2, 2017 WHMCS Developer Share Posted October 2, 2017 You haven't really provided any information for someone to assist you. Do you receive your cron job email daily? Do you see any error in your Activity Log? What happens if you manually attempt to suspend an overdue service? Do you definitely have some services overdue enough to warrant a suspend? You can confirm how many days after due something would attempt to be suspended in Setup -> Automation Settings 0 Quote Link to comment Share on other sites More sharing options...
TakCloud Posted October 2, 2017 Author Share Posted October 2, 2017 (edited) 6 hours ago, WHMCS Andrew said: You haven't really provided any information for someone to assist you. Do you receive your cron job email daily? Do you see any error in your Activity Log? What happens if you manually attempt to suspend an overdue service? Do you definitely have some services overdue enough to warrant a suspend? You can confirm how many days after due something would attempt to be suspended in Setup -> Automation Settings hi andrew yes im recive cron job mail daily not show error manually suspend from whmcs work corectly Suspend Days : 1 in cron job mail evry day show : Overdue Suspensions 1 Suspended but not suspend any service and in full summary Overdue Suspensions 0Suspended 0 faild Edited October 2, 2017 by WHMCS ChrisD Corrected formatting 0 Quote Link to comment Share on other sites More sharing options...
WHMCS ChrisD Posted October 2, 2017 Share Posted October 2, 2017 Hello @TakCloud There's a number of things that could be happening here causing the error. To begin: Login to WHMCS Go to Setup > General Settings > Other Locate Display Errors and Tick this Feild Save Open your servers terminal window Run the following command php -q /home/username/crons/cron.php -F all -vvv Replacing /home/username/crons/ with the path to your cron Check the full on-screen output for errors at the suspension section If you do not have server terminal access please follow steps 1 - 4 and ask your host to run the command providing you with the full output. 0 Quote Link to comment Share on other sites More sharing options...
TakCloud Posted October 3, 2017 Author Share Posted October 3, 2017 7 hours ago, WHMCS ChrisD said: Hello @TakCloud There's a number of things that could be happening here causing the error. To begin: Login to WHMCS Go to Setup > General Settings > Other Locate Display Errors and Tick this Feild Save Open your servers terminal window Run the following command php -q /home/username/crons/cron.php -F all -vvv Replacing /home/username/crons/ with the path to your cron Check the full on-screen output for errors at the suspension section If you do not have server terminal access please follow steps 1 - 4 and ask your host to run the command providing you with the full output. hi im run command and show this error : [ERROR] exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'last_attempt_error' cannot be null' in /home//public_html/vendor/illuminate/database/Connection.php:441 Stack trace: /home/public_html/vendor/illuminate/database/Connection.php(441): PDOStatement->execute(Array) /public_html/vendor/illuminate/database/Connection.php(706): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlCo nnection), 'insert into `tb...', Array) Next exception 'Illuminate\Database\QueryException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'last_attempt_error' cannot be null (SQL: insert into `tblmodulequeue` (`service_type`, `service_id`, `module_name`, `module_action`, `completed`, `last_attempt`, `last_attempt_error`, `num_retries`, `updated_at`, `created_at`) values (service, 2783, esx, SuspendAccount, 0, 2017-10-03 10:47:46, , 0, 2017-10-03 10:47:46, 2017-10-03 10:47:46))' in 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted October 3, 2017 WHMCS Developer Share Posted October 3, 2017 OK, this error means that the custom server module 'esx' is not returning any error when an error is occurring which is causing your issue here. This would need to be resolved by your module creator. I have opened a case, CORE-11696 to better handle a null queue item in the future. 1 Quote Link to comment Share on other sites More sharing options...
NJadire Posted February 5, 2020 Share Posted February 5, 2020 Hi, We have the same problem, Do you receive your cron job email daily? YES Do you see any error in your Activity Log? Nothing What happens if you manually attempt to suspend an overdue service? Actually we do not use any module to suspend the service, we just need to change the status to Suspended and it is enough for us. Yes manually changing the status is work! Do you definitely have some services overdue enough to warrant a suspension? Yes, I have tried a few times with different situations! Here is the output of: php -q /home/username/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/30 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 0% < 1 sec/< 1 sec 18.0 MiB Currency Exchange Rates 1/30 [░░░░░░░░░░░░░░░░░░░░░░░░░░░░] 3% < 1 sec/< 1 sec 18.0 MiB Product Pricing Updates 2/30 [▓░░░░░░░░░░░░░░░░░░░░░░░░░░░] 6% < 1 sec/< 1 sec 18.0 MiB Invoices 3/30 [▓▓░░░░░░░░░░░░░░░░░░░░░░░░░░] 10% < 1 sec/< 1 sec 18.0 MiB Late Fees 4/30 [▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░░] 13% < 1 sec/< 1 sec 18.0 MiB Credit Card Charges 5/30 [▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░░] 16% < 1 sec/< 1 sec 18.0 MiB Invoice & Overdue Reminders 6/30 [▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░░] 20% < 1 sec/< 1 sec 18.0 MiB Domain Renewal Notices 7/30 [▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░░] 23% < 1 sec/< 1 sec 18.0 MiB Cancellation Requests 8/30 [▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░░] 26% < 1 sec/< 1 sec 18.0 MiB Overdue Suspensions 9/30 [▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░░] 30% < 1 sec/< 1 sec 18.0 MiB Overdue Terminations 10/30 [▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░░] 33% < 1 sec/< 1 sec 18.0 MiB Fixed Term Terminations 11/30 [▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░░] 36% < 1 sec/< 1 sec 18.0 MiB Inactive Tickets 12/30 [▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░░] 40% < 1 sec/< 1 sec 18.0 MiB Prune Ticket Attachments 13/30 [▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░░] 43% < 1 sec/< 1 sec 18.0 MiB Delayed Affiliate Commissions 14/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░░] 46% < 1 sec/< 1 sec 18.0 MiB Affiliate Reports 15/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░] 50% < 1 sec/< 1 sec 20.0 MiB Email Marketer Rules 16/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░░] 53% < 1 sec/< 1 sec 20.0 MiB SSL Sync 17/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░░] 56% 3 mins/5 mins 20.0 MiB Credit Card Expiry Notices 18/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░░] 60% 3 mins/5 mins 20.0 MiB Server Usage Stats 19/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░░] 63% 3 mins/4 mins 20.0 MiB Overage Billing Charges 20/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░░] 66% 3 mins/4 mins 20.0 MiB Client Status Update 21/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░░] 70% 3 mins/4 mins 20.0 MiB Domain Expiry 22/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░░] 73% 3 mins/4 mins 20.0 MiB Ticket Escalation Rules 23/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░] 76% 3 mins/4 mins 20.0 MiB Data Retention Pruning 24/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░] 80% 3 mins/3 mins 20.0 MiB Update Server Usage 25/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░] 83% 3 mins/3 mins 20.0 MiB Update Server Meta Data 26/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░] 86% 3 mins/3 mins 20.0 MiB Run Jobs Queue 27/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░] 90% 3 mins/3 mins 20.0 MiB WHMCS Updates 28/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░] 93% 3 mins/3 mins 24.0 MiB Domain Transfer Status Synchronisation 29/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░] 96% 3 mins/3 mins 24.0 MiB Domain Status Synchronisation 30/30 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% 3 mins/3 mins 24.0 MiB Sending Daily Cron Digest email Executing System Queue ---------------------- 4/4 [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓] 100% < 1 sec/< 1 sec 24.0 MiB [OK] Completed Here are the automation settings: How can we check the problem deeper and fix it? do we need a module or somthing? 0 Quote Link to comment Share on other sites More sharing options...
WHMCS ChrisD Posted February 6, 2020 Share Posted February 6, 2020 @NJadire can you please confirm if you see any suspension errors under Utilities > Logs > Activity Log 0 Quote Link to comment Share on other sites More sharing options...
WHMCS Developer WHMCS Andrew Posted February 6, 2020 WHMCS Developer Share Posted February 6, 2020 20 hours ago, NJadire said: Actually we do not use any module to suspend the service Hi, You would need a module of some kind in order to automatically suspend the services. If a remote connection is not required, the auto release module can be used to perform actions like this. 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.