-
Bug
-
Resolution: Fixed
-
Major
-
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 "lastip" contains null v alues
ALTER TABLE srd_user ALTER COLUMN lastip 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 1055 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()
Co
- 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