Errors thrown when editing web content structures with oracle database

• Type: Regression Bug
• Status: Closed
• Resolution: Duplicate
• Affects Version/s: 6.2.X EE, 7.0.0 M3
• Fix Version/s: 6.2.4 CE GA5, 6.2.X EE
• Component/s: Web Content > Web Content Administration
• Labels:
  • ee-ts
  • liferay-fixpack-portal-75-6210
• Fix Priority: 2
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/20091

STEPS TO REPRODUCE
1. Login as a portal administrator
2. Navigate to Define Permissions for a Regular role you have created
3. Select Control Panel > Sites > Sites
4. Under "Resource Permissions / Site", give the "Go to Site Administration" permission
5. Save changes
6. Select Site Administration > Content > Web Content
7. Under "General Permissions", give the "Access in Site Administration" permission
8. Under "Web Content", give the "Add Structure", "Add Template", and "Add Web Content" permissions
9. Save changes
10. Create a user
11. Assign the Regular role from step 2 to the user
12. Sign in as the user
13. Under Admin, choose the Content option
14. Under the Manage menu, choose Structures
15. Add a new structure (does not matter what is in it)

EXPECTED RESULTS
New structure would be created

ACTUAL RESULTS
Exception is thrown:
java.sql.SQLException: ORA-00979: not a GROUP BY expression_ [Sanitized]

Reproduced on master - 78351a4