I have installed the windows version and everything works so far except for saving question papers. The system says it is saved however when the page refreshes it does not show anything under question papers. I think this below error regarding the SQL query might be the culprit. Any ideas?
at com.kaldin.company.filter.CompanyFilter.doFilter(CompanyFilter.java:4
9) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Unknown Source) com.kaldin.common.db.MySQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t o use near 'OPTION SQL_SELECT_LIMIT=100000' at line 1 SQL Failed: select COUNT(DISTINCT(ets.userid )) as cnt from exm_test_schedule e ts,exm_result ee ,exm_test_given etg where ee.examid = ets.examid and ets.test id = ee.testid and ets.userid = ee.userid and etg.examid = ets.examid and ets.t estid = etg.testid and ets.userid = etg.userid and ee.remark='PASS' and ets.comp anyid = ? at com.kaldin.common.db.ExceptionFactory.getException(ExceptionFactory.j ava:29) at com.kaldin.common.db.QueryHelper.runQueryStreamResults(QueryHelper.ja va:328) at com.kaldin.user.login.dao.SitemapDAO.getTotalCandidatesPassedtheExamC ount(SitemapDAO.java:161) at com.kaldin.user.login.action.SitemapAction.execute(SitemapAction.java :80) at org.apache.struts.action.RequestProcessor.processActionPerform(Reques tProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp atcher.java:630) at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applica tionDispatcher.java:436) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationD ispatcher.java:374) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDis patcher.java:302) at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor. java:1062) at org.apache.struts.action.RequestProcessor.processForwardConfig(Reques tProcessor.java:386) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.ja va:229) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:119 6) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at com.kaldin.common.util.UserSessionFilter.doFilter(UserSessionFilter.j ava:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at com.kaldin.company.filter.CompanyFilter.doFilter(CompanyFilter.java:4 9) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl icationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF ilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV alve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV alve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j ava:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j ava:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal ve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav a:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java :845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce ss(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:44 7) at java.lang.Thread.run(Unknown Source) id : 0 com.kaldin.common.db.MySQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax t o use near 'OPTION SQL_SELECT_LIMIT=100000' at line 1 SQL Failed: select t.*, (select count(distinct ets.examid) from exm_test_schedul e ets where ets.testid=t.testid and ets.examid > 0) as examecount from exm_test t left join exm_test_schedule ts on t.testid=ts.testid where t.companyid=? group by t.testid at com.kaldin.common.db.ExceptionFactory.getException(ExceptionFactory.j ava:29) at com.kaldin.common.db.QueryHelper.runQueryStreamResults(QueryHelper.ja va:328) at com.kaldin.test.
