Liferay migration from 5.2.3 to 6.1

[Vitaliy Koshelenko，修改在11 年前。]

Hi, all.

I need to migrate the existing portal (version 5.2.3) to the 6.1 version.
Where can I find step-by-step instruction how to do it ? Which problems can occur during this migration ?

Thanks, Vitaliy

[Amit Doshi，修改在11 年前。]

Hi Vitaliy,

One of my friend has represented in Blog in a very nice way.

Step by Step all the thing is mentioned.

Please check this link.

Thanks & Regards,
Amit Doshi

[Vitaliy Koshelenko，修改在11 年前。]

Thanks for your reply, I'll check it.

[Vitaliy Koshelenko，修改在11 年前。]

Has anybody else faced with this issue?
Currently I'm trying to upgrade portal to 6.0 version... I have pointed Liferay 6.0.6 instance to MySQL database (which was used by v5.2.3), and I always get errors during UpgradeProcess at the startup like:
com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24575' for key 'PRIMARY'
(not only for this ID, if I remove it - I get the similar error for other ones). It seems, that Liferay tries to copy the entities which are already existing and save them again into DB tables (like TagsVocabulary, TagsAsset, TagsEntry etc.)
Can anybody help me with that?

Thanks,
VItaliy K.

[Vitaliy Koshelenko，修改在11 年前。]

I have checked out the source code - in the UpgradeAsset class there is code like:

			ps = con.prepareStatement("select * from TagsAsset");
			rs = ps.executeQuery();
			while (rs.next()) {
				long assetId = rs.getLong("assetId");
				long groupId = rs.getLong("groupId");
				// .. other fields
				addEntry(
					assetId, groupId, companyId, userId, userName, createDate,
					modifiedDate, classNameId, classPK, visible, startDate,
					endDate, publishDate, expirationDate, mimeType, title,
					description, summary, url, height, width, priority,
					viewCount);
			}

..so Liferay reads all the records from DB, and then tries to add each record to database again (but fails because of DuplicateKey exception).
Can anybody explain, why Liferay does this and how to suppress this functionality?

[Amit Doshi，修改在11 年前。]

Hi Vitaliy,

It is one of the basic issues.

It happens generally when you start migration the DB and it stops in between while migration and then you restart the server it will give you "com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '24575' for key 'PRIMARY'" Error.

So for that reason Until the Migration done successfully, Start with 5.2.3 DB once again with fresh copy of DB.

Hope it helps.

Thanks & Regards,
Amit Doshi

[Vitaliy Koshelenko，修改在11 年前。]

Thanks again, Amit.
I have also found related topic in Administration Guide: https://www.liferay.com/documentation/liferay-portal/6.0/administration/-/ai/upgrading-lifer-4
Regards, Vitaliy

[Jack Bakker，修改在11 年前。]

Hi Vitaliy

I think you are upgrading 5.2.3 to 6.0.6 (not 6.1 as your subject here states). Smiles.

[Amit Doshi，修改在11 年前。]

Jack Bakker:

Hi Vitaliy

I think you are upgrading 5.2.3 to 6.0.6 (not 6.1 as your subject here states). Smiles.

Jack:-

You can't directly migrate from 5.2.3 to 6.1, before that you have to migrate it to liferay 6.0 version.

Check this link for more information.

Thanks & Regards,
Amit Doshi

[Vitaliy Koshelenko，修改在11 年前。]

Hi, Jack

Yes, currently I need to upgrade to 6.0.6 version, and after successful upgrade I'll upgrade to v6.1

[archana thakur，修改在7 年前。]

Hi,

I am facing issue with theme upgrade from 6.1 EE to 6.2 EE.
After upgrade theme is not displaying anything on page and its not loading css and js file. and i am getting
[code_jsp:130] {code="404", msg="/json2.js", uri=/json2.js}

please help me to resolve this.


Regards
Archana