Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 8
 
The error occurred in /webshare/AllData/websites/components/ebusFront/locations/1/model/location.cfm: line 19
Called from /webshare/AllData/websites/components/ebusFront/locations/1/controller/1/location.cfm: line 1
Called from /webshare/AllData/websites/components/ebusFront/locations/1/controller/1/main.cfm: line 3
Called from /webshare/AllData/websites/components/ebusFront/locations/1/locations.cfc: line 37
Called from /webshare/AllData/websites/Content Management/1482/modules/locations/locations.cfm: line 20
Called from /webshare/AllData/websites/Content Management/1482/index.cfm: line 102
Called from /webshare/AllData/websites/components/ebusFront/locations/1/model/location.cfm: line 19
Called from /webshare/AllData/websites/components/ebusFront/locations/1/controller/1/location.cfm: line 1
Called from /webshare/AllData/websites/components/ebusFront/locations/1/controller/1/main.cfm: line 3
Called from /webshare/AllData/websites/components/ebusFront/locations/1/locations.cfc: line 37
Called from /webshare/AllData/websites/Content Management/1482/modules/locations/locations.cfm: line 20
Called from /webshare/AllData/websites/Content Management/1482/index.cfm: line 102
17 :           FROM locService
18 :           LEFT JOIN locLocationService ON locService.serviceID = locLocationService.serviceID
19 :           WHERE locLocationService.locationID = #getLocation.locationId#
20 : </cfquery>
21 : <cfquery name="getLocationHours" dataSource="#APPLICATION.DSN#">

SQLSTATE   42000
DATASOURCE   1482
VENDORERRORCODE   1064
SQL    SELECT locService.Link, locService.Name, locService.ServiceID, locService.Description FROM locService LEFT JOIN locLocationService ON locService.serviceID = locLocationService.serviceID WHERE locLocationService.locationID =
Resources:

Browser   claudebot
Remote Address   10.5.1.172
Referrer  
Date/Time   28-Mar-24 02:51 PM
Stack Trace
at cflocation2ecfm410552147.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/model/location.cfm:19) at cflocation2ecfm1522261190.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/controller/1/location.cfm:1) at cfmain2ecfm661928501.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/controller/1/main.cfm:3) at cflocations2ecfc210934379$funcFRONT.runFunction(/webshare/AllData/websites/components/ebusFront/locations/1/locations.cfc:37) at cflocations2ecfm920931751.runPage(/webshare/AllData/websites/Content Management/1482/modules/locations/locations.cfm:20) at cfindex2ecfm1823779469.runPage(/webshare/AllData/websites/Content Management/1482/index.cfm:102) at cflocation2ecfm410552147.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/model/location.cfm:19) at cflocation2ecfm1522261190.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/controller/1/location.cfm:1) at cfmain2ecfm661928501.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/controller/1/main.cfm:3) at cflocations2ecfc210934379$funcFRONT.runFunction(/webshare/AllData/websites/components/ebusFront/locations/1/locations.cfc:37) at cflocations2ecfm920931751.runPage(/webshare/AllData/websites/Content Management/1482/modules/locations/locations.cfm:20) at cfindex2ecfm1823779469.runPage(/webshare/AllData/websites/Content Management/1482/index.cfm:102)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 8
	at sun.reflect.GeneratedConstructorAccessor1993.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2439)
	at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:829)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:923)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1537)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	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 cflocation2ecfm410552147.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/model/location.cfm:19)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cflocation2ecfm1522261190.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/controller/1/location.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cfmain2ecfm661928501.runPage(/webshare/AllData/websites/components/ebusFront/locations/1/controller/1/main.cfm:3)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cflocations2ecfc210934379$funcFRONT.runFunction(/webshare/AllData/websites/components/ebusFront/locations/1/locations.cfc:37)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
	at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:426)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:389)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:340)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:235)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:654)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:443)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:413)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3247)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3224)
	at cflocations2ecfm920931751.runPage(/webshare/AllData/websites/Content Management/1482/modules/locations/locations.cfm:20)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851)
	at cfindex2ecfm1823779469.runPage(/webshare/AllData/websites/Content Management/1482/index.cfm:102)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:743)
	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:484)
	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:223)
	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:200)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:552)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1634)
	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)