Details

      Description

      Steps to reproduce

      1. Add Wiki page
      2. Add comments to Wiki Page
      3. Navigate to Site > Content > Wiki
      4. Go to Wiki page with comment/s

      Expected result: Wiki Title, Wiki Content, and Wiki Comments are displayed properly

      Actual result: Wiki Content is missing in Site Admin; Title and Views are on the sidebar
      Console errors are thrown:

      23:06:03,580 ERROR [http-nio-8080-exec-8][IncludeTag:128] Current URL /group/guest/~/control_panel/manage?p_p_id=com_liferay_wiki_web_portlet_WikiAdminPortlet&p_p_lifecycle=0&p_p_state=maximized&p_p_mode=view&_com_liferay_wiki_web_portlet_WikiAdminPortlet_mvcRenderCommandName=%2Fwiki%2Fview&_com_liferay_wiki_web_portlet_WikiAdminPortlet_redirect=http%3A%2F%2Flocalhost%3A8080%2Fgroup%2Fguest%2F~%2Fcontrol_panel%2Fmanage%3Fp_p_id%3Dcom_liferay_wiki_web_portlet_WikiAdminPortlet%26p_p_lifecycle%3D0%26p_p_state%3Dmaximized%26p_p_mode%3Dview%26_com_liferay_wiki_web_portlet_WikiAdminPortlet_redirect%3Dhttp%253A%252F%252Flocalhost%253A8080%252Fgroup%252Fguest%252F%257E%252Fcontrol_panel%252Fmanage%253Fp_p_id%253Dcom_liferay_wiki_web_portlet_WikiAdminPortlet%2526p_p_lifecycle%253D0%2526p_p_state%253Dmaximized%2526p_p_mode%253Dview%26_com_liferay_wiki_web_portlet_WikiAdminPortlet_mvcRenderCommandName%3D%252Fwiki%252Fview_pages%26_com_liferay_wiki_web_portlet_WikiAdminPortlet_navigation%3Dall-pages%26_com_liferay_wiki_web_portlet_WikiAdminPortlet_nodeId%3D32027&_com_liferay_wiki_web_portlet_WikiAdminPortlet_nodeName=Main&_com_liferay_wiki_web_portlet_WikiAdminPortlet_title=wiki%20page generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.GenericJDBCException: could not execute query
      java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
              at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3739)
              at org.hibernate.type.descriptor.sql.DoubleTypeDescriptor$1.doBind(DoubleTypeDescriptor.java:52)
              at org.hibernate.type.descriptor.sql.BasicBinder.bind(BasicBinder.java:91)
              at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:283)
              at org.hibernate.type.AbstractStandardBasicType.nullSafeSet(AbstractStandardBasicType.java:278)
              at org.hibernate.loader.Loader.bindPositionalParameters(Loader.java:1873)
              at org.hibernate.loader.Loader.bindParameterValues(Loader.java:1844)
              at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1716)
              at org.hibernate.loader.Loader.doQuery(Loader.java:801)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
              at org.hibernate.loader.Loader.doList(Loader.java:2542)
              at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
              at org.hibernate.loader.Loader.list(Loader.java:2271)
              at org.hibernate.hql.classic.QueryTranslatorImpl.list(QueryTranslatorImpl.java:940)
              at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
              at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
      

      Reproduced on:
      Tomcat 8.0.32 + MySQL 5.6
      Portal ee-7.0.x GIT ID: 7606d95aea3aa1170fe509cd4d5966d93681a059
      Portal master GIT ID: 56cad1c4474ad03eb2921b9a7fc6e4683109c1c9

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                patricia.perez Patricia Perez
                Reporter:
                patricia.perez Patricia Perez
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 1 week, 6 days ago