Interact Applications

Where there's a will, there's a weigh...

Well, most of the time. Unfortunately, it looks like we weren't able to find a way to fulfill your request (unless you were looking for a bad pun). However, we have made a note of the error, and we'll be fixing it as soon as possible.

EXCEPTION:

Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT * FROM compatibilities WHERE product_id IN ()
DatabaseName
stringPostgreSQL
DatabaseVersion
string16.2 (Ubuntu 16.2-1.pgdg22.04+1)
DriverName
stringPostgreSQL JDBC Driver
DriverVersion
string42.6.0
Datasource
stringnexus
DataSource
stringnexus
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringERROR: syntax error at or near ")" Position: 56
NativeErrorCode
number0
queryError
stringSELECT * FROM compatibilities WHERE product_id IN ()
Sql
stringSELECT * FROM compatibilities WHERE product_id IN ()
SQLState
string42601
StackTrace
stringlucee.runtime.exp.DatabaseException: ERROR: syntax error at or near ")" Position: 56 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:345) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:297) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:243) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1130) at lucee.runtime.tag.Query._doEndTag(Query.java:697) at lucee.runtime.tag.Query.doEndTag(Query.java:562) at standalone.groups.accessories_cfm$cf.call(/standalone/groups/accessories.cfm:6) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1059) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:951) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:932) at products.group.index_cfm$cf.call(/products/group/index.cfm:54) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1059) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:951) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:220) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2715) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2701) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2672) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1259) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1205) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:590) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) at org.cfmlprojects.regexpathinfofilter.RegexPathInfoFilter.doFilter(RegexPathInfoFilter.java:47) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:67) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at runwar.undertow.SSLClientCertHeaderHandler.handleRequest(SSLClientCertHeaderHandler.java:144) at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:393) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852) at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558) at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1449) at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1282) at java.base/java.lang.Thread.run(Thread.java:829)
TagContext
Array
1
Struct
codePrintHTML
string4: &nbsp;&nbsp;FROM&nbsp;compatibilities<br> 5: &nbsp;&nbsp;WHERE&nbsp;product_id&nbsp;IN&nbsp;(#valueList(q_products.id)#)<br> <b>6: &lt;/cfquery&gt;</b><br> 7: <br> 8: &lt;cfif&nbsp;q_compatibilities.recordCount&nbsp;GT&nbsp;0&gt;<br>
codePrintPlain
string4: FROM compatibilities 5: WHERE product_id IN (#valueList(q_products.id)#) 6: </cfquery> 7: 8: <cfif q_compatibilities.recordCount GT 0>
column
number0
id
string??
line
number6
Raw_Trace
stringstandalone.groups.accessories_cfm$cf.call(/standalone/groups/accessories.cfm:6)
template
string/home/www/fairbanks.com/standalone/groups/accessories.cfm
type
stringcfml
2
Struct
codePrintHTML
string52: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/ul&gt;<br> 53: <br> <b>54: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/standalone/groups/accessories.cfm&quot;&nbsp;/&gt;</b><br> 55: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 56: <br>
codePrintPlain
string52: </ul> 53: 54: <cfinclude template="/standalone/groups/accessories.cfm" /> 55: </cfif> 56:
column
number0
id
string??
line
number54
Raw_Trace
stringproducts.group.index_cfm$cf.call(/products/group/index.cfm:54)
template
string/home/www/fairbanks.com/products/group/index.cfm
type
stringcfml
type
stringdatabase
where
string