Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-67966

mod_workshop: Error writing to database when adding example submission

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.7.4, 3.9.10, 3.10.7, 3.11.3, 3.11.7, 4.0.1
    • 3.11.8, 4.0.2
    • Workshop
    • MOODLE_310_STABLE, MOODLE_311_STABLE, MOODLE_37_STABLE, MOODLE_39_STABLE, MOODLE_400_STABLE
    • MOODLE_311_STABLE, MOODLE_400_STABLE
    • MDL-67966-311
    • MDL-67966-400
    • MDL-67966-master
    • Hide
      1. Create a course.
      2. Turn editing on.
      3. Add a Workshop activity.
        • name: Workshop activity
        • description: Testing
        • Submission settings: Instructions for submission: Submit testing....
        • Submission settings: Submission type: (only) File attachment
        • Example submissions: Use examples: ticked/enable.
      4. Save the Workshop settings and view the activity.
      5. Click the "Setup phase" / Edit assessment form" link.
        • Aspect 1: Description: Test123.
      6. Click "Save and preview".
      7. For Aspect 1: Test 123
        • Grade for Aspect 1: 10 / 10
        • Comment for Aspect 1: Testing comments.
      8. Click "Back to editing form".
      9. Click "Save and close".
      10. Visit back the Workshop activity and ensure that the Setup phase has green tick for the following:
        • Set the workshop description
        • Provide instructions for submission
        • Edit assessment form
      11. Click the "Add example submission" button to add a submission.
        • Title: s1.
        • Attachment: upload any file
      12. Click "Save changes".
      13. Confirm that you don't get any errors
      Show
      Create a course. Turn editing on. Add a Workshop activity. name: Workshop activity description: Testing Submission settings: Instructions for submission: Submit testing.... Submission settings: Submission type: (only) File attachment Example submissions: Use examples: ticked/enable. Save the Workshop settings and view the activity. Click the "Setup phase" / Edit assessment form" link. Aspect 1: Description: Test123. Click "Save and preview". For Aspect 1: Test 123 Grade for Aspect 1: 10 / 10 Comment for Aspect 1: Testing comments. Click "Back to editing form". Click "Save and close". Visit back the Workshop activity and ensure that the Setup phase has green tick for the following: Set the workshop description Provide instructions for submission Edit assessment form Click the "Add example submission" button to add a submission. Title: s1. Attachment: upload any file Click "Save changes". Confirm that you don't get any errors

    Description

      The Error writing to database is displayed when adding an example submission for the mod_workshop activity.

      1. Create a course.
      2. Turn editing on.
      3. Add a Workshop activity.
        • name: Workshop activity
        • description: Testing
        • Submission settings: Instructions for submission: Submit testing....
        • Submission settings: Submission type: (only) File attachment
        • Example submissions: Use examples: ticked/enable.
      4. Save the Workshop settings and view the activity.
      5. Click the "Setup phase" / Edit assessment form" link.
        • Aspect 1: Description: Test123.
      6. Click "Save and preview".
      7. For Aspect 1: Test 123
        • Grade for Aspect 1: 10 / 10
        • Comment for Aspect 1: Testing comments.
      8. Click "Back to editing form".
      9. Click "Save and close".
      10. Visit back the Workshop activity and ensure that the Setup phase has green tick for the following:
      • Set the workshop description
      • Provide instructions for submission
      • Edit assessment form
      1. Click the "Add example submission" button to add a submission.
        • Title: s1.
        • Attachment: upload any file
      2. Click "Save changes".

      Result:
      Error message displayed is displayed. Please refer to the attachments.

      This happens because there is no content_editor when "online text" is not enabled/allowed as a submission type.

      Attachments

        1. MDL-67966_Screenshot1.PNG
          44 kB
          Gladys Basiana
        2. MDL-67966_Screenshot2.PNG
          48 kB
          Gladys Basiana
        3. Screen Shot 2020-02-14 at 3.32.35 pm.png
          153 kB
          Joshua Ebarvia

        Activity

          People

            jebarvia Joshua Ebarvia
            jebarvia Joshua Ebarvia
            Ilya Tregubov Ilya Tregubov
            Jun Pataleta Jun Pataleta
            Gladys Basiana Gladys Basiana
            Amaia Anabitarte, Bas Brands, Carlos Escobedo, Laurent David, Sabina Abellan, Sara Arjona (@sarjona)
            Votes:
            3 Vote for this issue
            Watchers:
            12 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              11/Jul/22

              Time Tracking

                Estimated:
                Original Estimate - 0 minutes
                0m
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 16 minutes
                1h 16m