Uploaded image for project: 'ZZZ: PUBLIC - Old Liferay Portal (Use Liferay Portal Standard Edition)'
  1. ZZZ: PUBLIC - Old Liferay Portal (Use Liferay Portal Standard Edition)
  2. LEP-3243

Liferay upgrade 421 to 430 on mysql 41 varchar(1024) errors

    Details

    • Type: Task
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 4.3.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      The automatic upgrade from LE 4.2 .1to 4.3.1 on a MySql 4.1 Databes gives to following errors

      07:17:37,196 WARN [tools.sql.DBUtil] Too big column length for column 'name' (max = 255). Use BLOB instead
      07:17:37,297 WARN [tools.sql.DBUtil] Too big column length for column 'url' (max = 255). Use BLOB instead
      07:17:37,298 WARN [tools.sql.DBUtil] Too big column length for column 'url' (max = 255). Use BLOB instead
      07:17:37,330 WARN [tools.sql.DBUtil] Too big column length for column 'pageURL' (max = 255). Use BLOB instead
      07:17:37,331 WARN [tools.sql.DBUtil] Too big column length for column 'downloadPageURL' (max = 255). Use BLOB instead
      ...
      07:17:47,832 ERROR [portal.servlet.MainServlet] com.liferay.portal.struts.ActionException: com.liferay.portal.struts.ActionException: com.liferay.portal.upgrade.UpgradeException: java.sql.SQLException: Too big column length for column 'name' (max = 255). Use BLOB instead
      com.liferay.portal.struts.ActionException: com.liferay.portal.struts.ActionException: com.liferay.portal.upgrade.UpgradeException: java.sql.SQLException: Too big column length for column 'name' (max = 255). Use BLOB instead
      ..

      Manually creating tables with varchar(255) fields solves the upgrade issue ;

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package