Issue Details (XML | Word | Printable)

Key: MDL-7596
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Martin Dougiamas
Reporter: Arthur Manning
Votes: 2
Watchers: 3
Operations

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

Fatal errors upgrading from 1.6.3 to 1.7

Created: 17/Nov/06 01:06 PM   Updated: 06/Jan/07 01:55 AM
Return to search
Component/s: Installation
Affects Version/s: 1.7
Fix Version/s: None

Environment:
mysql database mysql version 4.1.16 is required and you are running 5.0.22 OK
php version 4.3.0 is required and you are running 5.1.6

URL: http://media.emmaus.edu/upg_20061116-1735.html (the full log output)
Participants: Arthur Manning, Dirk Grunwald, Martin Dougiamas and Steven Roberts
Security Level: None
Affected Branches: MOODLE_17_STABLE


 Description  « Hide
Upgrading Moodle database from version 1.6.3 (2006050530) to 1.7 (2006101007)...

after many 'success' messages

...
some that make me nervous:


(mysql): UPDATE mdl_modules SET visible = '0' WHERE name = 'lams'
Processing role assignments (1/165) Ending: 5 mins 28 secs
Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

Capability "mod/forum:viewdiscussion" was not found! This should be fixed in code.

..

but then came the warnings, but stopped the install errors: (page waited to load for about 1 hour after I finally stopped mysqld)

Warning: array_flip() [function.array-flip]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 269

Warning: array_change_key_case() [function.array-change-key-case]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 270

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 271
Error


Warning: array_flip() [function.array-flip]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 269

Warning: array_change_key_case() [function.array-change-key-case]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 270

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 271

Warning: array_flip() [function.array-flip]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 269

Warning: array_change_key_case() [function.array-change-key-case]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 270

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 271

Warning: array_flip() [function.array-flip]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 269

Warning: array_change_key_case() [function.array-change-key-case]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 270

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 271

Warning: array_flip() [function.array-flip]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 269

Warning: array_change_key_case() [function.array-change-key-case]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 270

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 271

Warning: array_flip() [function.array-flip]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 269

Warning: array_change_key_case() [function.array-change-key-case]: The argument should be an array in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 270

Warning: array_key_exists() [function.array-key-exists]: The second argument should be either an array or an object in /var/www/moodle/moodle-1.7/lib/ddllib.php on line 271
Error




After restarting mysqld and httpd, I had a broken system. Good thing I backed up the database first!!!
This is a small system and yet the mysqldump file was HUGE! 6 Gb!!!

 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
[ Permalink | « Hide ]
Steven Roberts added a comment - 30/Nov/06 10:36 PM
We are having a simular problem please see below. The upgrade stops at Processing role assignments.
This is the output when we drop the mdl_lams table

Upgrading Moodle Database from Version 1.6.3 (2006050530) To 1.7 (2006101007)

(mysql): SELECT COUNT FROM mdl_lams
________________________________________
1146: Table 'moodle16to17.mdl_lams' doesn't exist

adodb_mysql._execute(SELECT COUNT FROM mdl_lams , false) % line 889, file: adodb.inc.php
adodb_mysql.execute(SELECT COUNT FROM mdl_lams ) % line 651, file: dmllib.php
get_recordset_sql(SELECT COUNT FROM mdl_lams ) % line 354, file: dmllib.php
count_records_sql(SELECT COUNT FROM mdl_lams ) % line 317, file: dmllib.php
count_records(lams) % line 54, file: upgrade.php
________________________________________
(mysql): UPDATE mdl_modules SET visible = '0' WHERE name = 'lams'
________________________________________
Processing role assignments (43/26340) Ending: 2 days

This is the output when we do not drop the mdl_lams table

Upgrading Moodle Database from Version 1.6.3 (2006050530) To 1.7 (2006101007)

(mysql): SELECT COUNT FROM mdl_lams
________________________________________
(mysql): UPDATE mdl_modules SET visible = '0' WHERE name = 'lams'
________________________________________
Processing role assignments (43/26340) Ending: 2 days


[ Permalink | « Hide ]
Dirk Grunwald added a comment - 06/Jan/07 01:48 AM
I tried to upgrade a system from non-UTF8 1.6.2 to 1.7. I also tried this after converting to UTF8 with the same results. I was upgrading to the 1.7-cvs version.

During the upgrade, there were some messages about a capability in "forum/view" not being in the database & needing to fix the code (I didn't cut and paste it, sorry). This was in the "role upgrade" section of the upgrade, if I recall.

Following the upgrade, when I log in as 'admin', I'm told that the site is still in maintenance mode. There is no administration menu. If I navigate to a class and then use the 'roles' interface there to add admin as an administrator, I can rummage around the site a little.

There were also problems of users not being able to access classes and also mail I posted to a forum was sent to people who were not subscribed for that class.

This is fairly repeatable starting with the particular mysql dump. I've looked at other descriptions and don't see similar problems. I'm more than happy to ship my 100MB mysql dump to someone who wants to try to figure out what might be up.

This sounds like problem report http://tracker.moodle.org/browse/MDL-7596 with some differences. Again, I'm more than happy to provide the full mysql DB.

All of this is on an up-to-date RHEL 4 system.


[ Permalink | « Hide ]
Dirk Grunwald added a comment - 06/Jan/07 01:55 AM
Actually, turns out the DB is 10MB when compressed. Again, I'm glad to provide it to someone who wants to debug this show-stopper.


Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.5-#360) - Bug/feature request - Atlassian news - Contact Administrators