Visvanath Ratnaweera

I am upgrading a 2.7.19 (Build: 20170313) site to 3.1.5+ (Build: 20170331).

The process halts with:
===
qtype_ddimageortext
DDL sql execution error

More information about this error

Debug info: Table 'mdl_qtype_ddimageortext' already exists
CREATE TABLE mdl_qtype_ddimageortext (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
shuffleanswers SMALLINT(4) NOT NULL DEFAULT 1,
correctfeedback LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
correctfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
partiallycorrectfeedback LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
partiallycorrectfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
incorrectfeedback LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
incorrectfeedbackformat TINYINT(2) NOT NULL DEFAULT 0,
shownumcorrect TINYINT(2) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_qtypddim_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='Defines drag and drop (text or images onto a background imag'
;
CREATE TABLE mdl_qtype_ddimageortext_drops (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
no BIGINT(10) NOT NULL DEFAULT 0,
xleft BIGINT(10) NOT NULL DEFAULT 0,
ytop BIGINT(10) NOT NULL DEFAULT 0,
choice BIGINT(10) NOT NULL DEFAULT 0,
label LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_qtypddimdrop_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='Drop boxes'
;
CREATE TABLE mdl_qtype_ddimageortext_drags (
id BIGINT(10) NOT NULL auto_increment,
questionid BIGINT(10) NOT NULL DEFAULT 0,
no BIGINT(10) NOT NULL DEFAULT 0,
draggroup BIGINT(10) NOT NULL DEFAULT 0,
infinite SMALLINT(4) NOT NULL DEFAULT 0,
label LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mdl_qtypddimdrag_que2_ix (questionid)
)
ENGINE = InnoDB
DEFAULT CHARACTER SET utf8
DEFAULT COLLATE = utf8_unicode_ci
COMMENT='Images to drag. Actual file names are not stored here we use'
Error code: ddlexecuteerror
Stack trace:
line 485 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 1000 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()
===
The more information link points to https://docs.moodle.org/31/en/error/moodle/ddlexecuteerror

I have upgraded a copy of the same site, in the same server, a couple of weeks ago. It was before the recent security update. The Moodle version then was 2.7.17+ (Build: 20161129).

Has the update 2.7.17 > 2.7.19 introduced a bug?

Mary,

Yes, they are very similar. I added a note to https://tracker.moodle.org/browse/MDL-52838.

Hi all

I have set up a pretty conventional workshop. It progressed in to Assessment phase. Once a participant tries to assess another, Moodle throws "Undefined variable: type in moodle/lib/pear/HTML/QuickForm/group.php on line 277" Interestingly three times - for the three missing boxes(?). See screen-shots.

Moodle 2.7.19 (Build: 20170313)
LAMP, PHP Version 5.6.30-0+deb8u1, MySQL 5.5.54
(The same installation as in "Creating a new wiki throws error/moodle/invalidcoursemodule" https://moodle.org/mod/forum/discuss.php?d=350178. Yes, I cleared the caches!)

Hallo Peter

Danke fuer das Testen ein zweites Mal!

Also, ob index.html die Hauptdatei ist oder multiscreen.html, da besteht kein grundsaetzlicher Unterschied.

Die Tipps ueber die Videoformate und Captivate Versionen habe ich weitergeleitet.

Mir ging es darum, ob "Datei" die richtige Weg ist solche Lernsequenzen ueber Moodle anzubieten. Die Antwort ist Ja, verstehe ich.

Aus meiner Sicht ist die Frage beantwortet, dank deinem Beitrag!

Hi

This is incredible! Clearing the browser cache didn't help at first. I had three browsers open, as student, teacher and admin. I cleared the first two. Then thought of the server cache and emptied that too (from the third browser). I can't say which one was right, whatever the problem is gone!

Many thanks! You saved hours of my time, ...