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

Document Selector is temporarily unavailable happens on Upload field

    Details

      Description

      Step to reproduce:

      1. Add a web content structure with an Upload field
      2. Add a web content based on new structure
      3. Click the Select button of Upload field

      Expected Results:
      The modal should be rendered well.

      Actual Results:
      The Document Selector is temporarily unavailable. Additionallly, the following error is thrown in server console

      2021-01-22 10:00:30.039 ERROR [http-nio-8080-exec-6][PortletRequestDispatcherImpl:304] Unable to dispatch request: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 2 in query:   SELECT COUNT(DISTINCT DLFileVersion.fileEntryId) AS COUNT_VALUE FROM DLFileVersion WHERE (DLFileVersion.groupId = ?) AND (DLFileVersion.status = ?)  AND ((DLFileVersion.folderId = 39298))
      2021-01-22 10:00:30.041 ERROR [http-nio-8080-exec-6][PortletServlet:119] javax.portlet.PortletException: org.apache.jasper.JasperException: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 2 in query:   SELECT COUNT(DISTINCT DLFileVersion.fileEntryId) AS COUNT_VALUE FROM DLFileVersion WHERE (DLFileVersion.groupId = ?) AND (DLFileVersion.status = ?)  AND ((DLFileVersion.folderId = 39298))
      javax.portlet.PortletException: org.apache.jasper.JasperException: com.liferay.portal.kernel.exception.SystemException: java.lang.IllegalArgumentException: Positional parameter does not exist: 2 in query:   SELECT COUNT(DISTINCT DLFileVersion.fileEntryId) AS COUNT_VALUE FROM DLFileVersion WHERE (DLFileVersion.groupId = ?) AND (DLFileVersion.status = ?)  AND ((DLFileVersion.folderId = 39298))
              at com.liferay.portlet.internal.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:307)
              at com.liferay.portlet.internal.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:123)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.include(MVCPortlet.java:571)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.include(MVCPortlet.java:587)
              at com.liferay.portal.kernel.portlet.bridges.mvc.MVCPortlet.doView(MVCPortlet.java:177)
              at com.liferay.portal.kernel.portlet.LiferayPortlet.doDispatch(LiferayPortlet.java:302)
      

      Reproduced on:
      Tomcat 9.0.37 + MySQL 5.7. Portal master GIT ID: a9c7b417e8ef81cb4e42d79359abdb1d7121aba0.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              yang.cao Yang Cao
              Participants of an Issue:
              Recent user:
              Yang Cao
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                44 weeks, 2 days ago

                  Packages

                  Version Package