fired up my very first lucee server tonight!
iām running lucee 5 express on a windows PC.
my test database is a simple msaccess file that is successfully connected
to lucee via UCanAccess.
the good news is that data inserts and deletes are working perfectly in my
test web app. but, running cfupdate keeps generating a "key [var name here]
doesnāt exist. for example:
Lucee 5.0.0.252 Error (expression)
Message key [first_name] doesnāt exist
however, i am 100% certain all the variable exist that iām passing into
cfupdate. to verify, i added a cfoutput ādebug reportā before calling
cfupdate and it shows me all the form variables are there before it reaches
the cfupdate line and errors out:
form.firstname var= frst
form.last_name var= lst
form.email_addy var= em
form.console_ var= cons
form.contribution_ var= contrib
form.contribution_details_ var= contribdeets
form.date_time_ var= {ts ā2016-06-01 01:55:07ā}
Lucee 5.0.0.252 Error (expression)
Message key [first_name] doesnāt exist
As you can see - my cfoutput ādebugā reports that form.firstname is being
passed and that #form.firstname# 's value is āfrstā So, it knows it is
there in cfoutput but cfupdate thinks that it is not.
If i remove first_name from cfupdateās formfields, it errors on ālast_nameā
rather than āfirst.nameā. But, if i remove ALL the formfields, it oddly
chooses to error out on ācontribution_ā instead.
I know this exact cfupdate code that is failing in lucee runs on ACF
because i copied it off an old cf server from 2012 where it was publicly
deployed and running successfully.
Any clue what could be causing this and how to resolve? Any questions you
have for me? Anyone want my code and DB? I can zip it up and send/post?
A first-time lucee user would love any help you can give! :)------
[In an attempt to further assist your review of my issue, here is the
actual code snippet of the ādebuggingā cfoutput i shared above followed by
the failing cfupdate call:
form.last_name var= #form.last_name#
form.email_addy var= #form.email_addy#
form.console_ var= #form.console_#
form.contribution_ var= #form.contribution_#
form.contribution_details_ var= #form.contribution_details_#
form.date_time_ var= #form.date_time_#
and, here is the full error output - even though to my untrained eye, i
donāt think it offers much clarification as to why the error is occurring:
Lucee 5.0.0.252 Error (expression)
Message key [first_name] doesnāt exist
Stacktrace The Error Occurred in
G:\LUCEEexp\webapps\ROOT\AdamsEve\party.vnx: line 95
93: <cfupdate datasource=āchaddbā
94: tablename=āAdamsEveā
95: formfields=āfirst_name, last_name, email_addy, console_,
contribution_, contribution_details_, date_time_ā>
96: Guest Information Modified. Thanks & See You There!
97:
Java Stacktrace lucee.runtime.exp.ExpressionException: key [first_name]
doesnāt exist
at
lucee.runtime.type.util.StructSupport.invalidKey(StructSupport.java:67)
at lucee.runtime.type.StructImpl.get(StructImpl.java:122)
at lucee.runtime.type.util.StructSupport.get(StructSupport.java:136)
at lucee.runtime.tag.Update.createSQL(Update.java:277)
at lucee.runtime.tag.Update.doEndTag(Update.java:182)
at
adamseve.party_vnx$cf.call(G:\LUCEEexp\webapps\ROOT\AdamsEve\party.vnx:95)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:893)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:808)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:803)
at
lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:226)
at
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2250)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2242)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2210)
at
lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:848)
at
lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:103)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:62)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085)
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658)
at
org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556)
at
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Timestamp 6/1/16 2:02:17 AM EDT
thanks again!!!