[MDL-21868] Upgrade to 1.9.7+ fails on MS SQL - Moodle Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Blocker
Resolution: Fixed
Affects Version/s: 1.9.7
Fix Version/s: 1.9.8
Component/s: Database SQL/XMLDB, MNet
Labels:
None

Database:

Microsoft SQL
Affected Branches:
MOODLE_19_STABLE
Fixed Branches:
MOODLE_19_STABLE

Description

See http://moodle.org/mod/forum/discuss.php?d=146195 for full details.

The recent MNet changes fail with an error like "Alter column ... failed because one or more objects references this column."

I guess that is what happens when you try to alter a column used by an index.

That could either be a bug in XMLDB, or someone writing upgrade code by hand that does something unsupported.

Attachments

Activity

People

Assignee:: Eloy Lafuente (stronk7)

Reporter:: Tim Hunt

Tester:: Nobody

Participants:: Eloy Lafuente (stronk7), Tim Hunt

Component watchers:: David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo, David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 20/Mar/10 6:49 AM

Updated:: 14/Dec/10 2:40 AM

Resolved:: 22/Mar/10 10:29 AM

Fix Release Date:: 25/Mar/10