Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-66485

Content of Wiki Page with comments does not show up in Site Admin

    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, 18 weeks, 6 days ago

                  Packages

                  Version Package
                  7.0.1 CE GA2