Resolved SQLSTATE[HY000] [2019] Can't initialize character set utf8mb4 (path: /usr/share/mysql/charsets/)

Hello,
May I know which Joomla version you are using? As per the error MySQL is missing utf8mb4 character set and that is the same character set used by Joomla. Run the below query and check the list of character sets.

show character set like 'utf%';

One possible reason for this missing character set is that you must be using very old MySQL version.

Charset Description Default collation
utf8mb3 UTF-8 Unicode utf8mb3_general_ci
utf8mb4 UTF-8 Unicode utf8mb4_general_ci
utf16 UTF-16 Unicode utf16_general_ci
utf16le UTF-16LE Unicode utf16le_general_ci
utf32 UTF-32 Unicode utf32_general_ci

Joomla ‎4.4.12
Database Version 10.6.20-MariaDB-cll-lve
Database Collation utf8mb4_general_ci
Database Connection Collation utf8mb4_general_ci
PHP 8.1.32

Hello,
You do have utf8mb4 character set in the list. Interesting part is that utf8mb4 is also used by Joomla and you see error only with RO CSVI exports. One way is to change character set in file administrator/components/com_csvi/models/exports.php on line number 139 from charset=utf8mb4 to any other supported character set may be charset=utf8mb3 or something else and see if it works. Not sure if that will work but can give it a try.

Another solution is that with RO CSVI 8.1.0 version we changed exports to use PDO driver and that uses utf8mb4 character set. I suggest to install RO CSVI 8.0.0 version and check if export works. That will tell us if PDO driver is the problem with your server.

By changing the charset to utf8mb3 in the exports.php file the export works.

Installing of version 8.0.0 is not possible I get:

"An error occured running the query ALTER TABLE `pre_csvi_availabletables` MODIFY `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0' ;. This generates the error Data truncated for column 'checked_out' at row 1"

Hello,

By changing the charset to utf8mb3 in the exports.php file the export works.

That character set is available on your server so export works. I really wonder how Joomla works as it also uses utf8mb4 character set. Anyways if export works with utf8mb3 you can continue to use that.

Hi,

Installing of version 8.0.0 is not possible I get:



"An error occured running the query ALTER TABLE `pre_csvi_availabletables` MODIFY `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0' ;. This generates the error Data truncated for column 'checked_out' at row 1"

Are there any old version tables of RO CSVI in the site? The only reason this will happen is when the checked_out field has a value that cannot be converted to an integer of size 11. That is a lot of digits

You can update the field by running this query:

UPDATE TABLE `pre_csvi_availabletables` SET `checked_out` = 0;

Run the update after that and see if it works or another error occurs.

Let us know how it goes.