An operation fails in Plesk: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'X' for key 'PRIMARY'
How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.0/10.1/10.2 on Linux?
Unable to create MSSQL databases: There are no available resources of this type (MySQL databases) left
PHPmyadmin templates are removed after updating Plesk
MariaDB does not start after update on November the 5th: Assertion failure in file
Error on attempt to create new database or user: Unable to find row with id in DatabaseServers table
MariaDB 10.3 error after upgrade: Plugin 'unix_socket' is not loaded
MSSQL databases take long time to load on Plesk server
Cannot add PostgreSQL with custom port in Plesk: Is the server running locally and accepting connections on Unix domain socket
MySQL instance is stopped and set as Manual Startup during Updates

See more

Websites show garbled characters after Plesk update

Updated October 20, 2019 21:57

Applicable to:

Plesk Onyx for Linux

Symptoms

After Plesk micro-update websites show garbled characters;
Custom changes in my.ini file are overwritten after microupdate;
Previously default charset was changed from latin1 to some custom value, for example, to utf8, for client MySQL server in %plesk_dir%Databases\MySQL\my.ini;
After Plesk update charset was reset to default one.
The my.ini file in %plesk_dir%\Databases\MySQL\my.ini is always changing

Cause

Product issue:

#PPPM-10178 "Client my.ini 'character-set-server ' option is reset to default after MU"
Fixed in:
- Plesk Obsidian 12 March 2019 (fixed as PPP-41116)

Resolution

Please consider updating your server:

How to install Plesk updates

Workaround

If update is not possible for some reason you may try the following

temporary solution

As workaround, until fix available:

Login server via RDP;
Manually change charset back in %plesk_dir%Databases\MySQL\my.ini.

Comments

0 comments

Please sign in to leave a comment.

Have more questions? Submit a request