Hi Tim, thank you for letting me reflect and make further investigation. Tried again to update the 1.8 Database (either Moodel version are at teh latest weekly build).
The last ouput in the web interface are::
quiz module needs upgrading
(mysql): SELECT id FROM mdl_question_numerical_units WHERE id > (SELECT MIN(iqnu.id) FROM mdl_question_numerical_units iqnu WHERE iqnu.question = mdl_question_numerical_units.question AND iqnu.unit = mdl_question_numerical_units.unit) (mysql): SHOW TABLES (mysql): SHOW INDEX FROM mdl_question_numerical_units (mysql): CREATE UNIQUE INDEX mdl_quesnumeunit_queuni_uix ON mdl_question_numerical_units (question, unit)
Operazione eseguita con successo
(mysql): ALTER TABLE mdl_quiz MODIFY COLUMN timelimit BIGINT(10) unsigned NOT NULL DEFAULT 0 after timemodified
Operazione eseguita con successo
and this from the upgradelogs:
resource module needs upgrading
resource tabelle sono state impostate correttamente
scorm module needs upgrading
scorm tabelle sono state impostate correttamente
survey module needs upgrading
survey tabelle sono state impostate correttamente
wiki module needs upgrading
wiki tabelle sono state impostate correttamente
workshop module needs upgrading
workshop tabelle sono state impostate correttamente
Looks like the problem is eleswhere.
Bug
Blocker
If it fails silently, how do you know it is the quiz that is causing the problem? There must be some indication how far the upgrade got? What was the previous SQL statement that succeeded, and hence which is the one that failed? (moodledata/upgradelogs)