Uploaded image for project: 'OpenOLAT'
  1. OpenOLAT
  2. OO-1174

Cannot delete a group with option "send e-mails"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0.1
    • Component/s: None
    • Labels:
      None

      Description

      Delete a group with the option "Do you want to inform the members of this group by email?" -> Red screen

      2014-09-02 14:37:48,017 [ajp-apr-8016-exec-9] ERROR OLATRuntimeException - OLAT::ERROR ^%^ N16-E2 ^%^ org.olat.core.logging 
      Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Trident/5.0) ^%^ **RedScreen** org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      
      <dispatchinfo>
      	<componentinfo>
      		<compname>ffo_main_group_delete_confirmation</compname>
      		<compclass>org.olat.core.gui.components.form.flexible.impl.FormWrapperContainer</compclass>
      		<extendedinfo>n/a</extendedinfo>
      		<event>
      			<class&gt;org.olat.core.gui.control.Event</class&gt;
      			<command>validation ok</command>
      			<tostring>com:validation ok,org.olat.core.gui.control.Event@d62b3f02</tostring>
      		</event>
      	</componentinfo>
      	<controllerinfo>
      		<controllername>org.olat.group.ui.main.BusinessGroupDeleteDialogBoxController</controllername>
      		<controllername>org.olat.group.ui.main.BusinessGroupListController</controllername>
      		<controllername>org.olat.group.ui.main.OverviewBusinessGroupListController</controllername>
      		<controllername>org.olat.core.commons.fullWebApp.BaseFullWebappController</controllername>
      	</controllerinfo>
      </dispatchinfo>
      
      >>> stack of 1.cause::org.olat.core.logging.OLATRuntimeException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.olat.core.gui.exception.ExceptionWindowController.<init>(ExceptionWindowController.java:116)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:57)
         at org.olat.core.gui.exception.MsgFactory.createMessageChiefController(MsgFactory.java:46)
         at org.olat.core.gui.components.Window.dispatchRequest(Window.java:524)
         at org.olat.core.gui.components.Window.doDispatchRequest(Window.java:228)
         at org.olat.core.gui.components.AbstractComponent.dispatchRequest(AbstractComponent.java:192)
         at org.olat.dispatcher.AuthenticatedDispatcher.processValidDispatchURI(AuthenticatedDispatcher.java:241)
         at org.olat.dispatcher.AuthenticatedDispatcher.execute(AuthenticatedDispatcher.java:197)
         at org.olat.core.servlets.OpenOLATServlet.executeUserRequest(OpenOLATServlet.java:265)
         at org.olat.core.servlets.OpenOLATServlet.doPost(OpenOLATServlet.java:208)
         at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
      >>> stack of 2.cause::javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1763)
         at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1677)
         at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:458)
         at org.olat.group.manager.BusinessGroupRelationDAO.getMembers(BusinessGroupRelationDAO.java:184)
         at org.olat.group.manager.BusinessGroupServiceImpl.deleteBusinessGroupWithMail(BusinessGroupServiceImpl.java:760)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.doDelete(AbstractBusinessGroupListController.java:989)
         at org.olat.group.ui.main.AbstractBusinessGroupListController.event(AbstractBusinessGroupListController.java:420)
         at org.olat.core.gui.control.DefaultController$1.run(DefaultController.java:240)
         at org.olat.core.logging.activity.ThreadLocalUserActivityLoggerInstaller.runWithUserActivityLogger(ThreadLocalUserActivityLoggerInstaller.java:108)
         at org.olat.core.gui.control.DefaultController.dispatchEvent(DefaultController.java:237)
         at org.olat.core.gui.control.DefaultController.fireEvent(DefaultController.java:185)
      >>> stack of 3.cause::org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      -> at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
         at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
         at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
         at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
         at org.hibernate.loader.Loader.getResultSet(Loader.java:2065)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1862)
         at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838)
         at org.hibernate.loader.Loader.doQuery(Loader.java:909)
         at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354)
         at org.hibernate.loader.Loader.doList(Loader.java:2553)
      >>> stack of 4.cause::com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;
          check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 1
      -> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
         at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
         at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
         at java.lang.reflect.Constructor.newInstance(Unknown Source)
         at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
         at com.mysql.jdbc.Util.getInstance(Util.java:386)
         at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
         at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
         at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
         at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
      

        Attachments

          Activity

            People

            • Assignee:
              srosse Stéphane Rossé
              Reporter:
              srosse Stéphane Rossé
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: