1. Home
  2. Portal
  3. RE: Unable to delete user in Liferay 7.3.2

RE: Unable to delete user in Liferay 7.3.2

thumbnail
Mikael Andersson, modified 5 Years ago.
Unable to delete user in Liferay 7.3.2
New Member Posts: 12 Join Date: 2/1/20 Recent Posts
Sorry if this has been already discussed here.
There is a ticked https://issues.liferay.com/browse/LPS-112711 "Fail to delete organization after upgrade".
Deletion fails because upgrade from a previous release does not add lastPublishDate column into DDMDataProviderInstance.

According to my tests this affects also deleting a user at least via LiferayUtil.deleteUser(). Delete will fail. According to github this has been fixed and hopefully the fix is included in 7.3.3.
Do you know, is it safe to add column DDMDataProviderInstance.lastPublishDate by hand to Liferay 7.3.2?
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago.
RE: Unable to delete user in Liferay 7.3.2
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Mikael,
It is never recommended to modify the database manually. If you can't upgrade to 7.3.3 please, be sure you execute a process like the official one:
https://github.com/liferay/liferay-portal/blob/master/modules/apps/dynamic-data-mapping/dynamic-data-mapping-service/src/main/java/com/liferay/dynamic/data/mapping/internal/upgrade/v3_7_0/UpgradeDDMDataProviderInstance.java#L26
https://github.com/liferay/liferay-portal/blob/master/portal-kernel/src/com/liferay/portal/kernel/upgrade/BaseUpgradeLastPublishDate.java#L143

The good part is that, when you upgrade to 7.3.3 in the future the upgrade process won't be executed again since we verify first if the field exists:https://github.com/liferay/liferay-portal/blob/master/modules/apps/dynamic-data-mapping/dynamic-data-mapping-service/src/main/java/com/liferay/dynamic/data/mapping/internal/upgrade/v3_7_0/UpgradeDDMDataProviderInstance.java#L27

I hope it helps.
thumbnail
Mikael Andersson, modified 5 Years ago.
RE: Unable to delete user in Liferay 7.3.2
New Member Posts: 12 Join Date: 2/1/20 Recent Posts
Hi Alberto,
I decided to wait for 7.3.3 and as expected the migration routines from 7.3.2 to 7.3.3 added the missing column to DDMDataProviderInstance.
Delete user works properly after upgrade to 7.3.3.
thumbnail
Alberto Chaparro Terleira, modified 5 Years ago.
RE: Unable to delete user in Liferay 7.3.2
Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Glad to hear that Mikael!


​​​​​​​Thanks for the update :-)