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

Web Content Display configuration: User loses the web content List after changing the "Modified Date" column sort.

    Details

      Description

      Steps to reproduce this issue:

      1 . - Put a Web Content Display on a page
      2 . - Click the "Select Web Content"
      3 . - The results are showed correctly
      4 . - Click on the "Modified Date" date column to invert the sort.
      5 . - The list disappears(blank page)
      6 . - You return to the Web Contet Page an press "Select Web Content"
      7 . - The list disappears(blank page) ever for this user and for all the browsers.

      Note: We try to delete the cache/cookies browser and the problem persists.

      You can see in logs:

      14:46:07,190 ERROR [ajp-apr-8015-exec-98][JDBCExceptionReporter:82] ORA-00918: column ambiguously defined_ [Sanitized]
      14:46:07,201 ERROR [ajp-apr-8015-exec-98][IncludeTag:129] Current URL /informacio?p_p_id=86&p_p_lifecycle=0&p_p_state=pop_up&p_p_col_id=column-1&p_p_col_pos=1&p_p_col_count=2&_86_struts_action=%2Fportlet_configuration%2Fedit_configuration&_86_redirect=%2Finformacio&_86_returnToFullPageURL=%2Finformacio&_86_portletResource=56_INSTANCE_kZ2biZtGdNDr&_86_resourcePrimKey=148834_LAYOUT_56_INSTANCE_kZ2biZtGdNDr&_86_%20&yui_patched_v3_11_0_1_1394804927190_656=1394804941258 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
      java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined_ [Sanitized]
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
              at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
              at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
              at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
              at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
              at org.hibernate.loader.Loader.doQuery(Loader.java:802)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
              at org.hibernate.loader.Loader.doList(Loader.java:2542)
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              shitian.zhang Shitian "Shelton" Zhang (Inactive)
              Reporter:
              xrodrig Xavier Rodríguez
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                5 years, 22 weeks, 5 days ago

                  Packages

                  Version Package
                  6.2.3 CE GA4
                  6.2.X EE