Frissítés új verzióra
tool_monitor
Hiba a DDL sql végrehajtása közben

További tájékoztatás erről a hibáról

Általában nincs lehetőség a telepítés során előforduló hibák kiküszöbölésére, előfordulhat, hogy új adatbázist kell létrehoznia vagy egy másik adatbázis-előtagot kell használnia, ha újra akarja futtatni a telepítést.

×Hibaelhárítási adatok: Table 'mdl_tool_monitor_rules' already exists
CREATE TABLE mdl_tool_monitor_rules (
id BIGINT(10) NOT NULL auto_increment,
description LONGTEXT COLLATE utf8mb4_unicode_ci,
descriptionformat TINYINT(1) NOT NULL,
name VARCHAR(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
userid BIGINT(10) NOT NULL,
courseid BIGINT(10) NOT NULL,
plugin VARCHAR(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
eventname VARCHAR(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
template LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
templateformat TINYINT(1) NOT NULL,
frequency SMALLINT(4) NOT NULL,
timewindow MEDIUMINT(5) NOT NULL,
timemodified BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_toolmonirule_couuse2_ix (courseid, userid)
, KEY mdl_toolmonirule_eve2_ix (eventname)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Table to store rules'
;
CREATE TABLE mdl_tool_monitor_subscriptions (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
ruleid BIGINT(10) NOT NULL,
cmid BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
lastnotificationsent BIGINT(10) NOT NULL DEFAULT 0,
inactivedate BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_toolmonisubs_couuse2_ix (courseid, userid)
, KEY mdl_toolmonisubs_rul2_ix (ruleid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Table to store user subscriptions to various rules'
;
CREATE TABLE mdl_tool_monitor_history (
id BIGINT(10) NOT NULL auto_increment,
sid BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
timesent BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mdl_toolmonihist_siduseti2_uix (sid, userid, timesent)
, KEY mdl_toolmonihist_sid2_ix (sid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Table to store history of message notifications sent'
;
CREATE TABLE mdl_tool_monitor_events (
id BIGINT(10) NOT NULL auto_increment,
eventname VARCHAR(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
contextid BIGINT(10) NOT NULL,
contextlevel BIGINT(10) NOT NULL,
contextinstanceid BIGINT(10) NOT NULL,
link VARCHAR(254) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
courseid BIGINT(10) NOT NULL,
timecreated BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='A table that keeps a log of events related to subscriptions'
Error code: ddlexecuteerror
×Veremkiíratás:
line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 1098 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 427 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 372 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
line 671 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 1935 of /lib/upgradelib.php: call to upgrade_plugins()
line 719 of /admin/index.php: call to upgrade_noncore()