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

Oracle error ORA-00904 upgrading clean db from 6.1.1 to 6.2.0

    Details

      Description

      When upgrading a Liferay 6.1.1 database to 6.2.0 beta 1 the following errors appear:
      08:26:51,156 INFO [localhost-startStop-1][UpgradeProcess:175] Upgrading com.liferay.portal.upgrade.v6_2_0.UpgradeSchema
      08:27:25,739 WARN [localhost-startStop-1][BaseDB:455] ORA-00904: "62": ugyldig identifikator: update Portlet set active_ = 0 where portletId = "62";
      08:27:25,741 WARN [localhost-startStop-1][BaseDB:455] ORA-00904: "173": ugyldig identifikator: update Portlet set active_ = 0 where portletId = "173";

      This is caused by line 505 and 506 in update-6.1.1-6.2.0.sql:
      update Portlet set active_ = FALSE where portletId = "62";
      update Portlet set active_ = FALSE where portletId = "173";

      The quotes (") should be replaced with apostrophes ('), as in the rest of the file.

      Looking at SVN trunk, the problem still exists, and now also appears on line 507 as well.

        Attachments

          Activity

            People

            • Assignee:
              john.co John Co
              Reporter:
              lms Lars Møller Sørensen (Inactive)
              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:
                6 years, 7 weeks ago

                Packages

                Version Package
                6.2.0 CE B3