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.

Falsche Syntax in der Nähe des SELECT-Schlüsselworts.

The error occurred in E:/www/phoenix/app/views/info/template/listen-angebote.cfm: line 23
Called from E:/www/phoenix/app/views/info/template/listen-angebote.cfm: line 1
Called from E:/www/phoenix/app/views/info/info.view.cfm: line 21
Called from E:/www/phoenix/app/controllers/info.controller.cfm: line 103
Called from E:/www/phoenix/app/controllers/info.controller.cfm: line 14
Called from E:/www/phoenix/index.cfm: line 60
Called from E:/www/phoenix/app/views/info/template/listen-angebote.cfm: line 23
Called from E:/www/phoenix/app/views/info/template/listen-angebote.cfm: line 1
Called from E:/www/phoenix/app/views/info/info.view.cfm: line 21
Called from E:/www/phoenix/app/controllers/info.controller.cfm: line 103
Called from E:/www/phoenix/app/controllers/info.controller.cfm: line 14
Called from E:/www/phoenix/index.cfm: line 60

21 :             FROM Kreuzfahrten_Hafen H
22 :             INNER JOIN Land L ON H.IDLand = L.IDLand  
23 :             WHERE H.ID = #qAlleReisenzumHafen.IDHafen#                          
24 :     </cfquery>
25 :     <cfset Caller.metatags = ReReplaceNoCase(Caller.metatags,"<title>.*</title>", "", "ALL")>

SQLSTATE	S1000
DATASOURCE	phoenix
VENDORERRORCODE	156
SQL	SELECT H.Hafen, H.Stadt, L.Landname FROM Kreuzfahrten_Hafen H INNER JOIN Land L ON H.IDLand = L.IDLand WHERE H.ID =

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	10.57.3.105
Referrer
Date/Time	10-Jul-20 06:32 PM

Stack Trace

at cflisten2dangebote2ecfm505773851._factor1(E:/www/phoenix/app/views/info/template/listen-angebote.cfm:23) at cflisten2dangebote2ecfm505773851.runPage(E:/www/phoenix/app/views/info/template/listen-angebote.cfm:1) at cfinfo2eview2ecfm1473151483.runPage(E:/www/phoenix/app/views/info/info.view.cfm:21) at cfinfo2econtroller2ecfm2087861774$funcINDEX.runFunction(E:/www/phoenix/app/controllers/info.controller.cfm:103) at cfinfo2econtroller2ecfm2087861774.runPage(E:/www/phoenix/app/controllers/info.controller.cfm:14) at cfindex2ecfm1672919428.runPage(E:/www/phoenix/index.cfm:60) at cflisten2dangebote2ecfm505773851._factor1(E:/www/phoenix/app/views/info/template/listen-angebote.cfm:23) at cflisten2dangebote2ecfm505773851.runPage(E:/www/phoenix/app/views/info/template/listen-angebote.cfm:1) at cfinfo2eview2ecfm1473151483.runPage(E:/www/phoenix/app/views/info/info.view.cfm:21) at cfinfo2econtroller2ecfm2087861774$funcINDEX.runFunction(E:/www/phoenix/app/controllers/info.controller.cfm:103) at cfinfo2econtroller2ecfm2087861774.runPage(E:/www/phoenix/app/controllers/info.controller.cfm:14) at cfindex2ecfm1672919428.runPage(E:/www/phoenix/index.cfm:60)

java.sql.SQLException: Falsche Syntax in der Nähe des SELECT-Schlüsselworts.
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
	at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
	at net.sourceforge.jtds.jdbc.JtdsStatement.$fr$execute(JtdsStatement.java:1297)
	at net.sourceforge.jtds.jdbc.JtdsStatement.execute(JtdsStatement.java)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cflisten2dangebote2ecfm505773851._factor1(E:\www\phoenix\app\views\info\template\listen-angebote.cfm:23)
	at cflisten2dangebote2ecfm505773851.runPage(E:\www\phoenix\app\views\info\template\listen-angebote.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:56)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:332)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfinfo2eview2ecfm1473151483.runPage(E:\www\phoenix\app\views\info\info.view.cfm:21)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfinfo2econtroller2ecfm2087861774$funcINDEX.runFunction(E:\www\phoenix\app\controllers\info.controller.cfm:103)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:533)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2830)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:493)
	at cfinfo2econtroller2ecfm2087861774.runPage(E:\www\phoenix\app\controllers\info.controller.cfm:14)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfindex2ecfm1672919428.runPage(E:\www\phoenix\index.cfm:60)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:474)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	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.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor118.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.ha.session.JvmRouteBinderValve.invoke(JvmRouteBinderValve.java:207)
	at org.apache.catalina.ha.tcp.ReplicationValve.invoke(ReplicationValve.java:333)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)