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

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.10 EE GA1
• Fix Version/s: 6.2.3 CE GA4, 6.2.X EE, 7.0.0 M2
• Component/s: DM > Upgrade, Documents & Media, Legacy > Image Gallery
• Labels:
  • liferay-fixpack-document-management-15-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 9
• Git Pull Request: https://github.com/migue/liferay-portal/pull/336

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.