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.


Query Of Queries syntax error.
Encountered "group. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
 
The error occurred in D:/inetpub/wwwroot/queries/qry_getwebproducts.cfm: line 235
Called from D:/inetpub/wwwroot/category.cfm: line 51
Called from D:/inetpub/wwwroot/queries/qry_getwebproducts.cfm: line 235
Called from D:/inetpub/wwwroot/category.cfm: line 51
233 : 					<cfif isdefined("url.order_by") and len(url.order_by)>
234 : 						#url.order_by#
235 : 					<cfelse>
236 : 						date_entered desc
237 : 					</cfif>

SQL    select distinct (style_id) as style_id , max(picture_id) , min(min_price) as min_price , max(max_price) as max_price , max(web_style) as web_style , max(web_desc) as web_desc , max(description) as description , max(style) as style , max(picture_id) as picture_id , max(dept) as dept , max(typ) as typ , max(subtyp_1) as subtyp_1 , max(subtyp_2) as subtyp_2 , max(subtyp_3) as subtyp_3 , max(category_style) as category_style , max(web_url) as web_url , max(sort_position) as sort_position ,max(web_taxonomy_id) as web_taxonomy_id ,max(brand) as brand ,max(date_entered) as date_entered , MAX(max_sugg_price) AS max_sugg_price , max(attr1) as attr1 , max(attr1_alias) attr1_alias , max(attr1_entry_id) as attr1_entry_id , max(siz) as siz ,max(siz_alias) as siz_alias , max(scale_entry_id) as scale_entry_id ,max(of1) as of1 ,max(of2) as of2 ,max(of3) as of3 ,max(of4) as of4 ,max(of5) as of5 ,max(of6) as of6 ,max(of7) as of7 ,max(of8) as of8 from getALLproducts where group by Style_id order by date_entered desc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   34.204.52.4
Referrer  
Date/Time   19-Mar-19 11:51 PM
Stack Trace
at cfqry_getwebproducts2ecfm607716153.runPage(D:/inetpub/wwwroot/queries/qry_getwebproducts.cfm:235) at cfcategory2ecfm524612408.runPage(D:/inetpub/wwwroot/category.cfm:51) at cfqry_getwebproducts2ecfm607716153.runPage(D:/inetpub/wwwroot/queries/qry_getwebproducts.cfm:235) at cfcategory2ecfm524612408.runPage(D:/inetpub/wwwroot/category.cfm:51)

java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br>
Encountered "group.
Incorrect conditional expression, 
Expected one of [like|null|between|in|comparison] condition, 

	at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590)
	at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547)
	at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1495)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfqry_getwebproducts2ecfm607716153.runPage(D:\inetpub\wwwroot\queries\qry_getwebproducts.cfm:235)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfcategory2ecfm524612408.runPage(D:\inetpub\wwwroot\category.cfm:51)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)