Lucee 6.2.1.122 Error (database)
Message cannot set a value to an empty query, you first have to add a row
AI (Experimental) For AI-driven exception analysis setup, see AI Setup Guide.
Stacktrace The Error Occurred in
C:\inetpub\sites\timeandseasons.com\detail.cfm: line 109
107: <Cfelse>
108:    <cfset destinationURL='http://media.altusinternet.com/marketplace/images/#pid#1.jpg'>
109:    <cfset getSticker.variables=replacenocase(getSticker.Variables, "||", "| |", "all")>
110:    <cfif right(getSticker.Variables, 1) is "|">
111:       <cfset getSticker.Variables=getSticker.Variables&" ">

Java Stacktrace lucee.runtime.exp.DatabaseException: cannot set a value to an empty query, you first have to add a row
 at lucee.runtime.type.QueryColumnImpl.set(QueryColumnImpl.java:334)
 at lucee.runtime.type.QueryImpl.setAt(QueryImpl.java:1265)
 at lucee.runtime.type.QueryImpl.setAt(QueryImpl.java:1256)
 at lucee.runtime.type.QueryImpl.set(QueryImpl.java:2085)
 at lucee.runtime.util.VariableUtilImpl.set(VariableUtilImpl.java:434)
 at lucee.runtime.PageContextImpl.set(PageContextImpl.java:1810)
 at lucee.runtime.PageContextImpl.us(PageContextImpl.java:1357)
 at detail_cfm$cf.call(/detail.cfm:109)
 at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1112)
 at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1006)
 at lucee.runtime.listener.ClassicAppListener._onRequest(ClassicAppListener.java:63)
 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2810)
 at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2797)
 at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2768)
 at lucee.runtime.engine.Request.exe(Request.java:45)
 at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1066)
 at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
 at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52)
 at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:130)
 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:109)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:79)
 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:116)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
 at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:420)
 at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
 at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903)
 at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1744)
 at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
 at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:637)
 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:59)
 at java.base/java.lang.Thread.run(Unknown Source)
Timestamp 9/16/25 2:12:28 AM UTC