Uploaded image for project: 'Opencast'
  1. MH-13309

SQL error modifying a group in the Admin UI

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed and reviewed
    • Affects versions: 6.0
    • Fix versions: None
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Incorrectly Functioning Without Workaround
    • Steps to reproduce:
      Hide
      https://groups.google.com/a/opencast.org/forum/#!topic/users/y5l8F8ZHtJ4

      Regression from MH-13191

      Steps to reproduce:
      1. Modify group in Admin UI (may be configuration dependent)
       
       Actual Results:
       
      Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
      Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')))' at line 1
      Error Code: 1064
      Call: SELECT id, email, last_login, login_mechanism, name, username, organization FROM oc_user_ref WHERE ((organization = ?) AND (username IN ()))
      bind => [1 parameter bound]
      Query: ReadAllQuery(name="UserReference.findAllByUserNames" referenceClass=JpaUserReference sql="SELECT id, email, last_login, login_mechanism, name, username, organization FROM oc_user_ref WHERE ((organization = ?) AND (username IN ?))")
       
       Expected Results:
       
      Group should be modifiable.
       
       Workaround (if any):
       





      Show
      https://groups.google.com/a/opencast.org/forum/#!topic/users/y5l8F8ZHtJ4 Regression from MH-13191 Steps to reproduce: 1. Modify group in Admin UI (may be configuration dependent)    Actual Results:   Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')))' at line 1 Error Code: 1064 Call: SELECT id, email, last_login, login_mechanism, name, username, organization FROM oc_user_ref WHERE ((organization = ?) AND (username IN ())) bind => [1 parameter bound] Query: ReadAllQuery(name="UserReference.findAllByUserNames" referenceClass=JpaUserReference sql="SELECT id, email, last_login, login_mechanism, name, username, organization FROM oc_user_ref WHERE ((organization = ?) AND (username IN ?))")    Expected Results:   Group should be modifiable.    Workaround (if any):  

      TestRail: Results

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                coosthuizen Corné Oosthuizen
                Reporter:
                smarquard Stephen Marquard
              • Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  TestRail: Cases