Witam Wszystkich,
mam problem z aktualizacją do 3.11 - otrzymuję taki komunikat (może ktoś miał podobny problem?):
Błąd wykonania DDL sql
Debug info: Table 'mood_tool_brickfield_checks' already exists
CREATE TABLE mood_tool_brickfield_checks (
id BIGINT(10) NOT NULL auto_increment,
checktype VARCHAR(64) COLLATE utf8mb4_unicode_ci,
shortname VARCHAR(64) COLLATE utf8mb4_unicode_ci,
checkgroup BIGINT(16) DEFAULT 0,
status SMALLINT(4) NOT NULL,
severity TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbricchec_che3_ix (checktype)
, KEY mood_toolbricchec_che4_ix (checkgroup)
, KEY mood_toolbricchec_sta2_ix (status)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Checks details'
;
CREATE TABLE mood_tool_brickfield_process (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
item VARCHAR(64) COLLATE utf8mb4_unicode_ci,
contextid BIGINT(10),
innercontextid BIGINT(10),
timecreated BIGINT(16),
timecompleted BIGINT(16),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbricproc_tim2_ix (timecompleted)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Queued records to initiate new processing of specific target'
;
CREATE TABLE mood_tool_brickfield_areas (
id BIGINT(10) NOT NULL auto_increment,
type TINYINT(2) NOT NULL DEFAULT 0,
contextid BIGINT(10),
component VARCHAR(100) COLLATE utf8mb4_unicode_ci,
tablename VARCHAR(40) COLLATE utf8mb4_unicode_ci,
fieldorarea VARCHAR(50) COLLATE utf8mb4_unicode_ci,
itemid BIGINT(10),
filename VARCHAR(1333) COLLATE utf8mb4_unicode_ci,
reftable VARCHAR(40) COLLATE utf8mb4_unicode_ci,
refid BIGINT(10),
cmid BIGINT(10),
courseid BIGINT(10),
categoryid BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbricarea_coucmi2_ix (courseid, cmid)
, KEY mood_toolbricarea_typtabit2_ix (type, tablename, itemid, fieldorarea)
, KEY mood_toolbricarea_typconco2_ix (type, contextid, component, fieldorarea, itemid)
, KEY mood_toolbricarea_refrefty2_ix (reftable, refid, type)
, KEY mood_toolbricarea_cou2_ix (courseid)
, KEY mood_toolbricarea_cmi2_ix (cmid)
, KEY mood_toolbricarea_cat2_ix (categoryid)
, KEY mood_toolbricarea_con2_ix (contextid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Areas that have been checked for accessibility problems'
;
CREATE TABLE mood_tool_brickfield_content (
id BIGINT(10) NOT NULL auto_increment,
areaid BIGINT(10) NOT NULL,
contenthash VARCHAR(40) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
iscurrent TINYINT(1) NOT NULL DEFAULT 0,
status TINYINT(2) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL,
timechecked BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbriccont_sta2_ix (status)
, KEY mood_toolbriccont_iscare2_ix (iscurrent, areaid)
, KEY mood_toolbriccont_are2_ix (areaid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Content of an area at a particular time (recognised by a has'
;
CREATE TABLE mood_tool_brickfield_results (
id BIGINT(10) NOT NULL auto_increment,
contentid BIGINT(10),
checkid BIGINT(10) NOT NULL,
errorcount BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbricresu_conche2_ix (contentid, checkid)
, KEY mood_toolbricresu_con2_ix (contentid)
, KEY mood_toolbricresu_che2_ix (checkid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Results of the accessibility checks'
;
CREATE TABLE mood_tool_brickfield_errors (
id BIGINT(10) NOT NULL auto_increment,
resultid BIGINT(10) NOT NULL,
linenumber BIGINT(10) NOT NULL DEFAULT 0,
errordata LONGTEXT COLLATE utf8mb4_unicode_ci,
htmlcode LONGTEXT COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbricerro_res2_ix (resultid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Errors during the accessibility checks'
;
CREATE TABLE mood_tool_brickfield_summary (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
status TINYINT(1),
activities BIGINT(10),
activitiespassed BIGINT(10),
activitiesfailed BIGINT(10),
errorschecktype1 BIGINT(10),
errorschecktype2 BIGINT(10),
errorschecktype3 BIGINT(10),
errorschecktype4 BIGINT(10),
errorschecktype5 BIGINT(10),
errorschecktype6 BIGINT(10),
errorschecktype7 BIGINT(10),
failedchecktype1 BIGINT(10),
failedchecktype2 BIGINT(10),
failedchecktype3 BIGINT(10),
failedchecktype4 BIGINT(10),
failedchecktype5 BIGINT(10),
failedchecktype6 BIGINT(10),
failedchecktype7 BIGINT(10),
percentchecktype1 BIGINT(10),
percentchecktype2 BIGINT(10),
percentchecktype3 BIGINT(10),
percentchecktype4 BIGINT(10),
percentchecktype5 BIGINT(10),
percentchecktype6 BIGINT(10),
percentchecktype7 BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbricsumm_sta2_ix (status)
, KEY mood_toolbricsumm_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Contains accessibility check results summary information.'
;
CREATE TABLE mood_tool_brickfield_cache_check (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
status TINYINT(1),
checkid BIGINT(10),
checkcount BIGINT(10),
errorcount BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbriccachchec_sta2_ix (status)
, KEY mood_toolbriccachchec_err2_ix (errorcount)
, KEY mood_toolbriccachchec_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Contains accessibility summary information per check.'
;
CREATE TABLE mood_tool_brickfield_cache_acts (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
status TINYINT(1),
component VARCHAR(64) COLLATE utf8mb4_unicode_ci,
totalactivities BIGINT(10),
failedactivities BIGINT(10),
passedactivities BIGINT(10),
errorcount BIGINT(10),
CONSTRAINT PRIMARY KEY (id)
, KEY mood_toolbriccachacts_sta2_ix (status)
, KEY mood_toolbriccachacts_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Contains accessibility summary information per activity.'
;
CREATE TABLE mood_tool_brickfield_schedule (
id BIGINT(10) NOT NULL auto_increment,
contextlevel BIGINT(10) NOT NULL DEFAULT 50,
instanceid BIGINT(10) NOT NULL,
contextid BIGINT(10),
status TINYINT(2) NOT NULL DEFAULT 0,
timeanalyzed BIGINT(10) DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mood_toolbricsche_conins2_uix (contextlevel, instanceid)
, KEY mood_toolbricsche_sta2_ix (status)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Keeps the per course content analysis schedule.'
Error code: ddlexecuteerror
Stack trace:
- 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 665 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
- line 1929 of /lib/upgradelib.php: call to upgrade_plugins()
- line 713 of /admin/index.php: call to upgrade_noncore()