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

Countries and regions are not properly upgraded to master

    Description

    Steps to reproduce:

    1. Start 7.3 portal or below
    2. Create a user
    3. Edit user's address
    4. Upgrade to master
    5. Go to user

    Expected results: Countries and regions added in previous version still exist. User can still successfully add an address in Users and Organizations.

    Actual results:

    • The following errors display after starting up:
      2020-12-04 22:02:38.235 ERROR [http-nio-8080-exec-2][JDBCExceptionReporter:234] Unknown column 'countryimp0_.defaultLanguageId' in 'field list'
      2020-12-04 22:02:38.237 ERROR [http-nio-8080-exec-2][JSONWebServiceServiceAction:126] com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not load an entity: [com.liferay.portal.model.impl.CountryImpl#19]
      
    • Country does not display for existing users or organizations
    • Countries and Region fields are not responsive
    • Adding or editing address after upgrade result to console errors

    Reproduced on:
    Tomcat 9.0.33 + MySQL 5.7
    Portal master GIT ID: f674c566d1d9ac9a2e33ac2e38b66af3b294e572

      Attachments

        Activity

          People

          Assignee:
          sharry.shi Sharry Shi
          Reporter:
          patricia.perez Patricia Perez
          Participants of an Issue:
          Recent user:
          Brian Wulbern
          Engineering Assignee:
          Drew Brokke
          Votes:
          0 Vote for this issue
          Watchers:
          0 Start watching this issue

            Dates

            Created:
            Updated:
            Resolved:
            Days since last comment:
            11 weeks, 1 day ago

              Packages

              Version Package
              Master