SQL error: possible conflict with upgrade to PHP8

[maverick85]

Hi,

This is an error which did not occur prior to moving to PHP8. We have updated WHMCS to 8.6.1 and OpenProvider WHMCS module with the with the idna_convert.class.php fix for PHP8 compatibility.

Now, when cron runs we get the following error:

# runuser -uapache -- php -q /var/www/app/crons/cron.php -F -vvv

WHMCS Automation Task Utility: all
==================================

SQLSTATE[HY093]: Invalid parameter number (SQL: select * from `openprovidersslnew_orders` where `status` = PAI) Daily Cron Automation Mode

This error does not prevent cron from completing, simply issues this message every time it runs. In the given example we ran it manually.

[sapillai]

Hi @maverick85,

Thank you for reporting the issue.

I was able to recreate the problem with PHP 8.1 and it has been added to our to-do list.