Project

General

Profile

Bug #5110

migration: Duplicate column name 'type'

Added by Laurent Opprecht almost 9 years ago. Updated almost 9 years ago.

Status:
Bug resolved
Priority:
Normal
Assignee:
-
Category:
-
Target version:
1.9 RC1
Start date:
02/07/2012
Due date:
% Done:

100%

Estimated time:
Spent time:
0.10 h
Complexity:
Normal
SCRUM pts - complexity:
?

Description

TABLE gradebook_evaluation ADD COLUMN type varchar(40) NOT NULL

Associated revisions

Revision 2996d675 (diff)
Added by Laurent Opprecht almost 9 years ago

see #5110 Duplicate column name 'type'

Revision c05f9eef (diff)
Added by Laurent Opprecht almost 9 years ago

see #5110: migration: Duplicate column name 'type'

History

#1

Updated by Laurent Opprecht almost 9 years ago

  • Status changed from New to Needs testing
  • % Done changed from 0 to 100
#2

Updated by Laurent Opprecht almost 9 years ago

  • Target version set to 1.9 RC1
#3

Updated by Yannick Warnier almost 9 years ago

  • Status changed from Needs testing to Needs more info
  • % Done changed from 100 to 90

I don't know if that's Redmine or your commit, but there is no reference to "type" in this commit (just something about glossary)

#4

Updated by Laurent Opprecht almost 9 years ago

  • % Done changed from 90 to 0

Dont' think I actually did something for that one (looks like things got mixed up with another revision I am afraid)

IN migrate-db-1.8.6-1.8.6.1-pre

ALTER TABLE gradebook_evaluation ADD COLUMN type varchar(40) NOT NULL default 'evaluation';

IN migrate-db-1.8.6.1-1.8.6.2-pre

-- This first part is for the main database
-- xxMAINxx
ALTER TABLE gradebook_evaluation ADD COLUMN type varchar(40) NOT NULL;

Not sure which one I need to remove

#5

Updated by Laurent Opprecht almost 9 years ago

  • Assignee changed from Laurent Opprecht to Yannick Warnier
#6

Updated by Yannick Warnier almost 9 years ago

  • Status changed from Needs more info to Assigned
  • Assignee changed from Yannick Warnier to Laurent Opprecht

You should remove the one without the default value (I got that by checking the db_main.sql)

#7

Updated by Julio Montoya almost 9 years ago

  • Status changed from Assigned to Bug resolved
  • Assignee deleted (Laurent Opprecht)
  • % Done changed from 0 to 100

I confirmed that

-- xxMAINxx
ALTER TABLE gradebook_evaluation ADD COLUMN type varchar(40) NOT NULL;

was removed.

Also available in: Atom PDF