Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23362

Filtering by name doesn't work in mysql for some special character such as `

XMLWordPrintable

    • Documentation backlog, Sprint 104 (Sep 2023), Sprint 105 (Oct 2023), S24-W20/21, S24-W22/23
    • 1

      Steps to reproduce:

      1. Go to Configuration -> Maintenance (or other)
      2. Create new maintenance with name ȼ or ɇ (probably some others)
      3. Type ȼ in filter name field
      4. Apply filter

      Result:
      No data found
      Expected: found maintenance by name

      If you look in debug, the sql query has the character in upper case, maybe this is the problem:

      SQL (0.000298): SELECT m.maintenanceid,m.name,m.maintenance_type,m.active_since,m.active_till,m.description FROM maintenances m WHERE ((UPPER(m.name) LIKE '%Ȼ%' ESCAPE '!')) ORDER BY m.maintenance_type DESC LIMIT 1001
      zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerMaintenanceList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CMaintenance->get() → DBselect() in include/classes/api/services/CMaintenance.php:232
      

            martins-v Martins Valkovskis
            natalja.zabbix Natalja Romancaka
            Team B
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - Not Specified
                Not Specified
                Logged:
                Time Spent - 6.95h
                6.95h