Issue Details (XML | Word | Printable)

Key: MDL-9217
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Blocker Blocker
Assignee: Petr Skoda
Reporter: Gustav W Delius
Votes: 0
Watchers: 5
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

Upgrade from 1.6.3 to 1.8 reports missing table groups_courses_groups

Created: 05/Apr/07 03:59 PM   Updated: 08/Jan/08 07:26 AM
Return to search
Component/s: Installation
Affects Version/s: 1.8
Fix Version/s: 1.8.1

File Attachments: 1. Text File groups_upgrade.patch (10 kB)

Issue Links:
Dependency
 
Relates
 

Participants: Daniel Miksik, Eloy Lafuente (stronk7), Gustav W Delius, Martin Dougiamas, Nicolas Connault, Petr Skoda and Rahim Virani
Security Level: None
Resolved date: 29/Apr/07
Affected Branches: MOODLE_18_STABLE
Fixed Branches: MOODLE_18_STABLE


 Description  « Hide
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()

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Petr Skoda made changes - 05/Apr/07 04:27 PM
Field Original Value New Value
Priority Critical [ 2 ] Blocker [ 1 ]
Database [MySQL]
Petr Skoda made changes - 05/Apr/07 04:27 PM
Link This issue will be resolved by MDL-8251 [ MDL-8251 ]
Petr Skoda made changes - 28/Apr/07 09:09 PM
Fix Version/s 1.8.1 [ 10213 ]
Martin Dougiamas made changes - 28/Apr/07 09:13 PM
Assignee Martin Dougiamas [ dougiamas ] Nick Freear [ nfreear ]
Martin Dougiamas made changes - 28/Apr/07 09:28 PM
Assignee Nick Freear [ nfreear ] Petr ?koda [ skodak ]
Petr Skoda made changes - 29/Apr/07 05:46 AM
Attachment groups_upgrade.patch [ 11171 ]
Petr Skoda made changes - 29/Apr/07 07:47 PM
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Dan Poltawski made changes - 12/Jul/07 10:00 PM
Link This issue has been marked as being related by MDL-10433 [ MDL-10433 ]