cron error after upgrade to 2.2.173

[Andreix]

After upgrading to 2.2.173 we gt following error on cron:

In Hook.php line 7988:

  [PDOException (HY000)]
  SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '0000-00-00'

Exception trace:
  at /home/whmcs/devhostinghub/modules/addons/BillingExtension/core/BillingExtension_Admin/Hook.php:7988
 PDOStatement->execute() at /home/whmcs/devhostinghub/modules/addons/BillingExtension/core/BillingExtension_Admin/Hook.php:7988
 BillingExtension\BillingExtension_Admin\Hook->check_for_updates() at /home/whmcs/devhostinghub/modules/addons/BillingExtension/hooks.php:445
 BillingExtension_DailyCronJob() at /home/whmcs/devhostinghub/vendor/whmcs/whmcs-foundation/lib/Hook/Manager.php:0
 WHMCS\Hook\Manager->run() at /home/whmcs/devhostinghub/vendor/illuminate/support/Facades/Facade.php:261
 Illuminate\Support\Facades\Facade::__callStatic() at /home/whmcs/devhostinghub/includes/functions.php:0
 run_hook() at /home/whmcs/devhostinghub/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Helper/DailyCronHelper.php:0
 WHMCS\Cron\Console\Helper\DailyCronHelper->endDailyCron() at /home/whmcs/devhostinghub/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AllCommand.php:0
 WHMCS\Cron\Console\Command\AllCommand->afterExecution() at /home/whmcs/devhostinghub/vendor/whmcs/whmcs-foundation/lib/Cron/Console/Command/AbstractCronCommand.php:0
 WHMCS\Cron\Console\Command\AbstractCronCommand->execute() at /home/whmcs/devhostinghub/vendor/symfony/console/Command/Command.php:298
 Symfony\Component\Console\Command\Command->run() at /home/whmcs/devhostinghub/vendor/symfony/console/Application.php:1028
 Symfony\Component\Console\Application->doRunCommand() at /home/whmcs/devhostinghub/vendor/symfony/console/Application.php:299
 Symfony\Component\Console\Application->doRun() at /home/whmcs/devhostinghub/vendor/symfony/console/Application.php:171
 Symfony\Component\Console\Application->run() at /home/whmcs/devhostinghub/crons/cron.php:0

all [-F|--force] [--email-report [EMAIL-REPORT]]
 

2.2.169 works good. We dont anve any inbetween to test.

[Kian]

Hi,

the error should be caused by SQL Mode which could be in "strict mode". This should be turned off as explained here by WHMCS (WHMCS does not support strict mode yet. Same goes with BX).

Btw I can implement a workaround but I still recommend you disable strict mode as similar errors can trigger in other parts of BX, in other modules and also in WHMCS itself.

[Kian]

I confirm you that next release should fix the error but again you should disable strict mode.

I'm still unsure if WHMCS 8.6 now supports strict mode but it seems that it doesn't so my recommendation is still valid.

Edited November 30, 2022 by Kian

[Andreix]

Yes I disabled strict mode and its working now.

Mille grazie