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.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
 
The error occurred in D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 48
Called from D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 201
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 188
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 186
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1096
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 303
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 297
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/index.cfm: line 33
Called from D:/WORKCUBE_DOSYA/GERCEK/Application.cfc: line 40
Called from D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 48
Called from D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 201
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 188
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 186
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1096
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 303
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 297
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/index.cfm: line 33
Called from D:/WORKCUBE_DOSYA/GERCEK/Application.cfc: line 40
46 : 		IS_PUBLIC = 1
47 :         <cfif isdefined('attributes.brand_id') and len(attributes.brand_id) and attributes.brand_id neq 0>
48 :         AND PRODUCT_CATID IN ( #Valuelist(marka_kategori.product_cat_id)# )
49 :         </cfif>	
50 :         AND HIERARCHY NOT IN(select HIERARCHY from PRODUCT_CAT where HIERARCHY like '%ZXC%')

SQLSTATE   HY000
DATASOURCE   workcube_simet_product
VENDORERRORCODE   102
SQL    SELECT PRODUCT_CAT, PRODUCT_CATID, HIERARCHY FROM PRODUCT_CAT WHERE IS_PUBLIC = 1 AND PRODUCT_CATID IN ( ) AND HIERARCHY NOT IN(select HIERARCHY from PRODUCT_CAT where HIERARCHY like '%ZXC%') ORDER BY HIERARCHY, PRODUCT_CAT
Resources:

Browser   claudebot
Remote Address   54.208.168.232
Referrer   http://www.simet.com.tr/index.cfm?fuseaction=objects2.view_product_list&product_catid=0&HIERARCHY=&lwl=1&brand_id=22&maxrows=20&page=1&keyword=&list_type=1
Date/Time   29-Mar-24 07:15 AM
Stack Trace
at cfsimet_urun_list2ecfm1888443521._factor8(D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm:48) at cfsimet_urun_list2ecfm1888443521.runPage(D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm:1) at cfdynamic_page2ecfm109159989._factor11(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:201) at cfdynamic_page2ecfm109159989._factor12(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:188) at cfdynamic_page2ecfm109159989._factor19(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:186) at cfdynamic_page2ecfm109159989.runPage(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:1) at cffbx_Switch2ecfm1586794136._factor8(D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm:1096) at cffbx_Switch2ecfm1586794136.runPage(D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm:1) at cffbx_fusebox30_CF502ecfm414457555._factor3(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:303) at cffbx_fusebox30_CF502ecfm414457555._factor7(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:297) at cffbx_fusebox30_CF502ecfm414457555._factor9(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:1) at cffbx_fusebox30_CF502ecfm414457555.runPage(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:1) at cfindex2ecfm1701698216.runPage(D:/WORKCUBE_DOSYA/GERCEK/index.cfm:33) at cfApplication2ecfc614150571$funcONREQUEST.runFunction(D:/WORKCUBE_DOSYA/GERCEK/Application.cfc:40) at cfsimet_urun_list2ecfm1888443521._factor8(D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm:48) at cfsimet_urun_list2ecfm1888443521.runPage(D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm:1) at cfdynamic_page2ecfm109159989._factor11(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:201) at cfdynamic_page2ecfm109159989._factor12(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:188) at cfdynamic_page2ecfm109159989._factor19(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:186) at cfdynamic_page2ecfm109159989.runPage(D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm:1) at cffbx_Switch2ecfm1586794136._factor8(D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm:1096) at cffbx_Switch2ecfm1586794136.runPage(D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm:1) at cffbx_fusebox30_CF502ecfm414457555._factor3(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:303) at cffbx_fusebox30_CF502ecfm414457555._factor7(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:297) at cffbx_fusebox30_CF502ecfm414457555._factor9(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:1) at cffbx_fusebox30_CF502ecfm414457555.runPage(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:1) at cfindex2ecfm1701698216.runPage(D:/WORKCUBE_DOSYA/GERCEK/index.cfm:33) at cfApplication2ecfc614150571$funcONREQUEST.runFunction(D:/WORKCUBE_DOSYA/GERCEK/Application.cfc:40)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
	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.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.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	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 cfsimet_urun_list2ecfm1888443521._factor8(D:\WORKCUBE_DOSYA\GERCEK\add_options\simet\simet_urun_list.cfm:48)
	at cfsimet_urun_list2ecfm1888443521.runPage(D:\WORKCUBE_DOSYA\GERCEK\add_options\simet\simet_urun_list.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfdynamic_page2ecfm109159989._factor11(D:\WORKCUBE_DOSYA\GERCEK\objects2\display\dynamic_page.cfm:201)
	at cfdynamic_page2ecfm109159989._factor12(D:\WORKCUBE_DOSYA\GERCEK\objects2\display\dynamic_page.cfm:188)
	at cfdynamic_page2ecfm109159989._factor19(D:\WORKCUBE_DOSYA\GERCEK\objects2\display\dynamic_page.cfm:186)
	at cfdynamic_page2ecfm109159989.runPage(D:\WORKCUBE_DOSYA\GERCEK\objects2\display\dynamic_page.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cffbx_Switch2ecfm1586794136._factor8(D:\WORKCUBE_DOSYA\GERCEK\objects2\fbx_Switch.cfm:1096)
	at cffbx_Switch2ecfm1586794136.runPage(D:\WORKCUBE_DOSYA\GERCEK\objects2\fbx_Switch.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cffbx_fusebox30_CF502ecfm414457555._factor3(D:\WORKCUBE_DOSYA\GERCEK\fbx_fusebox30_CF50.cfm:303)
	at cffbx_fusebox30_CF502ecfm414457555._factor7(D:\WORKCUBE_DOSYA\GERCEK\fbx_fusebox30_CF50.cfm:297)
	at cffbx_fusebox30_CF502ecfm414457555._factor9(D:\WORKCUBE_DOSYA\GERCEK\fbx_fusebox30_CF50.cfm:1)
	at cffbx_fusebox30_CF502ecfm414457555.runPage(D:\WORKCUBE_DOSYA\GERCEK\fbx_fusebox30_CF50.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfindex2ecfm1701698216.runPage(D:\WORKCUBE_DOSYA\GERCEK\index.cfm:33)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfApplication2ecfc614150571$funcONREQUEST.runFunction(D:\WORKCUBE_DOSYA\GERCEK\Application.cfc:40)
	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:653)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:442)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:412)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
	at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:307)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:480)
	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.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: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:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	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:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	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)