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

DB error when using in-page discussion creation to create a discussion with subject, and no message

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.7
    • 3.7
    • Forum
    • MOODLE_37_STABLE
    • MOODLE_37_STABLE
    • MDL-65468-master
    • Hide
      1. Log in as Admin.
      2. Create a Course.
      3. Create a Forum activity in the forum.
      4. Attempt to create a discussion from the inline discussion creation form.
        1. Enter a subject
        2. Leave the message empty
        3. Click "Post to forum"
          1. make sure you do not see any DB errors
          2. make sure you see a form warning that the Message is a required field. (NOTE: you will be redirected to the advanced discussion form)
      5. Attempt to create a discussion from the advanced discussion creation form.
        1. Enter a subject
        2. Leave the message empty
        3. Click "Post to forum"
          1. make sure you do not see any DB errors
          2. make sure you see a form warning that the Message is a required field
      Show
      Log in as Admin. Create a Course. Create a Forum activity in the forum. Attempt to create a discussion from the inline discussion creation form. Enter a subject Leave the message empty Click "Post to forum" make sure you do not see any DB errors make sure you see a form warning that the Message is a required field. (NOTE: you will be redirected to the advanced discussion form) Attempt to create a discussion from the advanced discussion creation form. Enter a subject Leave the message empty Click "Post to forum" make sure you do not see any DB errors make sure you see a form warning that the Message is a required field

      1. Given I open a forum
      2. And I click "Create a new discussion topic"
      3. And I set the "Subject" to "Example"
      4. And I do not fill the "Message" field
      5. When I click on "Post to forum"
      6. Then I should see a form warning that the Message is a required field
      7. But I see a DB error 

        Debug info: ERROR: null value in column "subject" violates not-null constraint
        		 
        DETAIL: Failing row contains (31, 0, 0, 2, 1556764614, 1556764614, 0, null, , null, 0, , 0, 0, 0, 0).
        		 
        INSERT INTO mdl_forum_posts (discussion,parent,privatereplyto,userid,created,modified,mailed,subject,message,messageformat,messagetrust,mailnow) VALUES($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12) RETURNING id
        		 
        [array (
        		 
        'discussion' => 0,
        		 
        'parent' => 0,
        		 
        'privatereplyto' => 0,
        		 
        'userid' => '2',
        		 
        'created' => 1556764614,
        		 
        'modified' => 1556764614,
        		 
        'mailed' => 0,
        		 
        'subject' => NULL,
        		 
        'message' => '',
        		 
        'messageformat' => NULL,
        		 
        'messagetrust' => 0,
        		 
        'mailnow' => 0,
        		 
        )]
        		 
        Error code: dmlwriteexception

        1. MDL-65468.jpg
          27 kB
          Anna Carissa Sadia

            Geshoski Mihail Geshoski
            dobedobedoh Andrew Lyons
            Peter Dias Peter Dias
            Jun Pataleta Jun Pataleta
            Anna Carissa Sadia Anna Carissa Sadia
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 35 minutes
                2h 35m

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.