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

Table 'audit_auditevent' already exists when upgrade from 6.2 to 7.0

    Details

      Description

      Description

      Upgrade fails with an error. The issue doesn't exist in master because the module doesn't exist in master.

      Reproduction Steps

      1. Start up Liferay 6.2 EE SP15
      2. Deploy Audit portlet
      3. Shut down the portal
      4. In Liferay DXP 7.0 SP2/tools/portal-tools-db-upgrade-client, run the command "java -jar com.liferay.portal.tools.db.upgrade.client.jar" and go through upgrade wizard
      5. Wait for the upgrade process to complete.

      Actual Result: An error occurs as the following

      07:26:31,698 ERROR [main][com_liferay_portal_upgrade:97] Invocation to listener threw exception
      java.lang.RuntimeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'audit_auditevent' already exists
      

      Expected Result: No error occurs and upgrade is successful.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                michael.han Michael Han
                Reporter:
                hai.yu Hai Yu
                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:
                  2 years, 16 weeks, 3 days ago

                  Packages

                  Version Package
                  7.0.X EE
                  Master