-
Sub-task
-
Resolution: Duplicate
-
Blocker
-
None
-
2.0.1
-
DB Server: PostgreSQL 8.4.6 on x86_64-pc-linux-gnu
-
PostgreSQL
-
MOODLE_20_STABLE
Upgrading from 1.9.9 (Build: 20100609) to 2.0.1 (Build: 20101229), with PostgreSQL db, causes the following error and upgrade process stops.
------------------------------------------------------------
Debug info: ERROR: column "city " contains null v alues
ALTER TABLE srd_user ALTER COLUMN city SET NOT NULL
Stack trace:
line 397 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
line 229 of /lib/dml/pgsql_nativ e_moodle_database.php: call to moodle_database->query _end()
line 570 of /lib/dml/pgsql_nativ e_moodle_database.php: call to pgsql_nativ e_moodle_database->query _end()
line 88 of /lib/ddl/database_manager.php: call to pgsql_nativ e_moodle_database->change_database_structure()
line 75 of /lib/ddl/database_manager.php: call to database_manager->execute_sql()
line 636 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
line 648 of /lib/ddl/database_manager.php: call to database_manager->change_f ield_ty pe()
line 4727 of /lib/db/upgrade.php: call to database_manager->change_f ield_precision()
line 1309 of /lib/upgradelib.php: call to xmldb_main_upgrade()
line 252 of /admin/index.php: call to upgrade_core()
- will be (partly) resolved by
-
MDL-25948 Sites using 1.9.x, but originally installed with < 1.7, fail upgrading to 2.0 due to null fields in mdl_user table
-
- Closed
-