-
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
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 ;