-
Type:
Bug
-
Status: Resolved
-
Resolution: Fixed
-
Affects Version/s: 7.3.0 CE GA1
-
Fix Version/s: Master
-
Component/s: Core Infrastructure > DB Upgrade Client
-
Labels:
-
Fix Priority:4
When upgrading from 7.2 to 7.3 the following warning is encountered
Mar 20, 19:32:27.839 build-3528 [liferayupgrade-59d88f4f47-2vr5h] 2020-03-21 00:32:27.838 WARN [main][UpgradeProcess:386] Attempting to upgrade table RatingsStats by recreating the table due to: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
This upgrade step is not providing the data type of the new column to be added:
The data type should be provided like in this example:
Steps to reproduce it
- Upgrade to master with a 7.2 database
Results:
You see the following exception:
Mar 20, 19:32:27.839 build-3528 [liferayupgrade-59d88f4f47-2vr5h] 2020-03-21 00:32:27.838 WARN [main][UpgradeProcess:386] Attempting to upgrade table RatingsStats by recreating the table due to: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Expected results:
Previous exception is not thrown and the RatingsStats table has the following fields:
- createDate
- modifiedDate
- relates
-
LPS-110702 Warnings when upgrading to Liferay 7.3 from 7.2
- Verified