Olá a todos.
Tenho um Moodle, versao 3.6.5/MySQL e resolvi instalar o mreport e baixei-o pelo link fornecido... Assisti o vídeo... conferi os diretórios (E tem mais arquivo que o descrito para verificar) e... quando mando atualizar o Banco de Dados... Eis que... ERRO...
Alguem pode me dar uma ajudinha?
CREATE TABLE mdl_local_badiunet_session (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
dtype VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
serverip VARCHAR(255) COLLATE utf8mb4_general_ci,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timeexpire BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadisess_use2_ix (userid)
, KEY mdl_locabadisess_tim3_ix (timecreated)
, KEY mdl_locabadisess_tim4_ix (timeexpire)
, UNIQUE KEY mdl_locabadisess_nam2_uix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='manage session data'
;
CREATE TABLE mdl_local_badiunet_data (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadidata_tim3_ix (timecreated)
, KEY mdl_locabadidata_tim4_ix (timemodified)
, UNIQUE KEY mdl_locabadidata_nam2_uix (name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='general data'
;
CREATE TABLE mdl_local_badiunet_course (
id BIGINT(10) NOT NULL auto_increment,
courseid BIGINT(10) NOT NULL,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
valueint BIGINT(10),
valuenumber NUMERIC(10),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadicour_cou2_ix (courseid)
, KEY mdl_locabadicour_nam2_ix (name)
, KEY mdl_locabadicour_val3_ix (valueint)
, KEY mdl_locabadicour_val4_ix (valuenumber)
, KEY mdl_locabadicour_tim3_ix (timecreated)
, KEY mdl_locabadicour_tim4_ix (timemodified)
, UNIQUE KEY mdl_locabadicour_counam2_uix (courseid, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='general course data'
;
CREATE TABLE mdl_local_badiunet_categories (
id BIGINT(10) NOT NULL auto_increment,
categoryid BIGINT(10) NOT NULL,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
valueint BIGINT(10),
valuenumber NUMERIC(10,5),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadicate_cat2_ix (categoryid)
, KEY mdl_locabadicate_nam2_ix (name)
, KEY mdl_locabadicate_val3_ix (valueint)
, KEY mdl_locabadicate_val4_ix (valuenumber)
, KEY mdl_locabadicate_tim3_ix (timecreated)
, KEY mdl_locabadicate_tim4_ix (timemodified)
, UNIQUE KEY mdl_locabadicate_catnam2_uix (categoryid, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='general course category data'
;
CREATE TABLE mdl_local_badiunet_user (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
valueint BIGINT(10),
valuenumber NUMERIC(10,5),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadiuser_use2_ix (userid)
, KEY mdl_locabadiuser_nam2_ix (name)
, KEY mdl_locabadiuser_val3_ix (valueint)
, KEY mdl_locabadiuser_val4_ix (valuenumber)
, KEY mdl_locabadiuser_tim3_ix (timecreated)
, KEY mdl_locabadiuser_tim4_ix (timemodified)
, UNIQUE KEY mdl_locabadiuser_usenam2_uix (userid, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='general user data'
;
CREATE TABLE mdl_local_badiunet_user_enrol (
id BIGINT(10) NOT NULL auto_increment,
userid BIGINT(10) NOT NULL,
courseid BIGINT(10) NOT NULL,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
valueint BIGINT(10),
valuenumber NUMERIC(10,5),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadiuserenro_use2_ix (userid)
, KEY mdl_locabadiuserenro_cou2_ix (courseid)
, KEY mdl_locabadiuserenro_nam2_ix (name)
, KEY mdl_locabadiuserenro_val3_ix (valueint)
, KEY mdl_locabadiuserenro_val4_ix (valuenumber)
, KEY mdl_locabadiuserenro_tim3_ix (timecreated)
, KEY mdl_locabadiuserenro_tim4_ix (timemodified)
, UNIQUE KEY mdl_locabadiuserenro_usec2_uix (userid, courseid, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='general enrol data'
;
CREATE TABLE mdl_local_badiunet_log (
id BIGINT(10) NOT NULL auto_increment,
instanceid BIGINT(10),
instancetype VARCHAR(50) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
value LONGTEXT COLLATE utf8mb4_general_ci,
valueint BIGINT(10),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadilog_ins3_ix (instanceid)
, KEY mdl_locabadilog_ins4_ix (instancetype)
, KEY mdl_locabadilog_nam2_ix (name)
, KEY mdl_locabadilog_val2_ix (valueint)
, KEY mdl_locabadilog_tim3_ix (timecreated)
, KEY mdl_locabadilog_tim4_ix (timemodified)
, UNIQUE KEY mdl_locabadilog_insinsnam2_uix (instanceid, instancetype, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='general log data'
;
CREATE TABLE mdl_local_badiunet_log_sumarize (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(100) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
logid BIGINT(10) NOT NULL,
logtimecreated BIGINT(10) NOT NULL DEFAULT 0,
userid BIGINT(10) NOT NULL,
courseid BIGINT(10) NOT NULL,
module VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
action VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
actiontype VARCHAR(255) COLLATE utf8mb4_general_ci,
year BIGINT(10),
month BIGINT(10),
day BIGINT(10),
week BIGINT(10),
hour BIGINT(10),
minute BIGINT(10),
duration BIGINT(10),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadilogsuma_log_ix (logid)
, KEY mdl_locabadilogsuma_log2_ix (logtimecreated)
, KEY mdl_locabadilogsuma_nam_ix (name)
, KEY mdl_locabadilogsuma_use_ix (userid)
, KEY mdl_locabadilogsuma_cou_ix (courseid)
, KEY mdl_locabadilogsuma_mod_ix (module)
, KEY mdl_locabadilogsuma_act_ix (action)
, KEY mdl_locabadilogsuma_act2_ix (actiontype)
, KEY mdl_locabadilogsuma_yea_ix (year)
, KEY mdl_locabadilogsuma_mon_ix (month)
, KEY mdl_locabadilogsuma_day_ix (day)
, KEY mdl_locabadilogsuma_wee_ix (week)
, KEY mdl_locabadilogsuma_min_ix (minute)
, KEY mdl_locabadilogsuma_dur_ix (duration)
, KEY mdl_locabadilogsuma_tim_ix (timecreated)
, KEY mdl_locabadilogsuma_tim2_ix (timemodified)
, UNIQUE KEY mdl_locabadilogsuma_lognam_uix (logid, name)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='consolidate log data'
;
CREATE TABLE mdl_local_badiunet_mod_isumarize (
id BIGINT(10) NOT NULL auto_increment,
moodleid BIGINT(10),
moodlename VARCHAR(255) COLLATE utf8mb4_general_ci,
moodleurl VARCHAR(255) COLLATE utf8mb4_general_ci,
userid BIGINT(10) NOT NULL,
userfirstname VARCHAR(255) COLLATE utf8mb4_general_ci,
userlastname VARCHAR(255) COLLATE utf8mb4_general_ci,
useremail VARCHAR(255) COLLATE utf8mb4_general_ci,
useridnumber VARCHAR(255) COLLATE utf8mb4_general_ci,
userinfo LONGTEXT COLLATE utf8mb4_general_ci,
cohortid BIGINT(10),
cohortname VARCHAR(255) COLLATE utf8mb4_general_ci,
cohortidnumber VARCHAR(255) COLLATE utf8mb4_general_ci,
cohortinfo LONGTEXT COLLATE utf8mb4_general_ci,
courseid BIGINT(10),
coursefullname VARCHAR(255) COLLATE utf8mb4_general_ci,
courseshortname VARCHAR(255) COLLATE utf8mb4_general_ci,
courseidnumber VARCHAR(255) COLLATE utf8mb4_general_ci,
courseinfo LONGTEXT COLLATE utf8mb4_general_ci,
coursecatid BIGINT(10),
coursecatname VARCHAR(255) COLLATE utf8mb4_general_ci,
coursecatidnumber VARCHAR(255) COLLATE utf8mb4_general_ci,
coursecatparent VARCHAR(255) COLLATE utf8mb4_general_ci,
coursecatinfo LONGTEXT COLLATE utf8mb4_general_ci,
groupid BIGINT(10),
groupname VARCHAR(255) COLLATE utf8mb4_general_ci,
groupidnumber VARCHAR(255) COLLATE utf8mb4_general_ci,
groupinfo LONGTEXT COLLATE utf8mb4_general_ci,
activityid BIGINT(10) NOT NULL,
activitymodule VARCHAR(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
activityname VARCHAR(255) COLLATE utf8mb4_general_ci,
activityidnumber VARCHAR(255) COLLATE utf8mb4_general_ci,
activitytimestart BIGINT(10),
activitytimeend BIGINT(10),
activityinfo LONGTEXT COLLATE utf8mb4_general_ci,
responseid BIGINT(10) NOT NULL,
responsetime BIGINT(10),
responsecontent LONGTEXT COLLATE utf8mb4_general_ci,
responsegrade NUMERIC(10,5),
responseteachercomment LONGTEXT COLLATE utf8mb4_general_ci,
customchar1 VARCHAR(255) COLLATE utf8mb4_general_ci,
customchar2 VARCHAR(255) COLLATE utf8mb4_general_ci,
customchar3 VARCHAR(255) COLLATE utf8mb4_general_ci,
customchar4 VARCHAR(255) COLLATE utf8mb4_general_ci,
customchar5 VARCHAR(255) COLLATE utf8mb4_general_ci,
customtext1 LONGTEXT COLLATE utf8mb4_general_ci,
customtext2 LONGTEXT COLLATE utf8mb4_general_ci,
customtext3 LONGTEXT COLLATE utf8mb4_general_ci,
customtext4 LONGTEXT COLLATE utf8mb4_general_ci,
customtext5 LONGTEXT COLLATE utf8mb4_general_ci,
customint1 BIGINT(10),
customint2 BIGINT(10),
customint3 BIGINT(10),
customint4 BIGINT(10),
customint5 BIGINT(10),
customintnumber1 NUMERIC(10,5),
customintnumber2 NUMERIC(10,5),
customintnumber3 NUMERIC(10,5),
customintnumber4 NUMERIC(10,5),
customintnumber5 NUMERIC(10,5),
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_locabadimodisum_moo_ix (moodleid)
, KEY mdl_locabadimodisum_moo2_ix (moodlename)
, KEY mdl_locabadimodisum_moo3_ix (moodleurl)
, KEY mdl_locabadimodisum_use_ix (userid)
, KEY mdl_locabadimodisum_use2_ix (userfirstname)
, KEY mdl_locabadimodisum_use3_ix (userlastname)
, KEY mdl_locabadimodisum_use4_ix (useremail)
, KEY mdl_locabadimodisum_use5_ix (useridnumber)
, KEY mdl_locabadimodisum_coh_ix (cohortid)
, KEY mdl_locabadimodisum_coh2_ix (cohortname)
, KEY mdl_locabadimodisum_coh3_ix (cohortidnumber)
, KEY mdl_locabadimodisum_cou_ix (courseid)
, KEY mdl_locabadimodisum_cou2_ix (coursefullname)
, KEY mdl_locabadimodisum_cou3_ix (courseshortname)
, KEY mdl_locabadimodisum_cou4_ix (courseidnumber)
, KEY mdl_locabadimodisum_cou5_ix (coursecatid)
, KEY mdl_locabadimodisum_cou6_ix (coursecatname)
, KEY mdl_locabadimodisum_cou7_ix (coursecatidnumber)
, KEY mdl_locabadimodisum_gro_ix (groupid)
, KEY mdl_locabadimodisum_gro2_ix (groupname)
, KEY mdl_locabadimodisum_gro3_ix (groupidnumber)
, KEY mdl_locabadimodisum_act_ix (activityid)
, KEY mdl_locabadimodisum_act2_ix (activitymodule)
, KEY mdl_locabadimodisum_act3_ix (activityname)
, KEY mdl_locabadimodisum_act4_ix (activityidnumber)
, KEY mdl_locabadimodisum_act5_ix (activitytimestart)
, KEY mdl_locabadimodisum_act6_ix (activitytimeend)
, KEY mdl_locabadimodisum_res_ix (responseid)
, KEY mdl_locabadimodisum_res2_ix (responsetime)
, KEY mdl_locabadimodisum_res3_ix (responsegrade)
, KEY mdl_locabadimodisum_cus_ix (customchar1)
, KEY mdl_locabadimodisum_cus2_ix (customchar2)
, KEY mdl_locabadimodisum_cus3_ix (customint1)
, KEY mdl_locabadimodisum_cus4_ix (customint2)
, KEY mdl_locabadimodisum_cus5_ix (customintnumber1)
, KEY mdl_locabadimodisum_cus6_ix (customintnumber2)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_general_ci ROW_FORMAT=Dynamic
COMMENT='consolidate log data'
Error code: ddlexecuteerror
- line 492 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
- line 1070 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 599 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
- line 1852 of /lib/upgradelib.php: call to upgrade_plugins()
- line 694 of /admin/index.php: call to upgrade_noncore()