Forum LAMS for Tech-Heads - General Forum: Problem with Multiple Choice Question activity in LAMS


 
You may request notification for Problem with Multiple Choice Question activity in LAMS.
Search: 

1: Problem with Multiple Choice Question activity in LAMS
08/11/08 08:29 PM
[ Reply | Forward ]
Hi LAMS community,

I am trying to set up a LAMS sequence for a lecturer at Macquarie and I am getting a consistent crash when moving to the Multiple Choice Activity when previewing the sequence.

This is the error message I get:

org.hibernate.exception.SQLGrammarException: could not execute query Show detail

I have pasted the "show detail" log at the bottom of the page.

I have tried troubleshooting this by looking for problematic characters and deleting questions but nothing seems to fix it.

I am not sure of the exact version in use here, apart from the fact that is is LAMS 2.

Is this a known bug or can anyone help?

Many thanks in advance.

_______________________________________________

Show detail log:

org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1564) at org.hibernate.loader.Loader.list(Loader.java:1544) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:830) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.lamsfoundation.lams.tool.mc.dao.hibernate.McUserDAO.getMcUserBySession(McUserDAO.java:73) at org.lamsfoundation.lams.tool.mc.service.McServicePOJO.getMcUserBySession(McServicePOJO.java:437) at sun.reflect.GeneratedMethodAccessor4097.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy130.getMcUserBySession(Unknown Source) at org.lamsfoundation.lams.tool.mc.web.McLearningStarterAction.execute(McLearningStarterAction.java:383) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doGet(Actio

Posted by Timothy Allen

2: Re: Problem with Multiple Choice Question activity in LAMS
In response to 1 08/11/08 10:05 PM
[ Reply | Forward ]
FYI it's version 2.1.

Posted by Timothy Allen

3: Re: Problem with Multiple Choice Question activity in LAMS
In response to 1 08/12/08 01:44 AM
[ Reply | Forward ]
It's a problem with the recent update; I've fixed this particular problem on your server (I have access to it).

Thanks!

Posted by Jun-Dir Liew

4: Re: Re: Problem with Multiple Choice Question activity in LAMS
In response to 3 08/12/08 02:11 AM
[ Reply | Forward ]
Thank you Jun-dir. :)

Was this related to code that will require a bug fix in LAMS or something happening on the network side of things?

Kamsamnida!

Posted by Timothy Allen

5: Re: Re: Re: Problem with Multiple Choice Question activity in LAMS
In response to 4 08/12/08 06:07 PM
[ Reply | Forward ]
Neither - because the server was running 2.0.6, it required special attention to upgrade it to 2.1 due to our standardised updater for 2.0.4. Turns out we missed something - thank you for picking it up :)

Posted by Jun-Dir Liew

6: Re: Re: Re: Re: Problem with Multiple Choice Question activity in LAMS
In response to 5 12/13/08 09:55 PM
[ Reply | Forward ]
The multiple choice activity still seems to crash. Any suggestions or assistance would be appreciated. Thanks!



org.hibernate.exception.SQLGrammarException: could not execute query Show detail
org.hibernate.exception.SQLGrammarException: could not execute query at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:70) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.loader.Loader.doList(Loader.java:1564) at org.hibernate.loader.Loader.list(Loader.java:1544) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:830) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at org.lamsfoundation.lams.tool.mc.dao.hibernate.McContentDAO.findMcContentById(McContentDAO.java:63) at org.lamsfoundation.lams.tool.mc.service.McServicePOJO.retrieveMc(McServicePOJO.java:181) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:165) at $Proxy176.retrieveMc(Unknown Source) at org.lamsfoundation.lams.tool.mc.web.McStarterAction.existsContent(McStarterAction.java:605) at org.lamsfoundation.lams.tool.mc.web.McStarterAction.execute(McStarterAction.java:313) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194) at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.lamsfoundation.lams.web.filter.LocaleFilter.doFilterInternal(LocaleFilter.java:140) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:77) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.lamsfoundation.lams.web.session.SystemSessionFilter.doFilter(SystemSessionFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:153) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.lamsfoundation.lams.integration.security.SingleSignOn.invoke(SingleSignOn.java:121) at org.lamsfoundation.lams.integration.security.LoginRequestValve.invoke(LoginRequestValve.java:67) at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:481) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: Unknown column 'mccontent0_.displayAnswers' in 'field list' at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1030) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:296) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1237) at org.hibernate.loader.Loader.doQuery(Loader.java:374) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) at org.hibernate.loader.Loader.doList(Loader.java:1561) ... 59 more

Posted by Bronwyn Moreton

7: Re: Re: Re: Re: Re: Problem with Multiple Choice Question activity in LAMS
In response to 6 12/13/08 10:53 PM
[ Reply | Forward ]
Hi Bronwyn,

When is it that you get this error?

What LAMS version are you running?

Thanks,

Ernie

Posted by Ernie Ghiglione

8: Problem with Multiple Choice Question activity in LAMS
In response to 7 12/15/08 04:08 AM
[ Reply | Forward ]
Hi Ernie,
Sorry for not being more specific. A few days ago I was logged in to the Mac Uni ICT server, trying to use the MC tool for the first time. I added the MC tool to my sequence, but the given error message was displayed when I clicked on the MC tool to add detail. Don't know what version the ICT server is running. Thanks for your help, Bronwyn.

Posted by Bronwyn Moreton

9: Re: Problem with Multiple Choice Question activity in LAMS
In response to 8 12/15/08 04:11 AM
[ Reply | Forward ]
Just checked out the ICT site. States version 2.2 is running.

Posted by Bronwyn Moreton

10: Re: Problem with Multiple Choice Question activity in LAMS
In response to 8 12/15/08 08:04 PM
[ Reply | Forward ]
Hi Bronwyn,

This is fixed now. It was our fault. We forgot to change something when we did the upgrade to the latest version. It's all good now :-)

Thanks for letting us know.

Ernie

Posted by Ernie Ghiglione

Reply to first post on this page
Back to LAMS for Tech-Heads - General Forum
.LRN Home