Lucee 5.2.9.31 Error (database)
Message
Detail ORA-00936: missing expression
SQL SELECT STAFFEDU.GRADUATEDEYEAR, DEGREELEVEL.DEGREELEVELNAME, DEGREE.DEGREENAME, MAJOR.MAJORNAME, UNIVERSITY.UNIVERSITYNAME
from STAFFEDU JOIN DEGREE ON STAFFEDU.DEGREEID = DEGREE.DEGREEID
JOIN DEGREELEVEL ON STAFFEDU.DEGREELEVELID = DEGREELEVEL.DEGREELEVELID
JOIN MAJOR ON STAFFEDU.MAJORID = MAJOR.MAJORID
JOIN UNIVERSITY ON STAFFEDU.UNIVERSITYID = UNIVERSITY.UNIVERSITYID
WHERE STAFFEDU.STAFFID =
DatabaseName Oracle
DatabaseVersion Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
DriverName Oracle JDBC driver
DriverVersion 12.1.0.2.0
Datasource yruprofile
Stacktrace The Error Occurred in
/home/prof/web/profile.yru.ac.th/public_html/controllers/Profile.cfc: line 13
11: JOIN UNIVERSITY ON STAFFEDU.UNIVERSITYID = UNIVERSITY.UNIVERSITYID
12: WHERE STAFFEDU.STAFFID = #user.STAFFID#
13: </cfquery>
14: </cffunction>
15: </cfcomponent>

called from /home/prof/web/profile.yru.ac.th/public_html/wheels/global/cfml.cfm: line 164
called from /home/prof/web/profile.yru.ac.th/public_html/wheels/controller/processing.cfm: line 128
called from /home/prof/web/profile.yru.ac.th/public_html/wheels/controller/processing.cfm: line 95
called from /home/prof/web/profile.yru.ac.th/public_html/wheels/dispatch/request.cfm: line 198
called from /home/prof/web/profile.yru.ac.th/public_html/wheels/index.cfm: line 1
called from /home/prof/web/profile.yru.ac.th/public_html/rewrite.cfm: line 1
called from /home/prof/web/profile.yru.ac.th/public_html/wheels/events/onrequest.cfm: line 1
Java Stacktrace lucee.runtime.exp.DatabaseException:
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
  at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
  at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
  at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:762)
  at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925)
  at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111)
  at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1792)
  at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1745)
  at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:334)
  at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:293)
  at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:273)
  at lucee.runtime.type.QueryImpl.(QueryImpl.java:226)
  at lucee.runtime.tag.Query.executeDatasoure(Query.java:951)
  at lucee.runtime.tag.Query.doEndTag(Query.java:700)
  at controllers.profile_cfc$cf.udfCall(/controllers/Profile.cfc:13)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:206)
  at lucee.runtime.tag.Invoke.doFunction(Invoke.java:235)
  at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:202)
  at wheels.global.cfml_cfm$cf.udfCall2(/wheels/global/cfml.cfm:164)
  at wheels.global.cfml_cfm$cf.udfCall(/wheels/global/cfml.cfm)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)
  at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:812)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:833)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1737)
  at wheels.controller.processing_cfm$cf.udfCall(/wheels/controller/processing.cfm:128)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)
  at lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:812)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:833)
  at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1737)
  at wheels.controller.processing_cfm$cf.udfCall(/wheels/controller/processing.cfm:95)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1718)
  at wheels.dispatch.request_cfm$cf.udfCall1(/wheels/dispatch/request.cfm:198)
  at wheels.dispatch.request_cfm$cf.udfCall(/wheels/dispatch/request.cfm)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997)
  at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)
  at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1718)
  at wheels.index_cfm$cf.call(/wheels/index.cfm:1)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at rewrite_cfm$cf.call(/rewrite.cfm:1)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:933)
  at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:823)
  at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:805)
  at wheels.events.onrequest_cfm$cf.udfCall(/wheels/events/onrequest.cfm:1)
  at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)
  at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)
  at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:693)
  at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)
  at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1997)
  at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438)
  at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
  at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)
  at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2464)
  at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2454)
  at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2427)
  at lucee.runtime.engine.Request.exe(Request.java:44)
  at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1090)
  at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1038)
  at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:102)
  at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
  at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
  at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
  at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:394)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
  at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
  at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
  at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  at java.lang.Thread.run(Thread.java:748)
 
Timestamp 3/28/24 7:45:32 PM ICT