Catch
Variables
struct
ALERTACTIVE 0
CFHTTP
struct
Charset [empty string]
ErrorDetail [empty string]
Filecontent id,cdate,alerttext,alerttype,isactive 1,3/6/2016,"<p>On March 6, 2016, at approximately 3:55 a.m., two unidentified males, one approximately 6 feet tall, armed with a black handgun with a laser pointer, wearing a black jacket, grey beanie type hat and black shoes, the second offender approximately 5'9"" tall, approached three males in the parking lot of the Hampton Harbor apartments, presented a handgun and began searching the victim's belongings. Items taken are described as such: one wallet containing a Michigan state operator's license, an HU student ID card, two Chase debit cards, and five dollars in cash. A second wallet containing NWFCU debit/credit cards, NFCU debit/credit cards, a Virginia Operator's License, a Blue Cross ID, and a NOVA school ID. The incident is currently being investigated by the Hampton Police Division. The suspects were seen fleeing the area in a bluish car with a letter H"" symbol on the front bumper. The victims were not physically harmed. </p><p>Caution: Subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If you have any information that would aid in the investigation and arrests of these subjects, please call the HU Police Department immediately: (757) 727-5300/5259.</p>",Robbery,1 2,7/6/2015,"<p>On July 6, 2015, at approximately 7:35pm, an armed robbery occurred on Mariner's Cove Road in the Hampton Harbors Apartments Complex. Two subjects entered an occupied parked vehicle, displayed handguns, and demanded money and other property from the vehicle owner. Two handguns and approximately $1300.00 U.S. currency was taken from the victim. Both subjects exited the vehicle and fled on foot in the direction of buildings 45/47 Mariner's Cove Road.</p> <p>Suspect #1 is described as a black male, approximately 5' 10"", short dreadlock hairstyle, last seen wearing a black button-up shirt, and goes by the name ""Munchie Montana.""</p> <p>Suspect #2 is described as a black male, approximately 5'10"" tall, and goes by the Jaemon Gatling (DOB: 4/28/1993).</p> <p>Caution: Both subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If seen, or information of their whereabouts is known, please call the HU Police Department immediately: (757) 727-5300/5259.</p>",Robbery,1 3,2/20/2016,"<p>On February 20, 2016, at approximately 3:19 a.m., three unidentified armed subjects, wearing hoodies and masks, gained entry into a Hampton Harbor apartment by knocking on the door. Once inside, the victims were ordered lay down on the floor. The armed subjects took several personal items from the victims and fled on-foot in an undisclosed direction. Officers from the Hampton Police Division and Hampton University Police Department canvassed the area but were unsuccessful at locating the suspects or any witnesses. This incident is currently being investigated by the Hampton Police Division. There victims were not physically harmed during this incident.</p><p>Caution: Subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If you have any information that would aid in the investigation and arrests of these subjects, please call the HU Police Department immediately: (757) 727-5300/5259.</p>",Robbery,1 4,3/2/2016,"<p>On March 2, 2016, at approximately 1:51 a.m., two unidentified males, dressed in black and wearing hoodies, forcefully gained entry into a Hampton Harbors apartment. Once inside, one of the subjects presented a handgun and demanded the occupants to ""shut up"" while the second subject went directly to a rear bedroom. Several items, to include a cash box containing money, were taken from the rear bedroom. Both subjects then fled the apartment on-foot. An unknown male was seen walking fast toward a swamp area of the property after hearing what sounded like a gunshot and a girl screaming. Hampton University Police and Hampton Police officers canvassed the area. No suspects or witnesses were found. The victims were not physically harmed. This incident is currently being investigated by HUPD and the Hampton Police Division.</p><p>Caution: Subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If you have any information that would aid in the investigation and arrests of these subjects, please call the HU Police Department immediately: (757) 727-5300/5259.</p>",Robbery,1 5,8/13/2015,"<p>On August 13, 2015, at approximately 2:41 a.m., the Hampton Police Department notified Hampton University Police Department of a disorderly person in the area of 93A Mariner's Cove Rd of the Hampton Harbors Apartments that shortly turned into a domestic stabbing. The victim was taken to a nearby hospital and the suspect is reported being taken into custody by Hampton Police, and later charged with drunk in public and aggravated assault. The victims' wounds were considered non-life threatening and the victim was treated and released from a nearby hospital the same day. The knife used in the incident was recovered and tagged into evidence by Hampton Police Officers. Details of this incident can be found on the Hampton Police file report (CFS #2015-022577).</p>",Stabbing,1
Header HTTP/1.1 200 OK Date: Sat, 23 Jun 2018 09:44:46 GMT Server: Apache/2.4.18 (Ubuntu) Last-Modified: Thu, 28 Apr 2016 19:09:14 GMT ETag: "1458-53190431a91d5" Accept-Ranges: bytes Content-Length: 5208 Connection: close Content-Type: text/csv
Mimetype text/csv
Responseheader
struct
Accept-Ranges bytes
Connection close
Content-Length 5208
Content-Type text/csv
Date Sat, 23 Jun 2018 09:44:46 GMT
ETag "1458-53190431a91d5"
Explanation OK
Http_Version HTTP/1.1
Last-Modified Thu, 28 Apr 2016 19:09:14 GMT
Server Apache/2.4.18 (Ubuntu)
Status_Code 200
Statuscode 200 OK
Text YES
CFQUERY.EXECUTIONTIME 1
CHECKENS
query
  LEVEL
