Column 'remote_addr' is used with UNIQUE or INDEX but is not defined as NOT NULL

Discussion in 'Installation' started by beenet, Dec 24, 2004.

  1. beenet

    beenet aMember Pro Customer

    Joined:
    Dec 24, 2004
    Messages:
    11
    I'm getting the following error when trying to run the setup.php:

    Column 'remote_addr' is used with UNIQUE or INDEX but is not defined as NOT NULL SQL:

    So, I manually changed the following line:

    remote_addr varchar(15) default NULL,

    to

    remote_addr varchar(15) NOT NULL,

    This fixed the error, but there seemed to be more similiar errors. Am I doing something wrong???

    My server is running MySQL 3.22.32

    Thanks.
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    MySQL 3.23 is required. Please upgrade if possible.

Share This Page