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

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

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • None
    • 2.0.1
    • Installation
    • 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

            markn Mark Nelson
            nicus Lorenzo Nicora
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

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