1. Home
  2. Portal
  3. RE: Upgrade Liferay CE 7.2 to 7.4.3.22

RE: Upgrade Liferay CE 7.2 to 7.4.3.22

BRODY HIGGS JR, modified 3 Years ago.
Upgrade Liferay CE 7.2 to 7.4.3.22
Junior Member Posts: 61 Join Date: 5/16/14 Recent Posts

Attempting to upgrade from Liferay CE 7.2 to 7.4.3.22, but receive following error in \tools\portal-tools-db-update\logs\upgrade.txt.  I am currently using an MSSQL2017 database.

Incorrect syntax near the keyword 'primary'.

I received the errors below before the ‘primary’ error, but removed those indexes to get past those errors.

The index 'IX_28B7204D' is dependent on column 'headId'.

The index 'IX_50C60CC0' is dependent on column 'head'.

The index 'IX_AAF037A5' is dependent on column 'head'.

thumbnail
Olaf Kock, modified 3 Years ago.
RE: Upgrade Liferay CE 7.2 to 7.4.3.22
Liferay Legend Posts: 6441 Join Date: 9/23/08 Recent Posts

Do you use an additional plugin, so that you can run 7.4 CE against MSSQL? Because out of the box that a non-supported database, and I'd recommend to go with a supported one (the open source databases)

thumbnail
Alberto Chaparro, modified 3 Years ago.
RE: Upgrade Liferay CE 7.2 to 7.4.3.22
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Brody,

I would need the whole log file to know which is the issue that is occurring but if you removed those indexes before the upgrade is fine because at the end of the upgrade we always verify the database indexes to create the missing ones.

 

Cheers!