Hi,
I am unable to install the local "mail plugin on moodle 3.5.
Getting the below errors after clicking on upgrade moodle database.
Debug info: Table 'mdl_local_mail_labels' already exists
CREATE TABLE mdl_local_mail_labels (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
name VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
color VARCHAR(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locamaillabe_use2_ix (userid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='-'
;
CREATE TABLE mdl_local_mail_messages (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
subject VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
content LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
format SMALLINT(4) NOT NULL,
attachments SMALLINT(4) NOT NULL DEFAULT 0,
draft TINYINT(1) NOT NULL,
time BIGINT(10) NOT NULL,
normalizedsubject VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci,
normalizedcontent LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locamailmess_cou2_ix (courseid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='-'
;
CREATE TABLE mdl_local_mail_message_labels (
id BIGINT(10) NOT NULL auto_increment,
messageid BIGINT(10) NOT NULL,
labelid BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locamailmesslabe_mes2_ix (messageid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='-'
;
CREATE TABLE mdl_local_mail_message_refs (
id BIGINT(10) NOT NULL auto_increment,
messageid BIGINT(10) NOT NULL,
reference BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locamailmessrefs_mes2_ix (messageid)
, KEY mdl_locamailmessrefs_ref2_ix (reference)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='-'
;
CREATE TABLE mdl_local_mail_message_users (
id BIGINT(10) NOT NULL auto_increment,
messageid BIGINT(10) NOT NULL,
userid BIGINT(10) NOT NULL,
role VARCHAR(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
unread TINYINT(1) NOT NULL,
starred TINYINT(1) NOT NULL,
deleted TINYINT(1) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locamailmessuser_mes2_ix (messageid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='-'
;
CREATE TABLE mdl_local_mail_index (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
type VARCHAR(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
item BIGINT(10) NOT NULL,
messageid BIGINT(10) NOT NULL,
time BIGINT(10) NOT NULL,
unread TINYINT(1) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locamailinde_mesuse2_ix (messageid, userid)
, KEY mdl_locamailinde_usetypite2_ix (userid, type, item, unread)
, UNIQUE KEY mdl_locamailinde_usetypit2_uix (userid, type, item, time, messageid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='-'
Error code: ddlexecuteerror
×Stack trace:
line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 1049 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 594 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
line 1857 of /lib/upgradelib.php: call to upgrade_plugins()
line 694 of /admin/index.php: call to upgrade_noncore()
There is no table name like that in database.
How to resolve this?
Thanks