I am encountering two issues after updating to hestia version 1.9.1. The first issue is with backups. It is no longer possible to download them. Clicking the download button results in an error saying the url is invalid. The second issue occurs in phpmyadmin when the selected language is not English. After logging in, I get the following error: SET lc_messages = 'de_DE'; #1231 - Variable 'lc_messages' can't be set to the value of 'de_DE'. Any help to resolve these problems would be greatly appreciated
Issue 1: phpMyAdmin Language Setting Error
The error youâre encountering in phpMyAdmin when setting a non-English language is due to the lc_messages variable not being supported or available in your MySQL server configuration. Hereâs how you can resolve it:
- Check Available Languages:
- Log in to your MySQL server and run the following command to see the available character sets and collations:
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
- This will help you understand what locales are supported by your MySQL server.
- Update MySQL Configuration:
- If
de_DEis not listed, you might need to add it to your MySQL serverâs configuration. This usually involves installing the appropriate locale packages on your server and configuring MySQL to use them.
- Install Locale Packages:
- On a Debian/Ubuntu-based system, you can install German locale packages using:
sudo apt-get update
sudo apt-get install locales
sudo locale-gen de_DE.UTF-8
sudo update-locale
- After installing, restart MySQL:
sudo systemctl restart mysql
- Modify phpMyAdmin Config:
- As a workaround, you can change the default language in phpMyAdminâs configuration file (
config.inc.php). Locate this file in your phpMyAdmin installation directory and set:
$cfg['Lang'] = 'en'; // Set default language to English
- This will force phpMyAdmin to use English, preventing the error.
Unable to use download backup
You can use this command to download and backup to Windows
scp -P 22 [email protected]:/backup/www_backup_2025-01-05_05-10-15.tar C:\Users\Administrator\Downloads\
You can also use this to upload backups to the server
scp -P 22 C:\Users\Administrator\Downloads\www_backup_2025-01-05_05-10-15.tar [email protected]:/root/
Please backup the files before operation to prevent them from being damaged
Hello!
Same problem unfortunately.
#1231 - Variable âlc_messagesâ canât be set to the value of âhu_HUâ
Help please!
THX!
Make sure to update to Hestia 1.9.2 is has been fixed thereâŚ
Please stop providing incorrect chat gpt based informationâŚ
1 Like
Hello. My Hestia updated 1.9.2:
- Hestia Control Panel v1.9.2
- System Debian 12.8 (x86_64)
And problem for phpmyadmin
Help please!
Error in hestiacp 1.9.2 clean install using language differente from EN
the locale-gen already installed
in my case,
sed -i âs|/usr/share/mysql|/usr/share/mariadb|gâ /etc/mysql/my.cnf
folder /usr/share/mariadb
doesnt exists
in some old installs, existsâŚ
this
ln -s /usr/share/mariadb /usr/share/mysql
solved
Hey eris, iâm on v1.9.3. I have this issue too
â#1231 - Variable âlc_messagesâ canât be set to the value of ânl_NLââ
i rather ask you for a straight forward fix, instead of installing packages (if can be avoided).
What should i follow as a solution?
If used a earlier version of 1.9.3 it might not have been included:
atp install hestia --reinstall will download the latest version
Of it was updated to night make sure en_US.UTF-8 is installedâŚ
It doesnât need to be active
apt install -y locales
locale-gen en_US.UTF-8
update-locale LANG=en_US.UTF-8
source /etc/default/locale
Iâbe fixed this issue thanks to a russian forum.
Edit the file /etc/mysql/my.cnf
Replace the line lc-messages-dir=/usr/share/mariadb
With lc-messages-dir=/usr/share/mysql
Save and restart mariadb.
Worrks like a charm in all languages
1 Like
Next time try this forum first 
My bad. In my defense, the russian solution to the problem appears before those posts, on DuckDuckGo.
1 Like