Witam, zaktualizowałem moodle do wersji 3.3, następnie próbowałem odinstalować "stary" dodatek chyba zdania (miał czerwony napis "można odinstalować" i... moodle padło. Przywróciłem z kopii zapasowej - ale po zaktualizowaniu wyskakuje błąd:
Aktualizacja do nowszej wersji
auth_oauth2
Błąd wykonania DDL sql
Debug info: Table 'mood_auth_oauth2_linked_login' already exists
CREATE TABLE mood_auth_oauth2_linked_login (
id BIGINT(10) NOT NULL auto_increment,
timecreated BIGINT(10) NOT NULL,
timemodified BIGINT(10) NOT NULL,
usermodified BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
issuerid BIGINT(10) NOT NULL,
username VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
email LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
confirmtoken VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
confirmtokenexpires BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_authoautlinklogi_issu2_ix (issuerid, username)
, KEY mood_authoautlinklogi_use3_ix (usermodified)
, KEY mood_authoautlinklogi_use4_ix (userid)
, KEY mood_authoautlinklogi_iss2_ix (issuerid)
, UNIQUE KEY mood_authoautlinklogi_use2_uix (userid, issuerid, username)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Accounts linked to a users Moodle account.'
Error code: ddlexecuteerror
- line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 1000 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
- line 425 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
- line 370 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
- line 526 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
- line 1754 of /lib/upgradelib.php: call to upgrade_plugins()
- line 699 of /admin/index.php: call to upgrade_noncore()
