Debug info: Tablespace is missing for table `moodle31`.`mdl_usertours_tours`.

[gjb2048]

Hi Andrew and Gavin,

When installing UserTours 3.1 (Build: 2016052306) on 3.1.4+ (Build: 20170202) of Moodle on MySQL 5.7 I get the following stack trace (debugging at developer level already):

Debug info: Tablespace is missing for table `moodle31`.`mdl_usertours_tours`.
CREATE TABLE mdl_usertours_tours (
id BIGINT(10) NOT NULL auto_increment,
name VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
description LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
pathmatch VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci,
enabled TINYINT(1) NOT NULL DEFAULT 0,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
configdata LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='List of tours'
;
CREATE TABLE mdl_usertours_steps (
id BIGINT(10) NOT NULL auto_increment,
tourid BIGINT(10) NOT NULL,
title LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
content LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci,
targettype TINYINT(2) NOT NULL,
targetvalue LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
sortorder BIGINT(10) NOT NULL DEFAULT 0,
configdata LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_userstep_tousor_ix (tourid, sortorder)
, KEY mdl_userstep_tou_ix (tourid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_general_ci
COMMENT='Steps in an tour' 
Error code: ddlexecuteerror
×Stack trace:
line 485 of \lib\dml\moodle_database.php: ddl_change_structure_exception thrown
line 919 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 514 of \lib\upgradelib.php: call to database_manager->install_from_xmldb_file()
line 1742 of \lib\upgradelib.php: call to upgrade_plugins()
line 683 of \admin\index.php: call to upgrade_noncore()

Cheers,

Gareth

[gjb2048]

Ok, really odd. Removed the tables in the DB and reinstalled, now works.

[gjb2048]

Will leave as FYI.