Railo 4.2.1.008 Error (database)
Message cannot set a value to a empty query, you first have to add a row
Stacktrace The Error Occurred in
/websites/cmsroot/layout/odyssey/dsp_ShowHeader.cfm: line 461
459: <cfinclude template="../../qry_ListPages.cfm">
460:
461: <cfparam name="qryPageInfo.NavLocationID" default="">
462:
463: <cfoutput>

called from /websites/cmsroot/index.cfm: line 352
Java Stacktrace cannot set a value to a empty query, you first have to add a row
  at railo.runtime.type.QueryColumnImpl.set(QueryColumnImpl.java:278):278
  at railo.runtime.type.QueryImpl.setAt(QueryImpl.java:890):890
  at railo.runtime.type.QueryImpl.set(QueryImpl.java:1701):1701
  at railo.runtime.util.VariableUtilImpl.set(VariableUtilImpl.java:438):438
  at railo.runtime.PageContextImpl.set(PageContextImpl.java:1335):1335
  at railo.runtime.interpreter.VariableInterpreter.setVariable(VariableInterpreter.java:347):347
  at railo.runtime.PageContextImpl.setVariable(PageContextImpl.java:1418):1418
  at railo.runtime.PageContextImpl.param(PageContextImpl.java:1521):1521
  at railo.runtime.PageContextImpl.param(PageContextImpl.java:1439):1439
  at layout.odyssey.dsp_showheader_cfm$cf.call(/websites/cmsroot/layout/odyssey/dsp_ShowHeader.cfm:461):461
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813
  at index_cfm$cf.call(/websites/cmsroot/index.cfm:352):352
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:861):861
  at railo.runtime.PageContextImpl.handlePageException(PageContextImpl.java:1819):1819
  at railo.runtime.listener.ModernAppListener.onError(ModernAppListener.java:382):382
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2223):2223
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220):220
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503):503
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170):170
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103):103
  at mod_cfml.core.invoke(core.java:132):132
  at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950):950
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421):421
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070):1070
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611):611
  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314):314
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
  at java.lang.Thread.run(Thread.java:745):745
 
Timestamp 12/11/16 9:51:02 AM UTC