Issue Details (XML | Word | Printable)

Key: MDL-15984
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Eloy Lafuente (stronk7)
Reporter: Chris Bandy
Votes: 0
Watchers: 0
Operations

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

Inconsistent schema when upgrading

Created: 09/Aug/08 05:04 AM   Updated: 05/Nov/08 06:28 AM
Return to search
Component/s: Database SQL/XMLDB, Groups
Affects Version/s: 1.8.5, 1.9.3
Fix Version/s: None

Environment: PostgreSQL 8.1.11

Database: PostgreSQL
Participants: Chris Bandy and Eloy Lafuente (stronk7)
Security Level: None
Affected Branches: MOODLE_18_STABLE, MOODLE_19_STABLE


 Description  « Hide
When upgrading from 1.8.5+ (Build: 20080507) to 1.9.2+ (Build: 20080725), the following schema inconsistencies occur:

1.) groupings_groups.groupid does not have a default set, though lib/db/install.xml has default="0"
2.) groups.courseid has default of 0, though lib/db/install.xml has no default
3.) groups.enrolmentkey has a default of '', though lib/db/install.xml has no default
4.) groups.name is varchar(255), though lib/db/install.xml is varchar(254)

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
No commits have yet been performed on this issue.