Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-34086 META: Increase robustness of upgrade from 1.9 to 2.2
  3. MDL-25894

Upgrade 1.9.x -> 2.0 fails: column "city " contains null values

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Duplicate
    • Blocker
    • None
    • 2.0.1
    • Installation
    • DB Server: PostgreSQL 8.4.6 on x86_64-pc-linux-gnu
    • PostgreSQL
    • MOODLE_20_STABLE

    Description

      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()

      Attachments

        Issue Links

          Activity

            People

              nebgor Aparup Banerjee
              nicus Lorenzo Nicora
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Clockify

                  Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.