Bed-and-breakfast.it
500
Sorry, there was an error.
The site administrator has been notified. Thanks
Back to home page Torna alla Home
struct
Cause
struct
ErrorCode 4104
Message [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4116) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4097) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at jdk.internal.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) 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:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 2019
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6033
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 110
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4116) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4097) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at jdk.internal.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) 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:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 2019
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6033
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 110
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type java.sql.SQLException
DataSource bebitalia
Detail [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound.
2
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
Message Error Executing Database Query.
NativeErrorCode 4104
RootCause
struct
ErrorCode 4104
Message [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound.
NextException
struct
ErrorCode 8180
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4116) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4097) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at jdk.internal.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) 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:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 2019
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6033
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 110
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4116) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4097) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at jdk.internal.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) 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:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 2019
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6033
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 110
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql SET NOCOUNT ON; DECLARE @geo GEOGRAPHY = GEOGRAPHY::Point( (param 1) , (param 2) , 4326); DECLARE @lat NUMERIC(18,14) = (param 3) ; DECLARE @lon NUMERIC(18,14) = (param 4) ; DECLARE @approximateSquare TABLE ( id INT, distanzadacitta FLOAT ); DECLARE @checkInDate DATE = (param 5) ; DECLARE @checkOutDate DATE = (param 6) ; DECLARE @checkOutDateMin DATE = (param 7) ; DECLARE @todayDate DATE = GETDATE(); DECLARE @offset INT = DATEDIFF(minute, GetDate() AT TIME ZONE 'Central European Standard Time', GetUTCDate()); SET @todayDate = DATEADD(minute, @offset, GetUTCDate()); INSERT INTO @approximateSquare ( id, distanzadacitta ) SELECT a.id, distanzadacitta = @geo.STDistance(GEOGRAPHY::Point(a.latitudine, a.longitudine, 4326)) / 1000 FROM strutture (NOLOCK) a LEFT JOIN baratto.dbo.strutture b (NOLOCK) ON b.idstruttura = a.id AND b.tipostruttura = 'bbit' WHERE a.online = 1 and a.latitudine BETWEEN @lat - (param 8) * 0.009006169 and @lat + (param 9) * 0.009006169 and a.longitudine BETWEEN @lon - (param 10) * 0.011710973 and @lon + (param 11) * 0.011710973 and a.latitudine is not NULL and a.longitudine is not NULL ; SELECT a.id , a.idbb2 , a.tipo , a.nomebeb2 as nomebeb , r.regione2 as regione , r.ur_regione2 as ur_regione , a.nomebeb as nomebeb2 , a.ur_nomebeb , a.indirizzo , a.numerocivico , a.zona , a.frazione , a.citta , a.provincia , a.url as sitoweb , a.email , a.emailnonfunziona , a.latitudine , a.longitudine , a.rate , a.rateagit , a.ratecvit , a.ratebb1 , a.ip , a.pmin , a.pmax , a.pdmin , a.pdmax , a.psmin , a.psmax , a.idbooking , a.tel1 , a.tel2 , a.cell1 , a.cell2 , a.mediarecensioni , a.mediarecensionitutti , a.numerorecensionitutti , a.visualizzarecensioni , a.forzarecensioni , a.camere_attivate , a.prenotazione_diretta , a.tasso_risposta , case when datalength(a.descrizione) = 0 or datalength(a.descrizione) is null then 0 else 1 end as haDescrizione , case when datalength(a.video) = 0 or datalength(a.video) is null then 0 else 1 end as haVideo , case when a.idregione = 15 then 'bbsic' else 'bbit' end as tipoStruttura , a.geoPoint.STDistance(@geo)/1000 as distanzadacitta , a.geoPoint.STDistance(@geo) as distanzadacittametri , a.preventivi , a.tutterichieste , a.prioritysorting , a.whatsapp , a.istopbnb , a.notificheSocialchat , fs.nomefile as thumb , r.idregione , fs.foto1, fs.foto2, fs.foto3, fs.foto4, fs.foto5, fs.foto6, fs.foto7, fs.foto8, fs.foto9 , fs.foto10, fs.foto11, fs.foto12, fs.foto13, fs.foto14, fs.foto15, fs.foto16, fs.foto17, fs.foto18 , fs.foto19, fs.foto20, fs.foto21, fs.foto22, fs.foto23, fs.foto24, fs.foto25, fs.foto26, fs.foto27 , p.AccessoDisabili as accessoDisabili , p.AnimaliAmmessi as animaliAmmessi , p.CondizionatoreInCamera as ariaCondizionata , p.sipuofumare as sipuofumare , p.parcheggio as parcheggio , p.casad41 as piscina , p.casad42 as giardino , p.casad43 as angoloCottura , p.casad44 as terrazza , p.casad52 as lavanderia , p.lettod42 as tvInCamera , p.internet as internet , p.Ristorante as ristorante , p.Spa as spa , p.Trekking as trekking , p.pisteCiclabili as pisteciclabili , p.BicicletteDisponibili as biciclettedisponibili , p.Maneggio as maneggio , p.bonusvacanze , p.BonusVacanzaRegione , p.NoteBonusVacanze , p.cashback , p.Quad as quad , p.FattoriaConAnimali as fattoriaconanimali , p.FattoriaDidattica as fattoriadidattica , case when (p.temia1 = 3 or a.zona = 'Campagna' or a.zona = 'Collina' or a.tipo = 'AG') then 1 else 0 end as campagna , p.WifiGratis as wifiGratis , p.phon as phon , p.riscaldamento as riscaldamento , p.temib21 as dimorastorica , case when (p.temib22 = 1 or p.temib23 = 1) then 1 else 0 end as design , p.temib25 as famiglie , p.temib26 as affari , p.temib27 as fugaromantica , p.homerestaurant as homerestaurant , p.sauna as sauna , p.vascaidromassaggio as vascaidromassaggio , p.palestragym as palestragym , p.camino as camino , p.bambiniesclusi , p.lettod11 as numeroCamere , p.lettod12 as bagnoInCamera , p.lettod13 as bagnoPrivato , p.lettod14 as bagnoCondiviso , p.prezzoanimali as prezzoanimali , p.prezzoanimaligiornaliero as prezzoanimaligiornaliero , p.requisitoanimalitaglia as requisitoanimalitaglia , p.requisitoanimalilibretto as requisitoanimalilibretto , p.requisitoanimaliguinzaglio as requisitoanimaliguinzaglio , p.requisitoanimalicasa as requisitoanimalicasa , p.requisitoanimalicollocazione as requisitoanimalicollocazione , p.confermagestoreanimali as confermagestoreanimali , p.requisitoanimalisolistruttura as requisitoanimalisolistruttura , p.requisitoanimaliconpadroni as requisitoanimaliconpadroni , p.requisitoanimalidivietoletti as requisitoanimalidivietoletti , p.requisitoanimalidivietospazicomuni as requisitoanimalidivietospazicomuni , p.requisitoanimalicuccia as requisitoanimalicuccia , p.requisitoanimaliperiodoanno as requisitoanimaliperiodoanno , p.requisitoanimaliperiodobreve as requisitoanimaliperiodobreve , p.requisitoanimalipelocorto as requisitoanimalipelocorto , p.requisitoanimalisupplemento as requisitoanimalisupplemento , p.requisitotipoanimali as requisitotipoanimali , p.dotazioniperanimali as dotazioniperanimali , p.prezzoanimalicauzione as prezzoanimalicauzione , p.colazioneinclusa as colazioneInclusa , case when (a.charmedesign = 1 or (tag_viaggiatori.charme = 1 and tag_viaggiatori.design = 1)) then 1 else 0 end as charmedesign , case when (so.in_riva_al_mare = 1 or tag_viaggiatori.in_riva_al_mare = 1) then 1 else 0 end as in_riva_al_mare , a.charmedesign as charmedesign_weight , so.in_riva_al_mare as in_riva_al_mare_weight , tag_viaggiatori.in_centro as in_centro_weight , tag_viaggiatori.panorama_spettacolare , tag_viaggiatori.colazione_abbondante , tag_viaggiatori.charme , tag_viaggiatori.design , tag_viaggiatori.nuovissimo , tag_viaggiatori.piscina , tag_viaggiatori.vicino_piste_sci , tag_viaggiatori.vicino_aeroporto , tag_viaggiatori.vicino_stazione , tag_viaggiatori.economico , case when (tag_viaggiatori.in_centro = 1 or so.in_centro = 1) then 1 else 0 end as in_centro , tag_viaggiatori.in_riva_al_lago , tag_viaggiatori.in_riva_al_fiume , tag_viaggiatori.vicino_metro , tag_viaggiatori.vicino_terme , tag_viaggiatori.in_zona_shopping , so.penalizzazione_prezzi , so.identificativo_regionale , so.mostra_cellulare1 , b.id as idBaratto FROM strutture (NOLOCK) a INNER JOIN @approximateSquare approximateSquare ON a.id = approximateSquare.id INNER JOIN bebitalia.dbo.regioni (NOLOCK) r ON r.idregione = a.idregione LEFT JOIN bebitalia.dbo.plus (NOLOCK) p ON a.id = p.idstruttura AND p.tipostruttura = 'bbit' OUTER APPLY ( SELECT penalizzazione_prezzi, identificativo_regionale, in_riva_al_mare, in_centro, mostra_cellulare1 FROM bebitalia.dbo.strutture_opzioni (NOLOCK) WHERE idstruttura = a.id AND tipostruttura = 'bbit' ) AS so OUTER APPLY ( SELECT idstruttura, tipostruttura, [0] as nomefile, [1] as foto1, [2] as foto2, [3] as foto3, [4] as foto4, [5] as foto5, [6] as foto6, [7] as foto7, [8] as foto8, [9] as foto9, [10] as foto10, [11] as foto11, [12] as foto12, [13] as foto13, [14] as foto14, [15] as foto15, [16] as foto16, [17] as foto17, [18] as foto18, [19] as foto19, [20] as foto20, [21] as foto21, [22] as foto22, [23] as foto23, [24] as foto24, [25] as foto25, [26] as foto26, [27] as foto27 FROM ( SELECT f2.idstruttura, f2.tipostruttura, (f2.nomefile + ' (param 12) rfh=' + convert(nvarchar, max(f2.v_foto)) + '|' + convert(nvarchar, max(f2.width)) + '|' + convert(nvarchar, max(f2.height))) as nomefile, CASE WHEN f2.idcategoria = 1 THEN 0 ELSE ROW_NUMBER() OVER (PARTITION BY f2.idstruttura, f2.tipostruttura ORDER BY f2.order_foto) END as n_foto FROM bebitalia.dbo.fotostrutture f2 (NOLOCK) WHERE f2.idstruttura = a.id AND f2.tipostruttura = 'bbit' AND (f2.idcategoria = 4 OR f2.idcategoria = 1) GROUP BY f2.idstruttura, f2.tipostruttura, f2.nomefile, f2.v_foto, f2.order_foto, f2.idcategoria ) as p PIVOT ( MAX(p.nomefile) FOR n_foto IN ([0], [1], [2], [3], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], [17], [18], [19], [20], [21], [22], [23], [24], [25], [26], [27]) ) as pivot_foto ) as fs OUTER APPLY ( SELECT idstruttura, tipostruttura, [1] as in_riva_al_mare, [4] as panorama_spettacolare, [5] as colazione_abbondante, [6] as charme, [7] as design, [8] as nuovissimo, [9] as piscina, [10] as vicino_piste_sci, [11] as vicino_aeroporto, [12] as vicino_stazione, [13] as economico, [14] as in_centro, [15] as in_riva_al_lago, [16] as in_riva_al_fiume, [17] as vicino_metro, [18] as vicino_terme, [19] as in_zona_shopping FROM ( SELECT idstruttura, tipostruttura, idtag FROM iHotels.dbo.tagstrutture (NOLOCK) ts WHERE ts.idstruttura = a.id AND ts.tipostruttura = 'bbit' GROUP BY idstruttura, tipostruttura, idtag HAVING COUNT(idtag) > 1 ) as p PIVOT ( count(idtag) FOR idtag IN ([1], [4], [5], [6], [7], [8], [9], [10], [11], [12], [13], [14], [15], [16], [17], [18], [19]) ) as pivot_tag ) as tag_viaggiatori WHERE approximateSquare.distanzadacitta < (param 13) ; SET NOCOUNT OFF;
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4116) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4097) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) 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:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at jdk.internal.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) 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:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor77.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor67.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound. at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source) at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddq.a(Unknown Source) at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source) at macromedia.jdbc.sqlserver.dda4.m(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.a(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source) at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd2.execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.$fr$execute(Unknown Source) at macromedia.jdbc.sqlserverbase.ddd6.execute(Unknown Source) at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101) at coldfusion.sql.Executive.executeQuery(Executive.java:1583) at coldfusion.sql.Executive.executeQuery(Executive.java:1317) at coldfusion.sql.Executive.executeQuery(Executive.java:1247) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 92 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 2019
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:2019)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6033
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYPROSSIMITA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6033)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 110
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:110)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
4
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]The multi-part identifier "b.id" could not be bound.
where (param 1) = [type='IN', class='java.lang.Double', value='45.46675', sqltype='cf_sql_double'] , (param 2) = [type='IN', class='java.lang.Double', value='12.21438', sqltype='cf_sql_double'] , (param 3) = [type='IN', class='java.lang.Double', value='45.46675', sqltype='cf_sql_double'] , (param 4) = [type='IN', class='java.lang.Double', value='12.21438', sqltype='cf_sql_double'] , (param 5) = [type='IN', class='java.sql.Date', value='2023-10-02', sqltype='cf_sql_date'] , (param 6) = [type='IN', class='java.sql.Date', value='2023-10-03', sqltype='cf_sql_date'] , (param 7) = [type='IN', class='java.sql.Date', value='2023-10-02', sqltype='cf_sql_date'] , (param 8) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_tinyint'] , (param 9) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_tinyint'] , (param 10) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_tinyint'] , (param 11) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_tinyint'] , (param 12) = [type='IN', class='java.lang.Integer', value='2', sqltype='cf_sql_integer']