Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-47282

Errors thrown when editing web content structures with oracle database

    Details

      Description

      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

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              juan.gonzalez Juan Gonzalez (Inactive)
              Reporter:
              bryan.engler Bryan Engler
              Participants of an Issue:
              Recent user:
              Marta Elicegui
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                6 years, 3 weeks, 6 days ago

                  Packages

                  Version Package
                  6.2.4 CE GA5
                  6.2.X EE