Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-39999

Synoptic Forums tool causes SQLException when Forums tool is removed

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Incorporated
    • Affects Version/s: 19.0
    • Fix Version/s: None
    • Component/s: Forums Tool
    • Labels:
      None
    • Test Plan:
      Hide
      1. Add Forums to a site
      2. Add new content to forums so that a user would notice there is new unread posts
      3. Remove Forums tool from the site via Site-Info -> Manage Tools
      4. User will see a stacktrace in the synoptic tool from their My Workspace
      Show
      Add Forums to a site Add new content to forums so that a user would notice there is new unread posts Remove Forums tool from the site via Site-Info -> Manage Tools User will see a stacktrace in the synoptic tool from their My Workspace

      Description

      org.sakaiproject.portal.api.PortalHandlerException: org.sakaiproject.tool.api.ToolException: org.apache.jasper.JasperException: javax.faces.el.EvaluationException: Error getting property 'messagesUrl' from bean of type org.sakaiproject.tool.messageforums.ui.MessageForumSynopticBeanLite$DecoratedSynopticMsgcntrItem: org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
          at org.sakaiproject.portal.charon.SkinnableCharonPortal.doGet(SkinnableCharonPortal.java:857)
      caused by: org.sakaiproject.tool.api.ToolException: org.apache.jasper.JasperException: javax.faces.el.EvaluationException: Error getting property 'messagesUrl' from bean of type org.sakaiproject.tool.messageforums.ui.MessageForumSynopticBeanLite$DecoratedSynopticMsgcntrItem: org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
          at org.sakaiproject.portal.charon.SkinnableCharonPortal.forwardTool(SkinnableCharonPortal.java:1488)
      caused by: org.apache.jasper.JasperException: javax.faces.el.EvaluationException: Error getting property 'messagesUrl' from bean of type org.sakaiproject.tool.messageforums.ui.MessageForumSynopticBeanLite$DecoratedSynopticMsgcntrItem: org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
          at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:481)
      caused by: javax.faces.el.EvaluationException: Error getting property 'messagesUrl' from bean of type org.sakaiproject.tool.messageforums.ui.MessageForumSynopticBeanLite$DecoratedSynopticMsgcntrItem: org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
          at com.sun.faces.el.impl.ArraySuffix.evaluate(ArraySuffix.java:187)
      caused by: org.springframework.orm.hibernate4.HibernateJdbcException: JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [1364]; could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement
          at org.springframework.orm.hibernate4.HibernateTemplate.doExecute(HibernateTemplate.java:344)
      caused by: org.hibernate.exception.GenericJDBCException: could not execute statement
          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
      caused by: java.sql.SQLException: Field 'RESTRICT_PERMS_FOR_GROUPS' doesn't have a default value
          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  Unassigned Unassigned
                  Reporter:
                  ern Earle R Nietzel
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration