Forum topic

Folks,

Trying to update any of the College/College Term or create new entities throws the following error:

*** Error on action - UPDATE_College ***
java.sql.SQLSyntaxErrorException: (conn=548) Table 'gnecsis_lkh4.creditsevaluation' doesn't exist LodDef = nazsis.mCreditsEval Table = CREDITSEVALUATION EntityDef = nazsis.mCreditsEval.CreditsEvaluation SQL => SELECT CREDITSEVALUATION.ID, CREDITSEVALUATION.FULLTIMEMINCREDITS, CREDITSEVALUATION.HALFTIMEMINCREDITS, CREDITSEVALUATION.THREEQTRTIMEMINCREDITS, CREDITSEVALUATION.FK_ID_COLLEGE, CREDITSEVALUATION.FK_ID_COLLEGETERM, COLLEGE.ID, COLLEGE.NAME, COLLEGE.FK_ID_ADMINISTRATIVEDIVISION, COLLEGE.FK_ID_GRADESCALE, COLLEGETERM.ID, COLLEGETERM.FULLTIMEMINCREDITS, COLLEGETERM.GRADEAVAILABILITYDATE, COLLEGETERM.GRADUATEFULLTIMEMINCREDITS, COLLEGETERM.GRADUATEHALFTIMEMINCREDITS, COLLEGETERM.GRADUATEPARTTIMEMINCREDITS, COLLEGETERM.GRADUATETHREEQTRTIMEMINCREDITS, COLLEGETERM.HALFTIMEMINCREDITS, COLLEGETERM.OVERLOADMINCREDITS, COLLEGETERM.PARTTIMEMINCREDITS, COLLEGETERM.YEARSEMESTER, COLLEGETERM.FK_ID_COLLEGEYEAR FROM CREDITSEVALUATION LEFT JOIN COLLEGE ON CREDITSEVALUATION.FK_ID_COLLEGE = COLLEGE.ID LEFT JOIN COLLEGETERM ON CREDITSEVALUATION.FK_ID_COLLEGETERM = COLLEGETERM.ID WHERE CREDITSEVALUATION.FK_ID_COLLEGE = ? ; DB: jdbc:mariadb://localhost:3306/gnecsis_lkh4?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false&useLegacyDatetimeCode=false&serverTimezone=Europe/London&useSSL=false
org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:309)
org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:403)
org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:196)
org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:1411)
org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:1350)
org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:1269)
org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:1193)
org.mariadb.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:91)
org.mariadb.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:290)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.loadEntities(JdbcHandler.java:765)
com.quinsoft.zeidon.dbhandler.JdbcHandler$EntityLoader.access$300(JdbcHandler.java:736)
com.quinsoft.zeidon.dbhandler.JdbcHandler.executeLoad(JdbcHandler.java:384)
com.quinsoft.zeidon.dbhandler.AbstractSqlHandler.loadEntity(AbstractSqlHandler.java:1375)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.singleActivate(ActivateOiFromDB.java:322)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:167)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:113)
com.quinsoft.zeidon.standardoe.ActivateOiFromDB.activate(ActivateOiFromDB.java:42)
com.quinsoft.zeidon.standardoe.ActivateObjectInstance.activate(ActivateObjectInstance.java:102)
com.quinsoft.zeidon.standardoe.AbstractTaskQualification.activateObjectInstance(AbstractTaskQualification.java:127)
com.quinsoft.zeidon.vml.zVIEW.activateObjectInstance(zVIEW.java:553)
com.quinsoft.zeidon.vml.VmlOperation.ActivateObjectInstance(VmlOperation.java:5046)
org.nazarene.nazsis.nTermD_Dialog.UPDATE_College(nTermD_Dialog.java:8802)
org.apache.jsp.nTermDCollegeList_jsp._jspService(nTermDCollegeList_jsp.java:583)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:67)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:501)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:339)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:290)
jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:132)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:59)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:111)
main.java.org.nazarene.nazsis.HstsFilter.doFilter(HstsFilter.java:65)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:111)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:535)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:86)
org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:782)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:71)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:347)
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:406)
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:71)
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:1307)
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:2036)
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:74)
org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:949)
org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:483)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:74)
java.base/java.lang.Thread.run(Thread.java:1583)