001 Scenario: Manual grading settings are remembered as user preferences # /var/www/html/mod/quiz/report/grading/tests/behat/grading.feature:80

      And I press "Change options"                                       # /var/www/html/mod/quiz/report/grading/tests/behat/grading.feature:90

        Moodle exception: Error reading from databaseMore information about this error

        Error reading from database

        More information about this error

        ×

        Debug info: 

         ORA-00979: not a GROUP BY expression

        SELECT

            qa.questionusageid,

            1

        FROM b1quiz_attempts quiza  

                        JOIN b1question_attempts qa ON qa.questionusageid = quiza.uniqueid

        JOIN b1question_attempt_steps qas ON qas.questionattemptid = qa.id

                AND qas.sequencenumber = (

                        SELECT MAX(sequencenumber)

                        FROM b1question_attempt_steps

                        WHERE questionattemptid = qa.id

                    )

        JOIN b1question q ON q.id = qa.questionid

        WHERE

            quiza.quiz = :o_mangrquizid AND

                        quiza.preview = 0 AND

                        quiza.state = :o_statefinished AND

            qa.slot = :o_slot

             AND qa.questionid = :o_questionid AND qas.state IN (:o_summarystates25,:o_summarystates26,:o_summarystates27,:o_summarystates28,:o_summarystates29)

        ORDER BY (

                            SELECT MAX(sortqas.timecreated)

                            FROM b1question_attempt_steps sortqas

                            WHERE sortqas.questionattemptid = qa.id

                                AND sortqas.state NOT IN (:o_mangrstate20,:o_mangrstate21,:o_mangrstate22,:o_mangrstate23,:o_mangrstate24)

                            )

        [array (

          'o_mangrquizid' => '1',

          'o_statefinished' => 'finished',

          'o_slot' => 1,

          'o_questionid' => 1,

          'o_summarystates25' => 'finished',

          'o_summarystates26' => 'gaveup',

          'o_summarystates27' => 'gradedwrong',

          'o_summarystates28' => 'gradedpartial',

          'o_summarystates29' => 'gradedright',

          'o_mangrstate20' => 'manfinished',

          'o_mangrstate21' => 'mangaveup',

          'o_mangrstate22' => 'mangrwrong',

          'o_mangrstate23' => 'mangrpartial',

          'o_mangrstate24' => 'mangrright',

        )]

        Error code: dmlreadexception

         (Exception)