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

ORA-00904: "DLFILEENTRY"."MANUALCHECKINREQUIRED": invalid identifier_ during upgrade from 6.0 SP2 to 6.2 SP7

Details

    Description

      Images cannot be upgraded from 6.0 SP2 to 6.2 SP7 direct upgrade because of ORA-00904: "DLFILEENTRY"."MANUALCHECKINREQUIRED": invalid identifier_ error.

      Images are stored in database in 6.0 SP2 (image.hook.impl=com.liferay.portal.image.DatabaseHook)

      Steps to reproduce:
      1. Set up a vanilla 6.0 SP2 and a 6.2 SP7 portal with MySql 5.5.21 connection (point to the same database)
      2. Also set these properties in 6.0 SP2 and a 6.2 SP7:
      image.hook.impl=com.liferay.portal.image.DatabaseHook
      ig.image.thumbnail.max.dimension=100
      ig.image.custom1.max.dimension=300
      ig.image.custom2.max.dimension=400
      3. Start up 6.0 SP2 and add Image Gallery portlet to a page.
      4. Upload some images via both classic and multi uploader into Image Gallery portlet.
      5. Shut down 6.0 SP2
      6. Copy 6.0 SP2's data folder into 6.2 SP8
      7. Start up 6.2 SP8.

      Attachments

        Issue Links

          Activity

            People

              joyce.wang Joyce Wang
              adorjan.nagy Adorjan Nagy (Inactive)
              Kiyoshi Lee Kiyoshi Lee
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                8 years, 11 weeks, 4 days ago

                Packages

                  Version Package
                  6.2.3 CE GA4
                  6.2.X EE
                  7.0.0 M2