Guest

Preview Tool

Cisco Bug: CSCvv04092 - Attempting to view events generates incorrect sql

Last Modified

Aug 31, 2020

Products (1)

  • Sourcefire Defense Center

Known Affected Releases

6.6.0

Description (partial)

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)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.