Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-25893

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.1
    • Fix Version/s: None
    • Component/s: Installation
    • Labels:
    • Environment:
      DB Server: PostgreSQL 8.4.6 on x86_64-pc-linux-gnu
    • Database:
      PostgreSQL
    • Affected Branches:
      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 "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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                markn Mark Nelson
                Reporter:
                nicus Lorenzo Nicora
                Participants:
                Component watchers:
                Matteo Scaramuccia, Andrew Nicols, Mathew May, Michael Hawkins, Shamim Rezaie, Simey Lameze
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: