Hello everyone,
I have just upgraded my Moodle server to the latest versions from cvs on October 2nd 2008, also upgrading the none standard modules Game and ILP in the process. I downloaded the latest version of nWiki from DFWiki labs.
The only problem I have hit - and it is a complete show stopper at present, is that nWiki is failing to upgrade. The following errors are being presented and the upgrade is now stuck in a loop repeating the last error, so I have a useless Moodle installation.
Any ideas how to get my server back into action would be most useful.
I am running
Windows 2000, Apache 2.2.8, Postresql 8.2.10, PHP 5.2.5, Moodle 1.9.2
The errors are included below
Kind regards
Johnathan
Errors when upgrading nWiki on 2nd October 2008
(postgres7): UPDATE mdl_wiki SET evaluation_alter_column_tmp = CAST(CAST(evaluation AS TEXT) AS INTEGER)
--------------------------------------------------------------------------------
-1: ERROR: invalid input syntax for integer: "noeval"
ADOConnection._Execute(UPDATE mdl_wiki SET evaluation_alter_column_tmp = CAST(CAST(evaluation AS TEXT) AS INTEGER), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(UPDATE mdl_wiki SET evaluation_alter_column_tmp = CAST(CAST(evaluation AS TEXT) AS INTEGER)) % line 89, file: dmllib.php
execute_sql(UPDATE mdl_wiki SET evaluation_alter_column_tmp = CAST(CAST(evaluation AS TEXT) AS INTEGER), true) % line 2277, file: dmllib.php
execute_sql_arr(Array[6], true, true) % line 1127, file: ddllib.php
change_field_type(Object:XMLDBTable, Object:XMLDBField) % line 749, file: upgrade.php
--------------------------------------------------------------------------------
(postgres7): ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL
--------------------------------------------------------------------------------
-1: ERROR: column "evaluation" contains null values
ADOConnection._Execute(ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL) % line 89, file: dmllib.php
execute_sql(ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL, true) % line 2277, file: dmllib.php
execute_sql_arr(Array[6], true, true) % line 1127, file: ddllib.php
change_field_type(Object:XMLDBTable, Object:XMLDBField) % line 749, file: upgrade.php
Upgrading wiki from 2008040101 to 2008080401 FAILED!
(postgres7): ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL
--------------------------------------------------------------------------------
-1: ERROR: column "evaluation" contains null values
ADOConnection._Execute(ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL, false) % line 891, file: adodb.inc.php
ADOConnection.Execute(ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL) % line 89, file: dmllib.php
execute_sql(ALTER TABLE mdl_wiki ALTER COLUMN evaluation SET NOT NULL, true) % line 2277, file: dmllib.php
execute_sql_arr(Array[6], true, true) % line 1127, file: ddllib.php
change_field_type(Object:XMLDBTable, Object:XMLDBField) % line 749, file: upgrade.php
Upgrading wiki from 2008040101 to 2008080401 FAILED!