Liferay 6.2 bug in showing blank page to Organization Administrators

[Abdollah Esmaeilpour, modifié il y a 9 années.]

In liferay 6.2, I set a user as an Organization Administrator and he cannot see Control Panel at all. I used the workaround mentioned in LPS-43616 but now the problem is that organization admin can see other organizations' users. Can anyone suggest a solution?
Indeed, I have a web application based on liferay 5.2.2 and want to upgrade to 6.2 mostly because I want to be able to use new plugins written in liferay 6. I wonder if liferay 6.1 or 6.0 suffers from this bug or not. If not, I'am afraid most of off-the-shelf plugins aren't compatible with 6.1 or 6.0.

[Abdollah Esmaeilpour, modifié il y a 7 années.]

I fixed this Liferay bug by writing an ext plugin. It is attached.
If you are upgrading to Liferay 6.2 from a lower version, you must run following query in your DB:

SELECT u.userId INTO #temp FROM User_ u JOIN Users_Roles ur ON u.userId = ur.userId
GROUP BY u.userId HAVING SUM(ur.roleId) = 10138
INSERT INTO Users_Roles(userId, roleId) SELECT userid, 10139 FROM #temp
DROP TABLE #temp