Product import fails with fatal error

[simonr44]

Issue

When importing products via CSV file on a server running PHP 8.2 the following error is thrown when reaching the product prices within the import.

PHP Fatal error: Uncaught TypeError: mb_substr(): Argument #3 ($length) must be of type ?int, string given in /var/www/include/utils.php:5149

This is caused by the price vardefs which are in the format 26,4 with 26 representing the overall length and 4 representing the potential decimals.

In PHP8.2 this throws a fatal error and prevents the import from completing.

Expected Behavior

The CSV import process should complete as expected.

Actual Behavior

The import fails with no errors displayed through the UI, just an empty warning box.

Possible Fix

Fix branch to follow

Steps to Reproduce

1. Prepare an import CSV with the required fields and at least one price
2. Import the CSV
3. The import will fail and the 500 fatal error logged

Context

Relatively high priority as it impacts users importing products

Your Environment

• SuiteCRM Version used: 7.14.2
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Chrome Version 122.0.6261.94 (Official Build) (64-bit)
• Environment name and version (e.g. MySQL, PHP 7): PHP 8.2
• Operating System and version (e.g Ubuntu 16.04): Debian 11