1. Home
  2. Portal
  3. RE: [Migration from 6.2 To 7.3]No web content template in front office

RE: [Migration from 6.2 To 7.3]No web content template in front office

Darryl Kpizingui, modified 5 Years ago.
[Migration from 6.2 To 7.3]No web content template in front office
Junior Member Posts: 82 Join Date: 1/10/13 Recent Posts
Hi all,

I am migrating a from Liferay 6.2 to 7.3. On the pages my web content are displayed [structure name, value] in a list fashion and my velocity templates are ignored. The template is well applied when I do a preview in the control panel. When I migrate to 7.2, the contents are displayed fine. But not with 7.3. Do you know if it is a  bug or some settings I need to do?

Thanks,
Darryl.
Darryl Kpizingui, modified 5 Years ago.
RE: [Migration from 6.2 To 7.3]No web content template in front office
Junior Member Posts: 82 Join Date: 1/10/13 Recent Posts
For additional info, in the table journalArticle all the ddmtemplatekey are set to null.
I do not have any error in the migration log. I looked at the source code, I can see that the columns for DDM where altered and set multiple times. Something might go wrong there.
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago.
RE: [Migration from 6.2 To 7.3]No web content template in front office
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Darryl,
Are the columns ddmtemplatekey also empty when you upgrade to 7.2?
Thanks.
Darryl Kpizingui, modified 5 Years ago.
RE: [Migration from 6.2 To 7.3]No web content template in front office
Junior Member Posts: 82 Join Date: 1/10/13 Recent Posts
Hi Alberto,

In 7.2, I just checked, the the data is well populated in ddmtemplatekey.

I found the root cause. During the upgrade process, The following warning is displayed:


WARN - Attempting to upgrade table JournalArticle by recreating the table due to: ERROR: column "ctcollectionid" does not exist
INFO - Starting com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#JournalArticle
INFO - Starting backup of JournalArticle to /tmp/temp-db-JournalArticle-2364457704951485180.tmp
INFO - Finished backup of JournalArticle to /tmp/temp-db-JournalArticle-2364457704951485180.tmp in 1400 ms
INFO - Completed com.liferay.portal.kernel.upgrade.UpgradeProcess#upgradeTable#JournalArticle in 5798 ms


This is where the ddmtemplatekey got empty when the tble is dumped on disk and then the table dropped and recreated.

I was able to solve the issue by adding the ctcollectionid before running the upgrade script.


ALTER TABLE journalarticle ADD COLUMN ctcollectionid bigint NOT NULL DEFAULT(0)


Now the web contents are well rendered.

Cheers,
Darryl.
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago.
RE: [Migration from 6.2 To 7.3]No web content template in front office
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Great! I am glad you found the fix.
Just for the record, this issue will be solved in GA3 by the following ticket:https://issues.liferay.com/browse/LPS-110703

We found several cases like this one there and we fix for all of them.
Thanks!