Moodle

1.7 install / upgrade hang up at quiz

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Cannot Reproduce
  • Affects Version/s: 1.7
  • Fix Version/s: None
  • Component/s: Installation
  • Labels:
    None
  • Environment:
    Home computer Linux Suse 10.2, AMD 64, 2 gig ram
    Work computer Linux Suse 10.1, Intel 1700, 512 meg ram

Description

Was using 1.5.2 during the semester when it started to slow down monstrously. You can see this if you go to http://cabanisspc.uamont.edu/osca/moodle and login as test (password tester) from a bunch of computers at once. With 24 computers in a lab the time to get everyone logged in was over 10 minutes. And if they were taking a quiz, the computer simply froze. It was to the point of being unusable. So I decided to bring everything home to my home server. A far more capable machine.

I copy the entire website from work along with reinstalling the database. Do the standard upgrade process and we seem to have hit a snag. I get the following message.

I got a lot of warnings during the install and then the following.

quiz module needs upgrading
Upgrade function xmldb_quiz_upgrade was not available in quiz: /srv/www/htdocs/osca2/moodle/mod/quiz/db/upgrade.php
Scroll to next warning

Scroll to previous warning Upgrading quiz from 2005060301 to 2006091901 FAILED! Scroll to continue button

And the upgrade halts.

Should I have taken an intermediate install first or am I simply missing a file?

Activity

Hide
dboy added a comment -

Yes, i am experiencing the same problem, and have searched a little bit. Someone gave an advice like following:

in file 'mod/quiz/db/mysql.php', line 554
change line

$success = $success && execute_sql("UPDATE {$CFG->prefix}quiz_questions SET length = 0 WHERE qtype = ".DESCRIPTION);to

$success = $success && execute_sql("UPDATE {$CFG->prefix}quiz_questions SET length = 0 WHERE qtype = '".DESCRIPTION."'");and start upgrading 1.4 -> 1.7 again (ie recover old 1.4 dbase from backup)

I have followed this one, but it does not work......

Hope someone could fix it

Show
dboy added a comment - Yes, i am experiencing the same problem, and have searched a little bit. Someone gave an advice like following: in file 'mod/quiz/db/mysql.php', line 554 change line $success = $success && execute_sql("UPDATE {$CFG->prefix}quiz_questions SET length = 0 WHERE qtype = ".DESCRIPTION);to $success = $success && execute_sql("UPDATE {$CFG->prefix}quiz_questions SET length = 0 WHERE qtype = '".DESCRIPTION."'");and start upgrading 1.4 -> 1.7 again (ie recover old 1.4 dbase from backup) I have followed this one, but it does not work...... Hope someone could fix it
Hide
Petr Škoda (skodak) added a comment -

The recommended upgrade step is 1.6.x->1.9.x, 1.7. is not maintained any more.

Thanks for the report.

Petr

Show
Petr Škoda (skodak) added a comment - The recommended upgrade step is 1.6.x->1.9.x, 1.7. is not maintained any more. Thanks for the report. Petr

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: