Moodle

Fatal errors upgrading from 1.6.3 to 1.7

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:
    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

Description

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!!!

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Steven Roberts added a comment -

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

Show
Steven Roberts added a comment - 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
Hide
Permalink
Dirk Grunwald added a comment -

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.

Show
Dirk Grunwald added a comment - 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.
Hide
Permalink
Dirk Grunwald added a comment -

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.

Show
Dirk Grunwald added a comment - 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.
Hide
Permalink
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 (2)
Watch (3)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.