Закомментировать данный код в chosen.jquery.js
AbstractChosen.browser_is_supported = function() {
/*
if ("Microsoft Internet Explorer" === window.navigator.appName) {
return document.documentMode >= 8;
}
if (/iP(od|hone)/i.test(window.navigator.userAgent) || /IEMobile/i.test(window.navigator.userAgent) || /Windows Phone/i.test(window.navigator.userAgent) || /BlackBerry/i.test(window.navigator.userAgent) || /BB10/i.test(window.navigator.userAgent) || /Android.*Mobile/i.test(window.navigator.userAgent)) {
return false;
}
*/
return true;
};
Для нормальной работы ui на мобильных устройствах подключить https://github.com/furf/jquery-ui-touch-punch
shell скрипт для автоматического изменения кодировки таблиц и столбцов с utf8 на utf8mb4
#!/bin/bash
# mycollate.sh <database> [<charset> <collation>]
# changes MySQL/MariaDB charset and collation for one database - all tables and
# all columns in all tables
DB="$1"
CHARSET="$2"
COLL="$3"
AUTH="-uuser -ppass"
[ -n "$DB" ] || exit 1
[ -n "$CHARSET" ] || CHARSET="utf8mb4"
[ -n "$COLL" ] || COLL="utf8mb4_general_ci"
echo $DB
echo "ALTER DATABASE \`$DB\` CHARACTER SET $CHARSET COLLATE $COLL;" | mysql $AUTH
echo "USE \`$DB\`; SHOW TABLES;" | mysql -s $AUTH | (
while read TABLE; do
echo $DB.$TABLE
echo "ALTER TABLE \`$TABLE\` CONVERT TO CHARACTER SET $CHARSET COLLATE $COLL;" | mysql $AUTH $DB
done
)
https://dba.stackexchange.com/questions/8239/how-to-easily-convert-utf8-tables-to-utf8mb4-in-mysql-5-5
Добавить muted=true
, например:
Автоматический перезапуск mariadb если она не активна (Script for checking mariadb status and restarting if it is inactive).
Скрипт:
#!/bin/bash
STATUS=$(/bin/systemctl is-active mariadb.service);
if [ $STATUS != 'active' ]
then
/bin/systemctl restart mariadb.service
fi
Cron (каждые 5 минут)
*/5 * * * * /var/scripts/check_mariadb.sh