Cisco Bug: CSCvv04092 - Attempting to view events generates incorrect sql
Aug 31, 2020
- Sourcefire Defense Center
Known Affected Releases
Symptom: httpsd_error_log contains the following error messages Failed Executing Count Query with DBD::mysql::st execute failed: 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 'AS event WHERE (event.`reviewed` = '0' AND ((event.`sensor_id` = '2' AND event.' at line 1: /usr/local/sf/htdocs/events/index.cgi, referer: https://XXX.XXX.XXX.XX/events/index.cgi AND (Unable to process this query. Please contact support.) in /usr/local/sf/htdocs/events/index.cgi:1077 at /usr/local/sf/lib/perl/5.10.1/SF.pm line 120.: /usr/local/sf/htdocs/events/index.cgi, referer: https://XXX.XXX.XXX.XX/events/index.cgi Conditions: Customer is trying to review intrusion events.
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.
Bug Details Include
- Full Description (including symptoms, conditions and workarounds)
- Known Fixed Releases
- Related Community Discussions
- Number of Related Support Cases