Display Text does not work

[Rick_Huang]

In the “Availability Map” widget, When “mode select” set to “only services”, no matter you choose Hostname or Sysname for “Display Text” field, the boxes display empty.

Version	21.2.0-46-g9cd963e3a - Thu Mar 11 2021 21:28:53 GMT+0800
Database Schema	2021_02_21_203415_location_add_fixed_coordinates_flag (200)
Web Server	Apache/2.4.41 (Ubuntu)
PHP	7.4.3
Python	3.8.5
MySQL	5.7.33
Laravel	8.27.0
RRDtool	1.7.2

[Kevin_Krumm]

Please run

./validate.php and post the return.

[Rick_Huang]

librenms@pi4b:~$ ./validate.php

Component	Version
LibreNMS	21.2.0-52-g61316ce2c
DB Schema	2021_02_21_203415_location_add_fixed_coordinates_flag (200)
PHP	7.4.3
Python	3.8.5
MySQL	5.7.33
RRDTool	1.7.2
SNMP	NET-SNMP 5.8

====================================

[OK] Composer Version: 2.0.11
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] MySQL tables collation is wrong:
[FIX]:
Check http://bit.ly/2lAG9H8 for info on how to fix.
Tables:
alert_device_map utf8mb4 utf8mb4_unicode_ci
alert_group_map utf8mb4 utf8mb4_unicode_ci
alert_location_map utf8mb4 utf8mb4_unicode_ci
alert_schedulables utf8mb4 utf8mb4_unicode_ci
alert_transport_groups utf8mb4 utf8mb4_unicode_ci
alert_transport_map utf8mb4 utf8mb4_unicode_ci
alert_transports utf8mb4 utf8mb4_unicode_ci
application_metrics utf8mb4 utf8mb4_unicode_ci
availability utf8mb4 utf8mb4_unicode_ci
cache utf8mb4 utf8mb4_unicode_ci
cache_locks utf8mb4 utf8mb4_unicode_ci
cef_switching utf8mb4 utf8mb4_unicode_ci
component utf8mb4 utf8mb4_unicode_ci
component_prefs utf8mb4 utf8mb4_unicode_ci
component_statuslog utf8mb4 utf8mb4_unicode_ci
and 50 more…
[FAIL] MySQL column collation is wrong:
[FIX]:
Check https://t.libren.ms/-zdwk for info on how to fix.
Columns:
alert_rules rule utf8mb4 utf8mb4_unicode_ci
alert_rules severity utf8mb4 utf8mb4_unicode_ci
alert_rules extra utf8mb4 utf8mb4_unicode_ci
alert_rules name utf8mb4 utf8mb4_unicode_ci
alert_rules query utf8mb4 utf8mb4_unicode_ci
alert_rules builder utf8mb4 utf8mb4_unicode_ci
alert_rules proc utf8mb4 utf8mb4_unicode_ci
alert_schedulables alert_schedulable_type utf8mb4 utf8mb4_unicode_ci
alert_templates name utf8mb4 utf8mb4_unicode_ci
alert_templates template utf8mb4 utf8mb4_unicode_ci
alert_templates title utf8mb4 utf8mb4_unicode_ci
alert_templates title_rec utf8mb4 utf8mb4_unicode_ci
alert_transport_groups transport_group_name utf8mb4 utf8mb4_unicode_ci
alert_transport_map target_type utf8mb4 utf8mb4_unicode_ci
alert_transports transport_name utf8mb4 utf8mb4_unicode_ci
and 260 more…
[OK] Database schema correct