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

Upgrade from 1.6.3 to 1.8 reports missing table groups_courses_groups

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8.1
    • Component/s: Installation
    • Labels:
      None
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE

      Description

      While upgrading a Moodle installation from version 1.6.3 (2006050530) to 1.8 (2007021501) I repeatedly get the error message

      Table 'mathsmoodle18.mdl_groups_courses_groups' doesn't exist

      SELECT g.id, gm.userid FROM mdl_groups_members gm INNER JOIN mdl_groups g ON gm.groupid = g.id INNER JOIN mdl_groups_courses_groups cg ON g.id = cg.groupid WHERE cg.courseid = '304' AND gm.userid = '26'

      This occurs during the processing of the role assignments. Apparently the roles assignments are processed before the groups tables are updated.

      The debug output also gives something like:

      • line 677 of lib\dmllib.php: call to debugging()
      • line 918 of lib\dmllib.php: call to get_recordset_sql()
      • line 110 of group\db\dbbasicgrouplib.php: call to get_records_sql()
      • line 81 of group\lib\basicgrouplib.php: call to groups_db_get_groups_for_user()
      • line 54 of group\lib\legacylib.php: call to groups_get_groups_for_user()
      • line 2256 of lib\accesslib.php: call to get_groups()
      • line 2110 of lib\moodlelib.php: call to role_unassign()
      • line 2191 of lib\accesslib.php: call to sync_metacourse()
      • line 1498 of lib\accesslib.php: call to role_assign()
      • line 324 of admin\index.php: call to moodle_install_roles()

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  11/Jun/07