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.UNIVERSITYIDcalled from /home/prof/web/profile.yru.ac.th/public_html/wheels/global/cfml.cfm: line 164 162: <cfset StructDelete(arguments, "invokeArgs")>called from /home/prof/web/profile.yru.ac.th/public_html/wheels/controller/processing.cfm: line 128 126: if (StructKeyExists(this, arguments.action) && IsCustomFunction(this[arguments.action]))called from /home/prof/web/profile.yru.ac.th/public_html/wheels/controller/processing.cfm: line 95 93: {called from /home/prof/web/profile.yru.ac.th/public_html/wheels/dispatch/request.cfm: line 198 196: // create the requested controller and call the action on itcalled from /home/prof/web/profile.yru.ac.th/public_html/wheels/index.cfm: line 1 1: <cfoutput>#application.wheels.dispatch.$request()#</cfoutput>called from /home/prof/web/profile.yru.ac.th/public_html/rewrite.cfm: line 1 1: <cfinclude template="wheels/index.cfm">called from /home/prof/web/profile.yru.ac.th/public_html/wheels/events/onrequest.cfm: line 1 1: <cffunction name="onRequest" returntype="void" access="public" output="true"><cfargument name="targetpage" type="any" required="true"><cflock name="reloadLock#application.applicationName#" type="readOnly" timeout="180"><cfinclude template="#arguments.targetpage#"></cflock></cffunction> |
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. 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/29/24 6:07:40 PM ICT |