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

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

ahhK... Will update the "update" script to include adding that field.

/me longs for Rails migrations.....

On Fri, 2008-01-11 at 13:08 -0500, Bishop Bettini wrote:
> Matthew, I was upgrading from 1.8.2, not creating from new.  Thus, I  
> only ran the upgrade scripts.  Anyone upgrading would have this issue.  
>   The bug is that the upgrade scripts did not create the ip column.   
> The fix was the simple ALTER TABLE given below.
> 
> bishop
> 
> Quoting Matthew Gregg <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;
> >>
> >
> >
> > -------------------------------------------------------------------------
> > Check out the new SourceForge.net Marketplace.
> > It's the best place to buy or sell services for
> > just about anything Open Source.
> > http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
> > _______________________________________________
> > phpESP-devel mailing list
> > php...@li...
> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel
> >
> 
> 
>