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

Upgrade to 6.1 failed when migrating comunities with staging and a different logo from the instance, when using PostgreSQL

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Inactive
    • Affects Version/s: 6.1.10 EE GA1
    • Fix Version/s: None
    • Component/s: Core Infrastructure
    • Environment:
      PostgreSQL
    • Fix Priority:
      4

      Description

      The upgrade process to 6.1 fails with the following exception

      Caused by: org.postgresql.util.PSQLException: The column name Group_.groupId was not found in this ResultSet.
      at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2542)
      at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2411)
      at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:278)
      at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getLong(DelegatingResultSet.java:278)
      at com.liferay.portal.upgrade.v6_1_1.UpgradeLayoutSet.doUpgrade(UpgradeLayoutSet.java:54)
      at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)

      The exception is thrown when using PostgreSQL (the process runs fine with MySQL). The exception is only thrown when there are communities/organizations using staging that have a different logo from the one of the company.

      Considering the code, the problem could probably be reproduced in trunk, but it could not be verified due to other issues.

        Attachments

          Activity

            People

            Assignee:
            michael.saechang Michael Saechang
            Reporter:
            alberto.montero Alberto Montero
            Participants of an Issue:
            Recent user:
            Marta Elicegui
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              10 years, 4 weeks, 4 days ago

                Packages

                Version Package