Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
André Schild
[SOLVED] Upgrade document library from 3.6.1 to 6.0.6?
December 14, 2011 5:38 AM
Answer

André Schild

Rank: New Member

Posts: 5

Join Date: June 12, 2006

Recent Posts

Hello,

since a few days we are in the progress of upgrading a old client installation from 3.6.1 to 6.0.6.

So far everything is upgraded correctly, users, forums etc.

But one thing is missing: The document library (and with this also the file attachments of the forum)

In the 3.6.1 everything was stored under C:\liferay\documentlibrary in subfolders like: root/<userid> or vroot/<userid>

What is the best approach to also have the files migrated correctly up to 6.0.6 ?
In all the upgrade steps we don't see errors related to the files, but apparently we miss one upgrade step.

André
Corné Aussems
RE: Upgrade document library from 3.6.1 to 6.0.6?
December 13, 2011 12:29 PM
Answer

Corné Aussems

Rank: Liferay Legend

Posts: 1253

Join Date: October 3, 2006

Recent Posts

I suppose you followed the basic[url=http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Upgrade+Instructions+(disambiguation)] upgrade instructions
and did it step by step.

Or did you upgrade directly from 3 to 6 ?

Did you set the right legacy properties?

portal-legacy-5.1.properties
1
2jcr.jackrabbit.repository.root=${resource.repositories.root}/jackrabbit
3discussion.thread.view=combination
4dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
5dl.hook.file.system.root.dir=${resource.repositories.root}/document_library
André Schild
RE: Upgrade document library from 3.6.1 to 6.0.6?
December 13, 2011 11:17 PM
Answer

André Schild

Rank: New Member

Posts: 5

Join Date: June 12, 2006

Recent Posts

Corné Aussems:
I suppose you followed the basic[url=http://www.liferay.com/web/guest/community/wiki/-/wiki/Main/Upgrade+Instructions+(disambiguation)] upgrade instructions
and did it step by step.

Or did you upgrade directly from 3 to 6 ?

Yes, I did it step by step.
Between 4.2.2 and 4.3.6 I also had to run a sql script to modify some
forum subject lenghts (Was 100 char length in 4.2.2 and previous and has been reduced to 75 chars)
Also some deleted users/groups had to fixed in some tables.

Corné Aussems:

Did you set the right legacy properties?

portal-legacy-5.1.properties
1
2jcr.jackrabbit.repository.root=${resource.repositories.root}/jackrabbit
3discussion.thread.view=combination
4dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
5dl.hook.file.system.root.dir=${resource.repositories.root}/document_library

Yes, but that did not help, but it directed me in the correct direction.
In the 4.2.2 upgrade I had to set these two properties:

1
2dl.root.dir=/home/liferay/documentlibrary/root/
3dl.version.root.dir=/home/liferay/documentlibrary/vroot/


Now it's doing a upgrade of the document library and complains over the files with [ and/or ] in the filename.
So I'm now cleaning up these.

I will post back if there are other issues.

Thanks for your help.
André Schild
[SOLVED]RE: Upgrade document library from 3.6.1 to 6.0.6?
December 14, 2011 5:38 AM
Answer

André Schild

Rank: New Member

Posts: 5

Join Date: June 12, 2006

Recent Posts

Now I finaly got everything upgraded.

Here a short how-to-upgrade from 3.6.1 to 6.0.6

Upgrade from 3.6.1 to 4.2.2
- Modify the update-3.6.0-4.0.0-sql-server.sql script to set the correct default group ID
alter table WikiNode add groupId varchar(75) not null default '2';
- Run the update-3.6.0-4.0.0-sql-server.sql script to upgrade the DB
- Run the update-4.0.0-4.1.0-sql-server.sql script
- Run the update-4.1.0-4.2.0-sql-server.sql script
- Install liferay 4.2.2
- Use these portal-ext.properties settings:
liferay.home=C:/Data/Liferay.422/
company.security.auth.type=userId
company.default.web.id=liferay.com
company.security.auth.type=screenName
dl.root.dir=${liferay.home}/documentlibrary/root/
dl.version.root.dir=${liferay.home}/documentlibrary/vroot/
lucene.dir=${liferay.home}/data/lucene/
auto.deploy.deploy.dir=${liferay.home}/data/deploy/
jcr.jackrabbit.repository.root=${liferay.home}/data/jackrabbit/
- Start liferay

Look for errors in the log files
Upgrade from 4.2.2 to 4.3.6
- Look for missing users/groups and truncate too long subjects in the forums
update mbmessage set subject= left(subject, 74) where len(subject) > 75;
update journalarticle set userid='<somedefaultuser>' where userid='<no longer existing>;
update journalarticle set userid='<somedefaultuser>' where userid='<no longer existing2>';
- Install liferay 4.3.6
- Use these same portal-ext.properties settings as mentioned above
- Start liferay

Upgrade from 4.3.6 to 4.4.2
- Use these same portal-ext.properties settings as mentioned above
- Install liferay 4.4.2
- Start liferay

Upgrade from 4.4.2 to 5.0.1
- Install liferay 5.0.1
- Use these portal-ext.properties
jcr.initialize.on.startup=false
jcr.workspace.name=liferay
jcr.node.documentlibrary=documentlibrary
jcr.jackrabbit.repository.root=${liferay.home}/data/jackrabbit
jcr.jackrabbit.config.file.path=${jcr.jackrabbit.repository.root}/repository.xml
jcr.jackrabbit.repository.home=${jcr.jackrabbit.repository.root}/home
jcr.jackrabbit.credentials.username=none
jcr.jackrabbit.credentials.password=none
dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
- Start liferay

Upgrade from 5.0.1 to 5.1.2
- Install liferay 5.1.2
- Use these portal-ext.properties
jcr.initialize.on.startup=false
jcr.workspace.name=liferay
jcr.node.documentlibrary=documentlibrary
jcr.jackrabbit.repository.root=${liferay.home}/data/jackrabbit
jcr.jackrabbit.config.file.path=${jcr.jackrabbit.repository.root}/repository.xml
jcr.jackrabbit.repository.home=${jcr.jackrabbit.repository.root}/home
jcr.jackrabbit.credentials.username=none
jcr.jackrabbit.credentials.password=none
dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
- Start liferay

Upgrade from 5.1.2 to 5.2.3
- Install liferay 5.2.3
- Use these portal-ext.properties
liferay.home=c:/Data/Liferay.523/
resource.repositories.root=c:/Data/Liferay.523/data
jcr.initialize.on.startup=false
jcr.workspace.name=liferay
jcr.node.documentlibrary=documentlibrary
jcr.jackrabbit.repository.root=${liferay.home}/data/jackrabbit
jcr.jackrabbit.config.file.path=${jcr.jackrabbit.repository.root}/repository.xml
jcr.jackrabbit.repository.home=${jcr.jackrabbit.repository.root}/home
jcr.jackrabbit.credentials.username=none
jcr.jackrabbit.credentials.password=none
dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
dl.hook.file.system.root.dir=${resource.repositories.root}/document_library
- Make sure your OS settings are set to locale en_US, otherwise the version numbers of the document library will corrupt
You can also start java with these settings: -Duser.language=en -Duser.region=US

- Start liferay

Upgrade from 5.2.3 to 6.0.6
- Install liferay 6.0.6
- Use these portal-ext.propertiesas above
- Make sure your OS settings are set to locale en_US, otherwise the version numbers of the document library will corrupt
You can also start java with these settings: -Duser.language=en -Duser.region=US

- Start liferay