Moodle

nwiki upgrade fails

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Critical Critical
  • Resolution: Unresolved
  • Affects Version/s: 1.9.2
  • Fix Version/s: None
  • Component/s: Wiki (1.x)
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE

Description

I get this error:

(mysql): SHOW TABLES (mysql): ALTER TABLE mdl_wiki MODIFY COLUMN evaluation SMALLINT(3) unsigned NOT NULL DEFAULT 0 after studentdiscussion 1054: Unknown column 'evaluation' in 'mdl_wiki'

ADOConnection._Execute(ALTER TABLE mdl_wiki MODIFY COLUMN evaluation SMALLINT(3) unsigned NOT NULL DEFAULT 0 after studentdiscussion, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE mdl_wiki MODIFY COLUMN evaluation SMALLINT(3) unsigned NOT NULL DEFAULT 0 after studentdiscussion) % line 89, file: dmllib.php
execute_sql(ALTER TABLE mdl_wiki MODIFY COLUMN evaluation SMALLINT(3) unsigned NOT NULL DEFAULT 0 after studentdiscussion, true) % line 2277, file: dmllib.php
execute_sql_arr(Array[1], true, true) % line 1127, file: ddllib.php
change_field_type(Object:XMLDBTable, Object:XMLDBField) % line 749, file: upgrade.php

ErrorScroll to next warning
Scroll to previous warningUpgrading wiki from 2008040101 to 2008080401 FAILED!Scroll to continue button

Upgrade now sticks there and goes back to the same screen whatever I do.

Activity

Hide
Matt Gibson added a comment -

I tried deleting the mod/wiki folder, but this led to an error saying that upgrade is already running in this session. Restarting the webserver gets me a front page that stalls when it comes to rendering the admin block. Its only by replacing the original wiki (version 2008040101) that I can use the site.

Show
Matt Gibson added a comment - I tried deleting the mod/wiki folder, but this led to an error saying that upgrade is already running in this session. Restarting the webserver gets me a front page that stalls when it comes to rendering the admin block. Its only by replacing the original wiki (version 2008040101) that I can use the site.
Hide
Matt Gibson added a comment -

Found that there was a problem with the install and that some tables were missing. Fixed by reinstalling the whole module (fortunately, it was not being used this year yet)

Show
Matt Gibson added a comment - Found that there was a problem with the install and that some tables were missing. Fixed by reinstalling the whole module (fortunately, it was not being used this year yet)
Hide
Nadav Kavalerchik added a comment -

a week ago we had the same issue when upgrading a clean moodle 1.9.4 install
which was installed on top of a windows server + MSsql service.

adding the "evaluation" column (db field) "solved" the issue.

later, i suggested we move to gnu/linux...

and upgrading a second server (in the same institute) which was a clean install
of the same moodle 1.9.4 version on top of gnu/linux CentOS 5.2 + MySQL 5.2
worked just fine

Show
Nadav Kavalerchik added a comment - a week ago we had the same issue when upgrading a clean moodle 1.9.4 install which was installed on top of a windows server + MSsql service. adding the "evaluation" column (db field) "solved" the issue. later, i suggested we move to gnu/linux... and upgrading a second server (in the same institute) which was a clean install of the same moodle 1.9.4 version on top of gnu/linux CentOS 5.2 + MySQL 5.2 worked just fine
Hide
Ludo ( Marc Alier) added a comment -

li pots fer una ullada a aquest bug?

Show
Ludo ( Marc Alier) added a comment - li pots fer una ullada a aquest bug?

People

Vote (1)
Watch (0)

Dates

  • Created:
    Updated: