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

REST: Annotation annotations.json doesn't work as expected

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed and reviewed
    • Affects versions: 1.4.0
    • Fix versions: 1.4.0
    • Components: Backend Software
    • Labels:
      None
    • Severity:
      Incorrectly Functioning Without Workaround
    • Steps to reproduce:
      Hide
      Steps to reproduce:
      1. Open http://testallinone.usask.ca:8080/docs.html?path=/annotation
      2. Enter in values 2, test, 99991122, 2, 2 for the GET /annotations.json call
      3. Error:
       
      Status: 500 (org.apache.cxf.interceptor.Fault: Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'matterhorn.annotation' doesn't exist Error Code: 1146 Call: SELECT COUNT(id) FROM annotation WHERE (((mediapackage_id = ?) AND (annotation_type = ?)) AND (user_id = ?)) bind => [2, test, admin] Query: ReportQuery(name="findTotalByTypeAndMediapackageId" referenceClass=AnnotationImpl sql="SELECT COUNT(id) FROM annotation WHERE (((mediapackage_id = ?) AND (annotation_type = ?)) AND (user_id = ?))"))
      Show
      Steps to reproduce: 1. Open http://testallinone.usask.ca:8080/docs.html?path=/annotation 2. Enter in values 2, test, 99991122, 2, 2 for the GET /annotations.json call 3. Error:   Status: 500 (org.apache.cxf.interceptor.Fault: Internal Exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'matterhorn.annotation' doesn't exist Error Code: 1146 Call: SELECT COUNT(id) FROM annotation WHERE (((mediapackage_id = ?) AND (annotation_type = ?)) AND (user_id = ?)) bind => [2, test, admin] Query: ReportQuery(name="findTotalByTypeAndMediapackageId" referenceClass=AnnotationImpl sql="SELECT COUNT(id) FROM annotation WHERE (((mediapackage_id = ?) AND (annotation_type = ?)) AND (user_id = ?))"))
    • Tags (folksonomy):

      TestRail: Results

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                mabel Martin Abel
                Reporter:
                cab938 Christopher Brooks
              • Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  TestRail: Cases