I url.good14
PAGETITLE HUPD : Crime Alert
ROGUE url.good,url.goods,url.good14
THEADDRESS http://police.hamptonu.edu/crime-alerts.csv
cferror
struct
Browser CCBot/2.0 (http://commoncrawl.org/faq/)
DateTime {ts '2018-06-23 05:44:46'}
Diagnostics Error Executing Database Query. <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, <br>The error occurred on line 29.
GeneratedContent <!DOCTYPE html> <html> <head> <meta charset='utf-8' /> <meta name="viewport" content="initial-scale=1" /> <link rel="stylesheet" type="text/css" href="http://cms.hamptonu.edu/assets/css/base24.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/global/css/type.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/global/css/huGlobal.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/global/css/highslide.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/secondary/css/secondary.css" /> <script src="http://www.hamptonu.edu/a/global/js/jquery1.11.js"></script> <script src="http://www.hamptonu.edu/a/global/js/base.js.cfm"></script> <script src="http://www.hamptonu.edu/a/global/js/highslide.js"></script> <script src="http://www.hamptonu.edu/a/global/js/highslide.init.js"></script> <title> HUPD : Crime Alert </title> <style> .crimeitem{background:#fff;padding:10px} span.date{float:right;} </style> </head> <body> <div class="container"> <div class="header"> <div class="section"> <div class="w8"> <a href="http://www.hamptonu.edu"> <img src="http://www.hamptonu.edu/a/global/img/wordmark.png" alt="Hampton University" id="wordmark"> </a> <a id="menutoggle"><img src="http://www.hamptonu.edu/a/global/img/menu_toggle.png" alt="Menu" /></a> </div> <div class="w16"> <div class="nav"> <ul> <li><a href="http://president.hamptonu.edu">President's Corner</a></li> <li><a href="http://www.hamptonu.edu/gateways/aspiring.cfm">Aspiring Students</a></li> <li><a href="http://www.hamptonu.edu/gateways/current.cfm">Current Students</a></li> <li><a href="http://www.hamptonu.edu/gateways/parents.cfm">Parents</a></li> <li><a href="http://www.hamptonu.edu/gateways/facstaff.cfm">Faculty/Staff</a></li> <li><a href="http://www.hamptonu.edu/gateways/alumni.cfm">Alumni</a></li> </ul> </div> <div class="search cl"> <form action="http://www.hamptonu.edu/search.cfm" id="cse-search-box"> <input type="hidden" name="cx" value="002604857162084967162:ocslsxmyrci" /> <input type="hidden" name="cof" value="FORID:10" /> <input type="hidden" name="ie" value="UTF-8" /> <input type="text" name="q" id="q" style="width:76.5%" /> <input type="image" alt="Search" id="search_button" src="http://www.hamptonu.edu/a/global/img/search.png" /> </form> </div> </div> </div> </div> <div class="featured"> </div> <div class="maincontent"> <div class="section secondaryheader"> <h1>HUPD : Crime Alert</h1> </div> <div class="section seccontent"> <div class="tal"> <div class="w5"> <div class="localnav"> <ul> <li class="menulabel"><h3>Pages</h3></li> <li><a href="/">HUPD Home</a></li> <li><a href="/message-from-chief-glover">A Message From Chief Glover</a></li> <li><a href="/crime-alert">Crime Alerts</a></li> <li><a href="/crime-prevention">Crime Prevention</a></li> <li><a href="/investigations">Investigations</a></li> <li><a href="/pns">Pirate Notification System (PNS)</li> <li><a href="/traffic-administration">Traffic Administration</a></li> <li><a href="/crime-statistics">Crime Statistics</a></li> <li><a href="/employment-opportunities">Employment Opportunities</a></li> <li><a href="/fire-safety">Fire Safety</a></li> <li><a href="http://www.mingerfoundation.org/9-fires/">Michael H. Minger Foundation</a></li> <li><a href="/how-are-we-doing">How Are We Doing?</a></li> <li><a href="https://www.tipsubmit.com/WebTips.aspx?AgencyID=1087" target="_blank">Submit an Anonymous Tip</a></li> <li><a href="http://www.hamptonu.edu/compliance/title9/">Policy on Sexual Harassment and Misconduct</a></li> <li><a href="/sex-offender-registry">Virginia State Police<br />Sex Offender Registry</a></li> <li><a href='/annual-security-report'>Annual Security Report (ASR)</a></li> </ul> </div><h3 class="menulabel">Social Media</h3> <a href="https://www.facebook.com/HamptonUniversityPolice"> <img src="http://img.hamptonu.edu/assets/global/facebook.png" alt="Facebook" /> </a> </div> <div class="w1"></div> <div class="w12"> <div class="crimeitem">
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString alertid=3
RemoteAddress 54.162.165.158
RootCause
struct
Cause
struct
ErrorCode 0
Message <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
StackTrace java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Type java.sql.SQLException
Detail <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
ErrorCode n/a
Exceptions
array
1
struct
class java.sql.SQLException
message <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
StackTrace java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Type java.sql.SQLException
SQLState n/a
Sql SELECT * FROM queueSheet WHERE isactive AND id = 3 ORDER BY cdate DESC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 44 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Type Database
queryError <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 44 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Template /crime-alert.cfm
Type coldfusion.runtime.CfErrorWrapper
error
struct
Browser CCBot/2.0 (http://commoncrawl.org/faq/)
DateTime {ts '2018-06-23 05:44:46'}
Diagnostics Error Executing Database Query. <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, <br>The error occurred on line 29.
GeneratedContent <!DOCTYPE html> <html> <head> <meta charset='utf-8' /> <meta name="viewport" content="initial-scale=1" /> <link rel="stylesheet" type="text/css" href="http://cms.hamptonu.edu/assets/css/base24.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/global/css/type.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/global/css/huGlobal.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/global/css/highslide.css" /> <link rel="stylesheet" type="text/css" href="http://www.hamptonu.edu/a/secondary/css/secondary.css" /> <script src="http://www.hamptonu.edu/a/global/js/jquery1.11.js"></script> <script src="http://www.hamptonu.edu/a/global/js/base.js.cfm"></script> <script src="http://www.hamptonu.edu/a/global/js/highslide.js"></script> <script src="http://www.hamptonu.edu/a/global/js/highslide.init.js"></script> <title> HUPD : Crime Alert </title> <style> .crimeitem{background:#fff;padding:10px} span.date{float:right;} </style> </head> <body> <div class="container"> <div class="header"> <div class="section"> <div class="w8"> <a href="http://www.hamptonu.edu"> <img src="http://www.hamptonu.edu/a/global/img/wordmark.png" alt="Hampton University" id="wordmark"> </a> <a id="menutoggle"><img src="http://www.hamptonu.edu/a/global/img/menu_toggle.png" alt="Menu" /></a> </div> <div class="w16"> <div class="nav"> <ul> <li><a href="http://president.hamptonu.edu">President's Corner</a></li> <li><a href="http://www.hamptonu.edu/gateways/aspiring.cfm">Aspiring Students</a></li> <li><a href="http://www.hamptonu.edu/gateways/current.cfm">Current Students</a></li> <li><a href="http://www.hamptonu.edu/gateways/parents.cfm">Parents</a></li> <li><a href="http://www.hamptonu.edu/gateways/facstaff.cfm">Faculty/Staff</a></li> <li><a href="http://www.hamptonu.edu/gateways/alumni.cfm">Alumni</a></li> </ul> </div> <div class="search cl"> <form action="http://www.hamptonu.edu/search.cfm" id="cse-search-box"> <input type="hidden" name="cx" value="002604857162084967162:ocslsxmyrci" /> <input type="hidden" name="cof" value="FORID:10" /> <input type="hidden" name="ie" value="UTF-8" /> <input type="text" name="q" id="q" style="width:76.5%" /> <input type="image" alt="Search" id="search_button" src="http://www.hamptonu.edu/a/global/img/search.png" /> </form> </div> </div> </div> </div> <div class="featured"> </div> <div class="maincontent"> <div class="section secondaryheader"> <h1>HUPD : Crime Alert</h1> </div> <div class="section seccontent"> <div class="tal"> <div class="w5"> <div class="localnav"> <ul> <li class="menulabel"><h3>Pages</h3></li> <li><a href="/">HUPD Home</a></li> <li><a href="/message-from-chief-glover">A Message From Chief Glover</a></li> <li><a href="/crime-alert">Crime Alerts</a></li> <li><a href="/crime-prevention">Crime Prevention</a></li> <li><a href="/investigations">Investigations</a></li> <li><a href="/pns">Pirate Notification System (PNS)</li> <li><a href="/traffic-administration">Traffic Administration</a></li> <li><a href="/crime-statistics">Crime Statistics</a></li> <li><a href="/employment-opportunities">Employment Opportunities</a></li> <li><a href="/fire-safety">Fire Safety</a></li> <li><a href="http://www.mingerfoundation.org/9-fires/">Michael H. Minger Foundation</a></li> <li><a href="/how-are-we-doing">How Are We Doing?</a></li> <li><a href="https://www.tipsubmit.com/WebTips.aspx?AgencyID=1087" target="_blank">Submit an Anonymous Tip</a></li> <li><a href="http://www.hamptonu.edu/compliance/title9/">Policy on Sexual Harassment and Misconduct</a></li> <li><a href="/sex-offender-registry">Virginia State Police<br />Sex Offender Registry</a></li> <li><a href='/annual-security-report'>Annual Security Report (ASR)</a></li> </ul> </div><h3 class="menulabel">Social Media</h3> <a href="https://www.facebook.com/HamptonUniversityPolice"> <img src="http://img.hamptonu.edu/assets/global/facebook.png" alt="Facebook" /> </a> </div> <div class="w1"></div> <div class="w12"> <div class="crimeitem">
HTTPReferer [empty string]
Mailto [empty string]
Message Error Executing Database Query.
QueryString alertid=3
RemoteAddress 54.162.165.158
RootCause
struct
Cause
struct
ErrorCode 0
Message <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
StackTrace java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Type java.sql.SQLException
Detail <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
ErrorCode n/a
Exceptions
array
1
struct
class java.sql.SQLException
message <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
StackTrace java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Type java.sql.SQLException
SQLState n/a
Sql SELECT * FROM queueSheet WHERE isactive AND id = 3 ORDER BY cdate DESC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 44 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Type Database
queryError <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
where [empty string]
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:253) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:513) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br> Encountered "isactive AND. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition, at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590) at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547) at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142) at coldfusion.sql.Executive.executeQuery(Executive.java:1541) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 44 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 29
RAW_TRACE at cfcrime2dalert2ecfm250259338.runPage(/var/www/police/crime-alert.cfm:29)
TEMPLATE /var/www/police/crime-alert.cfm
TYPE CFML
Template /crime-alert.cfm
Type coldfusion.runtime.CfErrorWrapper
queueSheet
query
  alerttext alerttype cdate id isactive
1 <p>On March 6, 2016, at approximately 3:55 a.m., two unidentified males, one approximately 6 feet tall, armed with a black handgun with a laser pointer, wearing a black jacket, grey beanie type hat and black shoes, the second offender approximately 5'9" tall, approached three males in the parking lot of the Hampton Harbor apartments, presented a handgun and began searching the victim's belongings. Items taken are described as such: one wallet containing a Michigan state operator's license, an HU student ID card, two Chase debit cards, and five dollars in cash. A second wallet containing NWFCU debit/credit cards, NFCU debit/credit cards, a Virginia Operator's License, a Blue Cross ID, and a NOVA school ID. The incident is currently being investigated by the Hampton Police Division. The suspects were seen fleeing the area in a bluish car with a letter H" symbol on the front bumper. The victims were not physically harmed. </p><p>Caution: Subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If you have any information that would aid in the investigation and arrests of these subjects, please call the HU Police Department immediately: (757) 727-5300/5259.</p> Robbery 3/6/2016 1 1
2 <p>On July 6, 2015, at approximately 7:35pm, an armed robbery occurred on Mariner's Cove Road in the Hampton Harbors Apartments Complex. Two subjects entered an occupied parked vehicle, displayed handguns, and demanded money and other property from the vehicle owner. Two handguns and approximately $1300.00 U.S. currency was taken from the victim. Both subjects exited the vehicle and fled on foot in the direction of buildings 45/47 Mariner's Cove Road.</p> <p>Suspect #1 is described as a black male, approximately 5' 10", short dreadlock hairstyle, last seen wearing a black button-up shirt, and goes by the name "Munchie Montana."</p> <p>Suspect #2 is described as a black male, approximately 5'10" tall, and goes by the Jaemon Gatling (DOB: 4/28/1993).</p> <p>Caution: Both subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If seen, or information of their whereabouts is known, please call the HU Police Department immediately: (757) 727-5300/5259.</p> Robbery 7/6/2015 2 1
3 <p>On February 20, 2016, at approximately 3:19 a.m., three unidentified armed subjects, wearing hoodies and masks, gained entry into a Hampton Harbor apartment by knocking on the door. Once inside, the victims were ordered lay down on the floor. The armed subjects took several personal items from the victims and fled on-foot in an undisclosed direction. Officers from the Hampton Police Division and Hampton University Police Department canvassed the area but were unsuccessful at locating the suspects or any witnesses. This incident is currently being investigated by the Hampton Police Division. There victims were not physically harmed during this incident.</p><p>Caution: Subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If you have any information that would aid in the investigation and arrests of these subjects, please call the HU Police Department immediately: (757) 727-5300/5259.</p> Robbery 2/20/2016 3 1
4 <p>On March 2, 2016, at approximately 1:51 a.m., two unidentified males, dressed in black and wearing hoodies, forcefully gained entry into a Hampton Harbors apartment. Once inside, one of the subjects presented a handgun and demanded the occupants to "shut up" while the second subject went directly to a rear bedroom. Several items, to include a cash box containing money, were taken from the rear bedroom. Both subjects then fled the apartment on-foot. An unknown male was seen walking fast toward a swamp area of the property after hearing what sounded like a gunshot and a girl screaming. Hampton University Police and Hampton Police officers canvassed the area. No suspects or witnesses were found. The victims were not physically harmed. This incident is currently being investigated by HUPD and the Hampton Police Division.</p><p>Caution: Subjects should be considered armed and dangerous. DO NOT attempt to apprehend or approach. If you have any information that would aid in the investigation and arrests of these subjects, please call the HU Police Department immediately: (757) 727-5300/5259.</p> Robbery 3/2/2016 4 1
5 <p>On August 13, 2015, at approximately 2:41 a.m., the Hampton Police Department notified Hampton University Police Department of a disorderly person in the area of 93A Mariner's Cove Rd of the Hampton Harbors Apartments that shortly turned into a domestic stabbing. The victim was taken to a nearby hospital and the suspect is reported being taken into custody by Hampton Police, and later charged with drunk in public and aggravated assault. The victims' wounds were considered non-life threatening and the victim was treated and released from a nearby hospital the same day. The knife used in the incident was recovered and tagged into evidence by Hampton Police Officers. Details of this incident can be found on the Hampton Police file report (CFS #2015-022577).</p> Stabbing 8/13/2015 5 1
CGI
struct
AUTH_PASSWORD [empty string]
AUTH_TYPE [empty string]
AUTH_USER [empty string]
CERT_COOKIE [empty string]
CERT_FLAGS [empty string]
CERT_ISSUER [empty string]
CERT_KEYSIZE [empty string]
CERT_SECRETKEYSIZE [empty string]
CERT_SERIALNUMBER [empty string]
CERT_SERVER_ISSUER [empty string]
CERT_SERVER_SUBJECT [empty string]
CERT_SUBJECT [empty string]
CF_TEMPLATE_PATH /var/www/police/crime-alert.cfm
CONTENT_LENGTH 0
CONTENT_TYPE [empty string]
CONTEXT_PATH [empty string]
GATEWAY_INTERFACE [empty string]
HTTPS off
HTTPS_KEYSIZE [empty string]
HTTPS_SECRETKEYSIZE [empty string]
HTTPS_SERVER_ISSUER [empty string]
HTTPS_SERVER_SUBJECT [empty string]
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE [empty string]
HTTP_CONNECTION close
HTTP_COOKIE [empty string]
HTTP_HOST police.hamptonu.edu
HTTP_REFERER [empty string]
HTTP_URL [empty string]
HTTP_USER_AGENT CCBot/2.0 (http://commoncrawl.org/faq/)
LOCAL_ADDR 137.198.11.11
PATH_INFO [empty string]
PATH_TRANSLATED /var/www/police/crime-alert.cfm
QUERY_STRING alertid=3
REMOTE_ADDR 54.162.165.158
REMOTE_HOST 54.162.165.158
REMOTE_USER [empty string]
REQUEST_METHOD GET
SCRIPT_NAME /crime-alert.cfm
SERVER_NAME police.hamptonu.edu
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Apache/2.4.18 (Ubuntu) OpenSSL/1.0.2g mod_jk/1.2.41
WEB_SERVER_API [empty string]
Session
Form
struct [empty]