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

on upgrade - get error 'ip_address' cannot be null

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8, 1.9
    • Component/s: Installation
    • Labels:
      None
    • Affected Branches:
      MOODLE_18_STABLE
    • Fixed Branches:
      MOODLE_18_STABLE, MOODLE_19_STABLE

      Description

      get this errror when upgrading from version 1.6.4+ (2006050540) to 1.8 Beta + (2007021402)...

      --------------------------------------------------------------------------------
      (mysql): SELECT name FROM mdl_config WHERE name = 'mnet_dispatcher_mode' LIMIT 1
      --------------------------------------------------------------------------------

      --------------------------------------------------------------------------------
      (mysql): INSERT INTO mdl_config ( NAME, VALUE ) VALUES ( 'mnet_dispatcher_mode', 'off' )
      --------------------------------------------------------------------------------

      --------------------------------------------------------------------------------
      (mysql): SELECT LAST_INSERT_ID()
      --------------------------------------------------------------------------------

      --------------------------------------------------------------------------------
      (mysql): SELECT * FROM mdl_mnet_host WHERE id = '-1'
      --------------------------------------------------------------------------------

      --------------------------------------------------------------------------------
      (mysql): INSERT INTO mdl_mnet_host ( DELETED, WWWROOT, IP_ADDRESS, PUBLIC_KEY, PUBLIC_KEY_EXPIRES, LAST_CONNECT_TIME, LAST_LOG_ID ) VALUES ( 0, 'http://moodev/learn18', null, '', 0, 0, 0 )
      --------------------------------------------------------------------------------
      1048: Column 'ip_address' cannot be null

      ADOConnection._Execute(INSERT INTO mdl_mnet_host ( DELETED, WWWROOT, IP_ADDRESS, PUBLIC_KEY, PUBLIC_KEY_EXPIRES, LAST_CONNECT_TIME, LAST_LOG_ID ) VALUE..., false) % line 889, file: adodb.inc.php
      ADOConnection.Execute(INSERT INTO mdl_mnet_host ( DELETED, WWWROOT, IP_ADDRESS, PUBLIC_KEY, PUBLIC_KEY_EXPIRES, LAST_CONNECT_TIME, LAST_LOG_ID ) VALUE...) % line 1418, file: dmllib.php
      insert_record(mnet_host, Object:mnet_environment, true) % line 36, file: environment.php
      mnet_environment.init() % line 25, file: lib.php
      include_once(E:\learn18\mnet\lib.php) % line 312, file: upgrade.php

      --------------------------------------------------------------------------------
      (mysql): SELECT name FROM mdl_config WHERE name = 'mnet_localhost_id' LIMIT 1
      --------------------------------------------------------------------------------

      --------------------------------------------------------------------------------
      (mysql): INSERT INTO mdl_config ( NAME, VALUE ) VALUES ( 'mnet_localhost_id', '' )

        Attachments

          Activity

            People

            Assignee:
            donal@catalyst.net.nz Donal McMullan
            Reporter:
            danmarsden Dan Marsden
            Tester:
            Dan Marsden
            Participants:
            Component watchers:
            Matteo Scaramuccia, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              31/Mar/07