Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-7803

"grouping" problem in block checklist --> errormessage "error reading database"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 3.5.7
    • Fix Version/s: None
    • Component/s: Package: Checklist
    • Labels:
      None
    • Plugin Version:
      2018040200
    • Affected Branches:
      MOODLE_35_STABLE

      Description

      When I try to open a course there is an error message:

       
      Debug info: Unknown column 'grouping' in 'field list'
      SELECT id, checklist, grouping FROM mdl_checklist_item WHERE checklist IN (?,?,?,?) AND userid = 0 AND itemoptional = 0 AND hidden = 0 ORDER BY checklist
      [array (
      0 => 34,
      1 => 35,
      2 => 36,
      3 => 37,
      )]
      Error code: dmlreadexception
      Stack trace: * line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown

      • line 1245 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      • line 1400 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
      • line 242 of /blocks/checklist/block_checklist.php: call to moodle_database->get_records_select()
      • line 209 of /blocks/checklist/block_checklist.php: call to block_checklist->get_user_progress()
      • line 98 of /blocks/checklist/block_checklist.php: call to block_checklist->show_checklist_overview()
      • line 709 of /blocks/moodleblock.class.php: call to block_checklist->get_content()
      • line 230 of /blocks/moodleblock.class.php: call to block_list->formatted_contents()
      • line 1216 of /lib/blocklib.php: call to block_base->get_content_for_output()
      • line 1268 of /lib/blocklib.php: call to block_manager->create_block_contents()
      • line 374 of /lib/blocklib.php: call to block_manager->ensure_content_created()
      • line 3950 of /lib/outputrenderers.php: call to block_manager->region_has_content()
      • line 34 of /theme/studiumdigitale/layout/columns2.php: call to core_renderer->blocks()
      • line 1287 of /lib/outputrenderers.php: call to include()
      • line 1217 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
      • line 244 of /course/view.php: call to core_renderer->header()
         

      I deactivate the block in order to backup and restore the course without the block. that works but there seems to be a problem with the grouping-column.

       

        Attachments

          Activity

            People

            Assignee:
            davosmith Davo Smith
            Reporter:
            moodleaccount A. Schenkel
            Participants:
            Component watchers:
            Davo Smith
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: