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

Error enabling outcomes in one forum activity

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 1.9
    • Fix Version/s: 1.9
    • Component/s: Course, Forum, Gradebook
    • Labels:
      None
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE

      Description

      I've followed these steps:

      1) New 1.9beta3 site installed.
      2) Enable outcomes globally
      3) Create two outcomes
      4) Create new course
      5) Enable the outcomes in the course
      6) In the default "News" forum, edit the module and select the two outcomes. Press Save. And then:

      in moodle_19/course/modedit.php:

      Notice: Undefined variable: exists in /Users/stronk7/cvs_moodle/moodle_19_stable/course/modedit.php on line 341

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND courseid = 2' at line 3

      UPDATE mdl_grade_items SET sortorder = sortorder + 1 WHERE sortorder > AND courseid = 2

      • line 103 of lib/dmllib.php: call to debugging()
      • line 1134 of lib/grade/grade_item.php: call to execute_sql()
      • line 398 of course/modedit.php: call to grade_item->move_after_sortorder()

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND courseid = 2' at line 3

      UPDATE mdl_grade_items SET sortorder = sortorder + 1 WHERE sortorder > AND courseid = 2

      • line 103 of lib/dmllib.php: call to debugging()
      • line 1134 of lib/grade/grade_item.php: call to execute_sql()
      • line 398 of course/modedit.php: call to grade_item->move_after_sortorder()

      (see the missing value after "sortorder >")

      Ciao

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              stronk7 Eloy Lafuente (stronk7)
              Tester:
              Nobody Nobody
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Ilya Tregubov, Sara Arjona (@sarjona), Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Sujith Haridasan
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                3/Mar/08