"Something's gone wrong" when host software page is filtered for Vulnerable software and searching for CVE

[jmwatts]

Fleet version: 4.67.0

Web browser and operating system: n/a

---

💥  Actual behavior

Screen.Recording.2025-04-15.at.11.17.37.AM.mov

{
  "message": "Validation Failed",
  "errors": [
    {
      "name": "base",
      "reason": "Error 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY software_titles.id\n\t\t\t) AS combined_results' at line 27"
    }
  ]
}

🧑‍💻  Steps to reproduce

1. From the Host details >> Software page, filter the software list by "Vulnerable software"
2. From the filtered list, attempt to search for one of the CVEs in the list

🕯️ More info (optional)

N/A

[mostlikelee]

Please add your planning poker estimate with Zenhub @ksykulev

[jmwatts]

QA Notes

1. From the Host details >> Software page, filter the software list by "Vulnerable software"
2. From the filtered list, attempt to search for one of the CVEs in the list

• Confirm able to search for items in the filtered list and correct items are returned