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

UpgradeSocial - java.sql.BatchUpdateException: Unknown column 'ype_' in 'field list'

    Details

      Description

      Trying to get to 5.2.6 with branch revision 36401, but having the following error during upgrade :

      log :

      Starting Liferay Portal Standard Edition 5.2.3 (Augustine / Build 5203 / May 20, 2009)
      16:01:21,953 WARN [ReleaseLocalServiceImpl:246] Unknown column 'testString' in 'where clause'
      16:01:21,984 INFO [DBUtil:544] Database does not support case sensitive queries
      16:01:22,000 INFO [UpgradeProcess:95] Upgrading com.liferay.portal.upgrade.UpgradeProcess_5_2_4
      16:01:22,000 INFO [UpgradeProcess:95] Upgrading com.liferay.portal.upgrade.v5_2_4.UpgradeBlogs
      16:01:22,546 INFO [UpgradeProcess:95] Upgrading com.liferay.portal.upgrade.v5_2_4.UpgradePortletId
      16:01:22,593 INFO [UpgradeProcess:95] Upgrading com.liferay.portal.upgrade.v5_2_4.UpgradeSocial
      16:01:24,078 ERROR [MainServlet:168] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.upgrade.UpgradeException: com.liferay.portal.upgrade.UpgradeException: java.sql.BatchUpdateException: Unknown column 'ype_' in

      'field list'
      com.liferay.portal.kernel.events.ActionException: com.liferay.portal.upgrade.UpgradeException: com.liferay.portal.upgrade.UpgradeException: java.sql.BatchUpdateException: Unknown column 'ype_' in 'field list'

      There is a typo.

      ../upgrade/v5_2_4/util/SocialRelationTable.java

      public static final Object[][] TABLE_COLUMNS = {

      {"uuid_", new Integer(Types.VARCHAR)}

      ,

      {"relationId", new Integer(Types.BIGINT)}

      ,

      {"companyId", new Integer(Types.BIGINT)}

      ,

      {"createDate", new Integer(Types.BIGINT)}

      ,

      {"userId1", new Integer(Types.BIGINT)}

      ,

      {"userId2", new Integer(Types.BIGINT)}

      ,

      {"ype_", new Integer(Types.INTEGER)}

      };

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              support-lep@liferay.com SE Support
              Reporter:
              stanm Stan X
              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:
                7 years, 51 weeks, 5 days ago

                  Packages

                  Version Package
                  6.0.0 Preview