[SOLVED] Upgrade document library from 3.6.1 to 6.0.6?

[a.schild a.schild, geändert vor 12 Jahren.]

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, geändert vor 12 Jahren.]

I suppose you followed the basic 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

jcr.jackrabbit.repository.root=${resource.repositories.root}/jackrabbit
discussion.thread.view=combination
dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
dl.hook.file.system.root.dir=${resource.repositories.root}/document_library

[a.schild a.schild, geändert vor 12 Jahren.]

Corné Aussems:

I suppose you followed the basic 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

jcr.jackrabbit.repository.root=${resource.repositories.root}/jackrabbit
discussion.thread.view=combination
dl.hook.impl=com.liferay.documentlibrary.util.JCRHook
dl.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:

dl.root.dir=/home/liferay/documentlibrary/root/
dl.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, geändert vor 12 Jahren.]

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