[#MDL-15984] Inconsistent schema when upgrading - Moodle Tracker

Details

Type: Bug
Status: Closed
Priority: Major
Resolution: Won't Fix
Affects Version/s: 1.8.5, 1.9.3
Fix Version/s: None
Component/s: Database SQL/XMLDB, Groups
Labels:
None
Environment:
PostgreSQL 8.1.11

Database:

PostgreSQL
Affected Branches:
MOODLE_18_STABLE, MOODLE_19_STABLE

Description

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)

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Chris Bandy added a comment - 05/Nov/08 6:28 AM

Exactly the same in 1.9.3+ (Build: 20081020)

Show

Chris Bandy added a comment - 05/Nov/08 6:28 AM Exactly the same in 1.9.3+ (Build: 20081020)

Hide

Permalink

Michael de Raadt added a comment - 05/Jan/12 1:45 PM

Thanks for reporting this issue.

We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.

If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.

Michael d;

lqjjLKA0p6

Show

Michael de Raadt added a comment - 05/Jan/12 1:45 PM Thanks for reporting this issue. We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported. If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed. Michael d; lqjjLKA0p6

Hide

Permalink

Michael de Raadt added a comment - 06/Feb/12 4:30 PM

I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

Show

Michael de Raadt added a comment - 06/Feb/12 4:30 PM I'm closing this issue as it appears to have become inactive and is probably not relevant to a current supported version. If you are encountering this problem or one similar, please launch a new issue.

People

Assignee:

Eloy Lafuente (stronk7)

Reporter:

Chris Bandy

Participants:

Chris Bandy, Eloy Lafuente (stronk7), Michael de Raadt

Vote (0)

Watch (0)

Dates

Created:

09/Aug/08 5:04 AM

Updated:

Monday 4:30 PM

Resolved:

Monday 4:30 PM