Re: [phpesp-dev] ip column addition missing from 1.8.2 to 2.0.2 database upgrade

[Matthew G. <mat...@gm...>]

In version 2.0.2 see this in mysql_populate:
CREATE TABLE response (
  id              INT UNSIGNED NOT NULL AUTO_INCREMENT,
  survey_id       INT UNSIGNED NOT NULL,
  submitted       TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  complete        ENUM('Y','N') NOT NULL DEFAULT 'N',
  username        CHAR(64),
  ip              CHAR(64),<- IP is here
  PRIMARY KEY (id),
  KEY `survey_id` (`survey_id`)
);

The IP field is included.  Wonder how yours was missing?



On Wed, 2008-01-09 at 19:35 -0500, Bishop Bettini wrote:
> REPRODUCTION:
> Starting from a 1.8.2 install, apply the following patches from 2.0.2 release:
> 
> mysql_update-1.8.2h-1.8.2i.sql
> mysql_update-1.8.2k-2.0.0.sql
> 
> Then, create a survey, activate it, then take it.  With debugging  
> engaged, the following occurs:
> Request failed, please contact the administrator.[ 1054: Unknown  
> column 'ip' in 'field list' ]
> 
> EXPECTED:
> The survey should save, and no error message should be emitted
> 
> FIX:
> Very simple. Execute this in MySQL client:
> ALTER TABLE response ADD COLUMN ip CHAR(64) AFTER username;
>