This is the error message I get when updating this component "mod_coursecertificate", I don't know how to fix this:



Table 'modl_coursecertificate' already exists
CREATE TABLE modl_coursecertificate (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL,
name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
template BIGINT(10) NOT NULL DEFAULT 0,
automaticsend TINYINT(1) NOT NULL DEFAULT 0,
expirydatetype TINYINT(1) NOT NULL DEFAULT 0,
expirydateoffset BIGINT(10) NOT NULL DEFAULT 0,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
intro LONGTEXT COLLATE utf8mb4_unicode_ci,
introformat SMALLINT(4) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY modl_cour_aut2_ix (automaticsend)
, KEY modl_cour_cou2_ix (course)
, KEY modl_cour_tem2_ix (template)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Compressed
COMMENT='Stores the course certificate activity module instances.'
Error code: ddlexecuteerror


Stack:

• line 500 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
• line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
• line 1223 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_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 871 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
• line 645 of /lib/upgradelib.php: call to upgrade_plugins_modules()
• line 1931 of /lib/upgradelib.php: call to upgrade_plugins()
• line 726 of /admin/index.php: call to upgrade_noncore()