Moodle-Technikforum

Hallo,

ich habe beim Versuch von Version 1.7.1+ (version = 2006101010) auf 1.8.2+ ein Upgrade durchzuführen folgendes Problem.

Ich arbeite mit einer Kopie der Datenbank, welche ich aus der 1.7er Version im Wartungsmodus per Dump herausgelesen habe. Nach dem Einspielen und Konfigurieren der 1.8.2er Version in einem eigenen Verzeichnis mit eigenem Data-Verzeichnis kann ich die ersten Upgrade-Skripte durchklickern bis zum Neulogin. Nachdem ich mich dann wieder als admin angemeldet habe kommt der Fehler auf
admin/index.php ()
--- Anfang Screen-Kopie ---

This script generated 8 warnings - Scroll to the first warning

group

---

(mysql): SHOW TABLES

---

---

(mysql): SHOW INDEX FROM mdl_groups_members

---

---

(mysql): CREATE TABLE mdl_groups ( id BIGINT(10) unsigned NOT NULL auto_increment, name VARCHAR(254) NOT NULL DEFAULT '', description TEXT, enrolmentkey VARCHAR(50) NOT NULL DEFAULT '', lang VARCHAR(30) NOT NULL DEFAULT 'en', theme VARCHAR(50) NOT NULL DEFAULT '', picture BIGINT(10) unsigned NOT NULL DEFAULT 0, hidepicture TINYINT(1) unsigned NOT NULL DEFAULT 0, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, timemodified BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

---

1050: Table 'mdl_groups' already exists

---

(mysql): ALTER TABLE mdl_groups COMMENT='Each record represents a group.'

---

---

(mysql): CREATE TABLE mdl_groups_groupings ( id BIGINT(10) NOT NULL auto_increment, name VARCHAR(255) NOT NULL DEFAULT '', description TEXT, timecreated BIGINT(10) unsigned NOT NULL DEFAULT 0, viewowngroup TINYINT(1) unsigned NOT NULL DEFAULT 1, viewallgroupsmembers TINYINT(1) unsigned NOT NULL DEFAULT 0, viewallgroupsactivities TINYINT(1) unsigned NOT NULL DEFAULT 0, teachersgroupmark TINYINT(1) unsigned NOT NULL DEFAULT 0, teachersgroupview TINYINT(1) unsigned NOT NULL DEFAULT 0, teachersoverride TINYINT(1) unsigned NOT NULL DEFAULT 0, teacherdeletable TINYINT(1) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

---

1050: Table 'mdl_groups_groupings' already exists

---

(mysql): ALTER TABLE mdl_groups_groupings COMMENT='A grouping is a collection of groups.'

---

---

(mysql): CREATE TABLE mdl_groups_members ( id BIGINT(10) unsigned NOT NULL auto_increment, groupid BIGINT(10) unsigned NOT NULL DEFAULT 0, userid BIGINT(10) unsigned NOT NULL DEFAULT 0, timeadded BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

---

1050: Table 'mdl_groups_members' already exists

---

(mysql): ALTER TABLE mdl_groups_members COMMENT='Link a user to a group.'

---

---

(mysql): CREATE UNIQUE INDEX mdl_groumemb_grouse_uix ON mdl_groups_members (groupid, userid)

---

1062: Duplicate entry '6-76' for key 2

---

(mysql): CREATE TABLE mdl_groups_courses_groups ( id BIGINT(10) NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

---

1050: Table 'mdl_groups_courses_groups' already exists

---

(mysql): ALTER TABLE mdl_groups_courses_groups COMMENT='Link a group to a course (or the site).'

---

---

(mysql): CREATE TABLE mdl_groups_courses_groupings ( id BIGINT(10) NOT NULL auto_increment, courseid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupingid BIGINT(10) unsigned NOT NULL, CONSTRAINT PRIMARY KEY (id) )

---

1050: Table 'mdl_groups_courses_groupings' already exists

---

(mysql): ALTER TABLE mdl_groups_courses_groupings COMMENT='Link a grouping to a course (or the site).'

---

---

(mysql): CREATE TABLE mdl_groups_groupings_groups ( id BIGINT(10) NOT NULL auto_increment, groupingid BIGINT(10) unsigned NOT NULL DEFAULT 0, groupid BIGINT(10) unsigned NOT NULL, timeadded BIGINT(10) unsigned NOT NULL DEFAULT 0, CONSTRAINT PRIMARY KEY (id) )

---

1050: Table 'mdl_groups_groupings_groups' already exists

---

(mysql): ALTER TABLE mdl_groups_groupings_groups COMMENT='Link a group to a grouping.'

---

---

(mysql): INSERT INTO mdl_log_display(module, action, mtable, field) VALUES ('group', 'view', 'groups', 'name')

---

1062: Duplicate entry 'group-view' for key 2

Der [weiter]-Schalter leitet auf dieselbe Seite weiter.

Wenn ich die genannten Tabellen per drop lösche, fehlen mir aber die Gruppenzugehörigkeiten der Teilnehmer. Die anderen Tipps zu "doppelten Tabellen" helfen auch niocht weiter.

??? "Bahnhof"

Rolf