[horde] utf8 is not supported by MySQL

[Mike Gabriel]

Hi,

On  Di 26 Jul 2022 17:45:00 CEST, Arjen de Korte wrote:

> Citeren Ferdinand Gruber <fer.grub at yahoo.de>:
>
>> I get this message utf8 is not supported by MySQL after login to my  
>> horde site.
>>
>> This message appears after I upgraded from openSUSE 15.3 to 15.4.
>>
>> I suspect it has something to do with the database version
>>
>> In Suse 15.3 the MariaDB version was 10.6.16
>> In Suse 15.4 the MariaDB version is 10.6.7
>>
>> I think this might be the reason of the error.
>>
>> What can I do?
>
> Change
>
>    $conf['sql']['charset'] = 'utf8';
>
> to
>
>    $conf['sql']['charset'] = 'utf8mb3';
>
> in your 'horde/config/conf.php' file.


Or apply this (partial) patch to Horde_Db:
https://salsa.debian.org/horde-team/php-horde-db/-/blob/debian-sid/debian/patches/1012_php8.1.patch#L487

(where I default to utf8mb4)

Mike

-- 

DAS-NETZWERKTEAM
c\o Technik- und Ökologiezentrum Eckernförde
Mike Gabriel, Marienthaler Str. 17, 24340 Eckernförde
mobile: +49 (1520) 1976 148
landline: +49 (4351) 850 8940

GnuPG Fingerprint: 9BFB AEE8 6C0A A5FF BF22  0782 9AF4 6B30 2577 1B31
mail: mike.gabriel at das-netzwerkteam.de, http://das-netzwerkteam.de

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 851 bytes
Desc: Digitale PGP-Signatur
URL: <https://lists.horde.org/archives/horde/attachments/20220816/3af9fa92/attachment.sig>