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 'BY'.
 
The error occurred in D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 152
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 68
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/dynamic.cfm: line 5
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/main.cfm: line 123
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 28
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 62
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 349
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 321
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/documents/templates/xentino/dynamics/product_list.cfm: line 152
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 68
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/dynamic.cfm: line 5
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/main.cfm: line 123
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 28
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 62
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 349
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 321
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
150 :                     PR.RECORD_DATE <cfif attributes.order_element gt 10>DESC<cfelse>ASC</cfif>
151 :                 </cfif>
152 :             <cfelse>
153 :               <!--- PR.PRODUCT_CATID--->  
154 :                 PR.RECORD_DATE DESC

SQLSTATE   HY000
DATASOURCE   workcube_simet_4
VENDORERRORCODE   102
SQL    SELECT PR.*, PRODUCT_CAT, CONVERT(INT, PI.PROPERTY3) AS PROPERTY3, PC.PRODUCT_COMMENT_POINT FROM PRODUCT PR JOIN PRODUCT_CAT ON PRODUCT_CAT.PRODUCT_CATID = PR.PRODUCT_CATID LEFT JOIN PRODUCT_INFO_PLUS PI ON PI.PRODUCT_ID = PR.PRODUCT_ID LEFT JOIN PRODUCT_COMMENT PC ON PC.PRODUCT_ID = PR.PRODUCT_ID WHERE PR.PRODUCT_STATUS = 1 AND PR.IS_INTERNET = 1 AND PR.PRODUCT_STATUS = 1 AND PR.IS_INVENTORY = 1 AND PR.IS_SALES = 1 AND PR.BRAND_ID = 30 AND HIERARCHY NOT IN(select HIERARCHY from PRODUCT_CAT where HIERARCHY like '%ZXC%') ORDER BY
Resources:

Browser   claudebot
Remote Address   54.160.133.33
Referrer   http://www.xentino.com/index.cfm?fuseaction=objects2.product_list&product_catid=0&HIERARCHY=&lwl=1&keyword=&list_type=1&order_element=5&order_type=1&maxrows=6
Date/Time   28-Mar-24 12:15 PM
Stack Trace
at cfproduct_list2ecfm897133552._factor2(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm:152) at cfproduct_list2ecfm897133552._factor5(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm:68) at cfproduct_list2ecfm897133552.runPage(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm:1) at cfdynamic2ecfm2100947222.runPage(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/dynamic.cfm:5) at cfmain2ecfm1287696216.runPage(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/main.cfm:123) at cfreal_dsp_sablon2ecfm1216951803$funcINCLUDESITE.runFunction(D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm:28) at cfreal_dsp_sablon2ecfm1216951803.runPage(D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm:62) at cffbx_fusebox30_CF502ecfm414457555._factor5(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:349) at cffbx_fusebox30_CF502ecfm414457555._factor8(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:321) 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 cfproduct_list2ecfm897133552._factor2(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm:152) at cfproduct_list2ecfm897133552._factor5(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm:68) at cfproduct_list2ecfm897133552.runPage(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm:1) at cfdynamic2ecfm2100947222.runPage(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/dynamic.cfm:5) at cfmain2ecfm1287696216.runPage(D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/main.cfm:123) at cfreal_dsp_sablon2ecfm1216951803$funcINCLUDESITE.runFunction(D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm:28) at cfreal_dsp_sablon2ecfm1216951803.runPage(D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm:62) at cffbx_fusebox30_CF502ecfm414457555._factor5(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:349) at cffbx_fusebox30_CF502ecfm414457555._factor8(D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm:321) 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 'BY'.
	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 cfproduct_list2ecfm897133552._factor2(D:\WORKCUBE_DOSYA\GERCEK\documents\templates\xentino\dynamics\product_list.cfm:152)
	at cfproduct_list2ecfm897133552._factor5(D:\WORKCUBE_DOSYA\GERCEK\documents\templates\xentino\dynamics\product_list.cfm:68)
	at cfproduct_list2ecfm897133552.runPage(D:\WORKCUBE_DOSYA\GERCEK\documents\templates\xentino\dynamics\product_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 cfdynamic2ecfm2100947222.runPage(D:\WORKCUBE_DOSYA\GERCEK\documents\templates\xentino\dynamics\dynamic.cfm:5)
	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 cfmain2ecfm1287696216.runPage(D:\WORKCUBE_DOSYA\GERCEK\documents\templates\xentino\main.cfm:123)
	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 cfreal_dsp_sablon2ecfm1216951803$funcINCLUDESITE.runFunction(D:\WORKCUBE_DOSYA\GERCEK\real_dsp_sablon.cfm:28)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:493)
	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.CfJspPage._invokeUDF(CfJspPage.java:3553)
	at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3533)
	at cfreal_dsp_sablon2ecfm1216951803.runPage(D:\WORKCUBE_DOSYA\GERCEK\real_dsp_sablon.cfm:62)
	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._factor5(D:\WORKCUBE_DOSYA\GERCEK\fbx_fusebox30_CF50.cfm:349)
	at cffbx_fusebox30_CF502ecfm414457555._factor8(D:\WORKCUBE_DOSYA\GERCEK\fbx_fusebox30_CF50.cfm:321)
	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)