issue in liferay 6.1 migration

[Ilario Mazzei, geändert vor 9 Jahren.]

Hallo,
i'm migrating from liferay 6.1.1ga2 to 6.2 ga3 and i have this exception:

...
Caused by: org.postgresql.util.PSQLException: Il valore «1,0» non è adeguato al tipo «double».
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toDouble(AbstractJdbc2ResultSet.java:2843)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getDouble(AbstractJdbc2ResultSet.java:2200)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getDouble(AbstractJdbc2ResultSet.java:2421)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDouble(DelegatingResultSet.java:284)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDouble(DelegatingResultSet.java:284)
at com.liferay.portal.upgrade.v6_2_0.UpgradeSocial.updateDLFileVersionActivities(UpgradeSocial.java:163)



the problem is in UpgradeSocial.java:163
double version = rs.getDouble("version");


column "version" is defined as varchar(75) on postgresql database and i haven't found any convertion from varchar to double in sql scripts; can onyone help me?

thanks

[Jan Geißler, geändert vor 9 Jahren.]

You should do incremental updates. So updating from 6.1 GA2 to 6.2 GA3 should include the following steps:
Upgrade to 6.1 GA3,
Upgrade to 6.1 GA1
Upgrade to 6.1 GA2

Regards
Jan

[Vishal Kumar, geändert vor 9 Jahren.]

https://www.liferay.com/documentation/liferay-portal/6.2/user-guide/-/ai/upgrading-liferay-liferay-portal-6-2-user-guide-18-en

Take a look on upgrade process.