Issue Details (XML | Word | Printable)

Key: MDL-8032
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Martin Dougiamas
Reporter: Roy Cabaniss
Votes: 0
Watchers: 1
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

1.7 install / upgrade hang up at quiz

Created: 01/Jan/07 01:57 PM   Updated: 10/Jan/07 06:49 PM
Component/s: Installation
Affects Version/s: 1.7
Fix Version/s: None

Environment:
Home computer Linux Suse 10.2, AMD 64, 2 gig ram
Work computer Linux Suse 10.1, Intel 1700, 512 meg ram

Database: PostgreSQL
URL: http://cabanisspc.uamont.edu/osca/moodle
Participants: dboy, Martin Dougiamas and Roy Cabaniss
Security Level: None
Affected Branches: MOODLE_17_STABLE


 Description  « Hide
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?



 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
dboy added a comment - 10/Jan/07 06:49 PM
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