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.

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'in (ic.d_subcateg) order by i.d_name' at line 11
 
The error occurred in C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/act_search.cfm: line 56
Called from C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/index.cfm: line 62
Called from C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/act_search.cfm: line 56
Called from C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/index.cfm: line 62
54 : 				</cfif>
55 : 				<cfif #SC# neq 0>
56 : 					AND #SC# in (ic.d_subcateg)
57 : 				</cfif>	
58 : 			order by i.d_name

VENDORERRORCODE   1064
SQLSTATE   42000
SQL    select ic.d_categ_id,ic.d_subcateg,i.*,m.d_name as d_manufacturer_name, ict.d_name as d_char_type from tbl_item_category ic left join tbl_item i on i.id=ic.d_item_id left join tbl_manufacturer m on m.id=i.d_manufacturer_id left join tbl_item_character_type ict on ict.id=i.d_character_type left join tbl_category cat on ic.d_categ_id=cat.id where ic.id>0 and i.d_status > 0 AND cat.d_site = (param 1) AND ic.d_categ_id = (param 2) AND in (ic.d_subcateg) order by i.d_name
DATASOURCE   lic2
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.198.143.210
Referrer  
Date/Time   20-Oct-17 10:48 PM
Stack Trace
at cfact_search2ecfm1537000393.runPage(C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/act_search.cfm:56) at cfindex2ecfm181833193.runPage(C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/index.cfm:62) at cfact_search2ecfm1537000393.runPage(C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/act_search.cfm:56) at cfindex2ecfm181833193.runPage(C:/inetpub/wwwroot/license-2-play-2/wholesale-toys/list/index.cfm:62)

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'in (ic.d_subcateg)
					
			order by i.d_name' at line 11
	at sun.reflect.GeneratedConstructorAccessor1316.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
	at java.lang.reflect.Constructor.newInstance(Unknown Source)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
	at com.mysql.jdbc.Util.getInstance(Util.java:383)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1193)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:91)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1436)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfact_search2ecfm1537000393.runPage(C:\inetpub\wwwroot\license-2-play-2\wholesale-toys\list\act_search.cfm:56)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfindex2ecfm181833193.runPage(C:\inetpub\wwwroot\license-2-play-2\wholesale-toys\list\index.cfm:62)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)