Lucee 5.4.4.38 Error (database) | |
Message | CF_SQL_INTEGER parameter in position 1 is invalid. |
Detail | can't cast empty string to a number value |
SQL | select id,rn from loc.qNews where id = [CF_SQL_INTEGER] |
Stacktrace | The Error Occurred in /data/www/pphotels20/html/bdr/application/library/cfc/newsBO.cfc: line 49 47: <cfquery name="loc.qCurrent" dbtype="query">called from /data/www/pphotels20/html/bdr/application/scripts/news/news.cfm: line 80 78:called from /data/www/pphotels20/html/bdr/application/library/cfc/page.cfc: line 120 118: </cfloop>called from /data/www/pphotels20/html/bdr/application/sites/bdr/theme/default/content.cfm: line 5 3:called from /data/www/pphotels20/html/bdr/application/sites/bdr/theme/default/interior.cfm: line 12 10: <cfinclude template="page-title.cfm">called from /data/www/pphotels20/html/bdr/application/sites/bdr/theme/default/index.cfm: line 124 122: <cfelse>called from /data/www/pphotels20/html/bdr/index.cfm: line 28 26:called from /data/www/pphotels20/html/bdr/helpful-info/whats-news/blog/index.cfm: line 1 1: <cfinclude template="parameter.cfm"><cfinclude template="/index.cfm"> |
Java Stacktrace | lucee.runtime.exp.IllegalQoQException: CF_SQL_INTEGER parameter in position 1 is invalid. at lucee.runtime.db.QoQ.executeColumn(QoQ.java:1456) at lucee.runtime.db.QoQ.executeColumn(QoQ.java:1439) at lucee.runtime.db.QoQ.executeExp(QoQ.java:620) at lucee.runtime.db.QoQ.executeCompare(QoQ.java:1201) at lucee.runtime.db.QoQ.executeEQ(QoQ.java:1110) at lucee.runtime.db.QoQ.executeOperation(QoQ.java:709) at lucee.runtime.db.QoQ.executeExp(QoQ.java:621) at lucee.runtime.db.QoQ.executeSingleNonPartitioned(QoQ.java:428) at lucee.runtime.db.QoQ.executeSingle(QoQ.java:273) at lucee.runtime.db.QoQ.execute(QoQ.java:126) at lucee.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:245) at lucee.runtime.tag.Query.executeQoQ(Query.java:1111) at lucee.runtime.tag.Query._doEndTag(Query.java:681) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at application.library.cfc.newsbo_cfc$cf.udfCall(/application/library/cfc/newsBO.cfc:49) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:665) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1794) at application.scripts.news.news_cfm$cf.call(/application/scripts/news/news.cfm:80) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:940) at lucee.runtime.tag.CFTag.doInclude(CFTag.java:319) at lucee.runtime.tag.CFTag.cfmlStartTag(CFTag.java:245) at lucee.runtime.tag.CFTag.doStartTag(CFTag.java:179) at application.library.cfc.page_cfc$cf.udfCall1(/application/library/cfc/page.cfc:120) at application.library.cfc.page_cfc$cf.udfCall(/application/library/cfc/page.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:358) at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:213) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:665) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1952) at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:866) at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1794) at application.sites.bdr.theme._default.content_cfm$cf.call(/application/sites/bdr/theme/default/content.cfm:5) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application.sites.bdr.theme._default.interior_cfm$cf.call(/application/sites/bdr/theme/default/interior.cfm:12) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application.sites.bdr.theme._default.index_cfm$cf.call(/application/sites/bdr/theme/default/index.cfm:124) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at index_cfm$cf.call(/index.cfm:28) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at helpful_info360.whats_news270.blog.index_cfm$cf.call(/helpful-info/whats-news/blog/index.cfm:1) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:219) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1215) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1161) 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:733) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.valves.RemoteIpValve.invoke(RemoteIpValve.java:764) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1707) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source) Caused by: lucee.runtime.exp.CasterException: can't cast empty string to a number value at lucee.runtime.op.Caster.toDoubleValue(Caster.java:459) at lucee.runtime.op.Caster.toIntValue(Caster.java:766) at lucee.runtime.op.Caster.toIntValue(Caster.java:717) at lucee.runtime.op.Caster.toInteger(Caster.java:4517) at lucee.runtime.db.SQLCaster._toCFTypex(SQLCaster.java:470) at lucee.runtime.db.SQLCaster.toCFTypex(SQLCaster.java:436) at lucee.runtime.db.SQLItemImpl.getValueForCF(SQLItemImpl.java:145) at lucee.runtime.db.QoQ.executeColumn(QoQ.java:1450) ... 91 more |
Timestamp | 3/28/24 9:22:09 PM UTC |