Details
-
Bug
-
Resolution: Fixed
-
None
-
Critical
-
The user will no longer receive an error when the customer was deleted.
-
Empty show more show less
Description
Example of the query which produces the problem in php8 and it was working with php 7.4:
$sql = "UPDATE `LEK_languageresources_usage_log` SET `customers` = replace(customers, ',?,', ',')"; $this->db->getAdapter()->query($sql,$customerId);
$customerId is integer function argument.
It seams like that the binding argument is evaluated differently(in our case as string) or not even replaced in the placeholder by php8. This problem possibly can happen because of change in php8 pdo where PDO::PARAM_INT is treated the same as PDO::PARAM_STR in one of the PDO classes. More pdo changes related to this problem can be found in the php8 changelog page: https://www.php.net/ChangeLog-8.php
This problem does not effect any other translate5 code so far.