Tim Hunt added a comment - 12/Jul/08 04:17 PM

Tim Hunt added a comment - 12/Jul/08 04:17 PM 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)

Andrea Bicciolo added a comment - 13/Jul/08 02:09 AM

Andrea Bicciolo added a comment - 13/Jul/08 02:09 AM 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.

Andrea Bicciolo added a comment - 14/Jul/08 03:40 PM - edited

Andrea Bicciolo added a comment - 14/Jul/08 03:40 PM - edited Reopening, even if it is not a Quiz Bug, I think there are some issue to be further investigated. The stall problem persists.

Andrea Bicciolo added a comment - 14/Jul/08 03:40 PM

Andrea Bicciolo added a comment - 14/Jul/08 03:40 PM Assigning to Petr

Chris Bandy added a comment - 30/Aug/08 07:43 AM

Chris Bandy added a comment - 30/Aug/08 07:43 AM We experienced this during our upgrade and discovered it is simply a browser/server timeout. These patches (1.) provide a notice before the time consuming process of converting quiz grades and (2.) prevent the browser timeout.