Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-33893 Test and Fix MySQL conversion script for Sakai 12
  3. SAK-33894

Add missing columns and tables to MySQL conversion script

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: RESOLVED
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 12.0, 19.0
    • Component/s: None
    • Labels:
      None
    • Test Plan:
      Hide

      Please add a Test Plan here.

      Show
      Please add a Test Plan here.

      Description

      At first pass here's the missing columns and tables.

      Missing Column(s): 
           sakai_12.ASN_ASSIGNMENT.ACCESS_TYPE
           sakai_12.ASN_ASSIGNMENT.ALLOW_ATTACHMENTS
           sakai_12.ASN_ASSIGNMENT.ALLOW_PEER_ASSESSMENT
           sakai_12.ASN_ASSIGNMENT.ASSIGNMENT_ID
           sakai_12.ASN_ASSIGNMENT_ATTACHMENTS.ASSIGNMENT_ID
           sakai_12.ASN_ASSIGNMENT_ATTACHMENTS.ATTACHMENT
           sakai_12.ASN_ASSIGNMENT.AUTHOR
           sakai_12.ASN_ASSIGNMENT.CLOSE_DATE
           sakai_12.ASN_ASSIGNMENT.CONTENT_REVIEW
           sakai_12.ASN_ASSIGNMENT.CONTEXT
           sakai_12.ASN_ASSIGNMENT.CREATED_DATE
           sakai_12.ASN_ASSIGNMENT.DELETED
           sakai_12.ASN_ASSIGNMENT.DRAFT
           sakai_12.ASN_ASSIGNMENT.DROP_DEAD_DATE
           sakai_12.ASN_ASSIGNMENT.DUE_DATE
           sakai_12.ASN_ASSIGNMENT.GRADE_TYPE
           sakai_12.ASN_ASSIGNMENT_GROUPS.ASSIGNMENT_ID
           sakai_12.ASN_ASSIGNMENT_GROUPS.GROUP_ID
           sakai_12.ASN_ASSIGNMENT.HIDE_DUE_DATE
           sakai_12.ASN_ASSIGNMENT.HONOR_PLEDGE
           sakai_12.ASN_ASSIGNMENT.INDIVIDUALLY_GRADED
           sakai_12.ASN_ASSIGNMENT.INSTRUCTIONS
           sakai_12.ASN_ASSIGNMENT.IS_GROUP
           sakai_12.ASN_ASSIGNMENT.MAX_GRADE_POINT
           sakai_12.ASN_ASSIGNMENT.MODIFIED_DATE
           sakai_12.ASN_ASSIGNMENT.MODIFIER
           sakai_12.ASN_ASSIGNMENT.OPEN_DATE
           sakai_12.ASN_ASSIGNMENT.PEER_ASSESSMENT_ANON_EVAL
           sakai_12.ASN_ASSIGNMENT.PEER_ASSESSMENT_INSTRUCTIONS
           sakai_12.ASN_ASSIGNMENT.PEER_ASSESSMENT_NUMBER_REVIEW
           sakai_12.ASN_ASSIGNMENT.PEER_ASSESSMENT_PERIOD_DATE
           sakai_12.ASN_ASSIGNMENT.PEER_ASSESSMENT_STUDENT_REVIEW
           sakai_12.ASN_ASSIGNMENT.POSITION
           sakai_12.ASN_ASSIGNMENT_PROPERTIES.ASSIGNMENT_ID
           sakai_12.ASN_ASSIGNMENT_PROPERTIES.NAME
           sakai_12.ASN_ASSIGNMENT_PROPERTIES.VALUE
           sakai_12.ASN_ASSIGNMENT.RELEASE_GRADES
           sakai_12.ASN_ASSIGNMENT.SCALE_FACTOR
           sakai_12.ASN_ASSIGNMENT.SECTION
           sakai_12.ASN_ASSIGNMENT.SUBMISSION_TYPE
           sakai_12.ASN_ASSIGNMENT.TITLE
           sakai_12.ASN_ASSIGNMENT.VISIBLE_DATE
           sakai_12.ASN_SUBMISSION.ASSIGNMENT_ID
           sakai_12.ASN_SUBMISSION_ATTACHMENTS.ATTACHMENT
           sakai_12.ASN_SUBMISSION_ATTACHMENTS.SUBMISSION_ID
           sakai_12.ASN_SUBMISSION.CREATED_DATE
           sakai_12.ASN_SUBMISSION.FACTOR
           sakai_12.ASN_SUBMISSION_FEEDBACK_ATTACH.FEEDBACK_ATTACHMENT
           sakai_12.ASN_SUBMISSION_FEEDBACK_ATTACH.SUBMISSION_ID
           sakai_12.ASN_SUBMISSION.FEEDBACK_COMMENT
           sakai_12.ASN_SUBMISSION.FEEDBACK_TEXT
           sakai_12.ASN_SUBMISSION.GRADE
           sakai_12.ASN_SUBMISSION.GRADED
           sakai_12.ASN_SUBMISSION.GRADED_BY
           sakai_12.ASN_SUBMISSION.GRADE_RELEASED
           sakai_12.ASN_SUBMISSION.GROUP_ID
           sakai_12.ASN_SUBMISSION.HIDDEN_DUE_DATE
           sakai_12.ASN_SUBMISSION.HONOR_PLEDGE
           sakai_12.ASN_SUBMISSION.MODIFIED_DATE
           sakai_12.ASN_SUBMISSION_PROPERTIES.NAME
           sakai_12.ASN_SUBMISSION_PROPERTIES.SUBMISSION_ID
           sakai_12.ASN_SUBMISSION_PROPERTIES.VALUE
           sakai_12.ASN_SUBMISSION.RETURNED
           sakai_12.ASN_SUBMISSION.RETURNED_DATE
           sakai_12.ASN_SUBMISSION.SUBMISSION_ID
           sakai_12.ASN_SUBMISSION.SUBMITTED
           sakai_12.ASN_SUBMISSION.SUBMITTED_DATE
           sakai_12.ASN_SUBMISSION_SUBMITTER.FEEDBACK
           sakai_12.ASN_SUBMISSION_SUBMITTER.GRADE
           sakai_12.ASN_SUBMISSION_SUBMITTER.ID
           sakai_12.ASN_SUBMISSION_SUBMITTER.SUBMISSION_ID
           sakai_12.ASN_SUBMISSION_SUBMITTER.SUBMITTEE
           sakai_12.ASN_SUBMISSION_SUBMITTER.SUBMITTER
           sakai_12.ASN_SUBMISSION.TEXT
           sakai_12.ASN_SUBMISSION.USER_SUBMISSION
           sakai_12.COMMONS_COMMENT.CONTENT
           sakai_12.COMMONS_COMMENT.CREATED_DATE
           sakai_12.COMMONS_COMMENT.CREATOR_ID
           sakai_12.COMMONS_COMMENT.ID
           sakai_12.COMMONS_COMMENT.MODIFIED_DATE
           sakai_12.COMMONS_COMMENT.POST_ID
           sakai_12.COMMONS_COMMONS.EMBEDDER
           sakai_12.COMMONS_COMMONS.ID
           sakai_12.COMMONS_COMMONS_POST.COMMONS_ID
           sakai_12.COMMONS_COMMONS_POST.POST_ID
           sakai_12.COMMONS_COMMONS.SITE_ID
           sakai_12.COMMONS_POST.CONTENT
           sakai_12.COMMONS_POST.CREATED_DATE
           sakai_12.COMMONS_POST.CREATOR_ID
           sakai_12.COMMONS_POST.ID
           sakai_12.COMMONS_POST.MODIFIED_DATE
           sakai_12.COMMONS_POST.RELEASE_DATE
           sakai_12.CONTENTREVIEW_ITEM.contentId
           sakai_12.CONTENTREVIEW_ITEM.dateQueued
           sakai_12.CONTENTREVIEW_ITEM.dateReportReceived
           sakai_12.CONTENTREVIEW_ITEM.dateSubmitted
           sakai_12.CONTENTREVIEW_ITEM.errorCode
           sakai_12.CONTENTREVIEW_ITEM.externalId
           sakai_12.CONTENTREVIEW_ITEM.id
           sakai_12.CONTENTREVIEW_ITEM.lastError
           sakai_12.CONTENTREVIEW_ITEM.nextRetryTime
           sakai_12.CONTENTREVIEW_ITEM_PROPERTIES.CONTENTREVIEW_ITEM_ID
           sakai_12.CONTENTREVIEW_ITEM_PROPERTIES.PROPERTY
           sakai_12.CONTENTREVIEW_ITEM_PROPERTIES.VALUE
           sakai_12.CONTENTREVIEW_ITEM.providerId
           sakai_12.CONTENTREVIEW_ITEM.retryCount
           sakai_12.CONTENTREVIEW_ITEM.reviewScore
           sakai_12.CONTENTREVIEW_ITEM.siteId
           sakai_12.CONTENTREVIEW_ITEM.status
           sakai_12.CONTENTREVIEW_ITEM.taskId
           sakai_12.CONTENTREVIEW_ITEM.userId
           sakai_12.CONTENTREVIEW_ITEM.version
           sakai_12.context_mapping.componentId
           sakai_12.context_mapping.contextId
           sakai_12.context_mapping.uuid
           sakai_12.lti_tools.siteinfoconfig
           sakai_12.SAM_EXTENDEDTIME_T.ASSESSMENT_ID
           sakai_12.SAM_EXTENDEDTIME_T.DUE_DATE
           sakai_12.SAM_EXTENDEDTIME_T.GROUP_ID
           sakai_12.SAM_EXTENDEDTIME_T.ID
           sakai_12.SAM_EXTENDEDTIME_T.PUB_ASSESSMENT_ID
           sakai_12.SAM_EXTENDEDTIME_T.RETRACT_DATE
           sakai_12.SAM_EXTENDEDTIME_T.START_DATE
           sakai_12.SAM_EXTENDEDTIME_T.TIME_HOURS
           sakai_12.SAM_EXTENDEDTIME_T.TIME_MINUTES
           sakai_12.SAM_EXTENDEDTIME_T.USER_ID
           sakai_12.SAM_ITEMTAG_T.ITEMID
           sakai_12.SAM_ITEMTAG_T.ITEMTAGID
           sakai_12.SAM_ITEMTAG_T.TAGCOLLECTIONID
           sakai_12.SAM_ITEMTAG_T.TAGCOLLECTIONNAME
           sakai_12.SAM_ITEMTAG_T.TAGID
           sakai_12.SAM_ITEMTAG_T.TAGLABEL
           sakai_12.SAM_ITEM_T.HASH
           sakai_12.SAM_PUBLISHEDITEMTAG_T.ITEMID
           sakai_12.SAM_PUBLISHEDITEMTAG_T.ITEMTAGID
           sakai_12.SAM_PUBLISHEDITEMTAG_T.TAGCOLLECTIONID
           sakai_12.SAM_PUBLISHEDITEMTAG_T.TAGCOLLECTIONNAME
           sakai_12.SAM_PUBLISHEDITEMTAG_T.TAGID
           sakai_12.SAM_PUBLISHEDITEMTAG_T.TAGLABEL
           sakai_12.SAM_PUBLISHEDITEM_T.HASH
           sakai_12.SAM_PUBLISHEDITEM_T.ITEMHASH
      
      

      There were also these errors running it

      ERROR 1146 (42S02) at line 70: Table 'sakai_11.sakai_user_id_map' doesn't exist
      ERROR 1146 (42S02) at line 71: Table 'sakai_11.sakai_user_id_map' doesn't exist
      ERROR 1146 (42S02) at line 72: Table 'sakai_11.sakai_user_id_map' doesn't exist
      ERROR 1091 (42000) at line 326: Can't DROP 'enabled_capability'; check that column/key exists
      ERROR 1091 (42000) at line 327: Can't DROP 'allowlori'; check that column/key exists
      ERROR 1091 (42000) at line 328: Can't DROP 'allowlori'; check that column/key exists
      ERROR 1051 (42S02) at line 329: Unknown table 'sakai_11.lti_mapping'
      

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jonespm Matthew Jones
                Reporter:
                jonespm Matthew Jones
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code