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

[Bishop B. <ph...@id...>]

/me says... We use phing for our build manager, and it has a nice =20
DbDeploy task
http://phing.info/docs/guide/current/chapters/appendixes/AppendixC-OptionalT=
asks.html#DbDeployTask

All you have to do is write delta-set files, and the Phing task will =20
figure out your current database level and apply all the unapplied =20
patches.  It's very effective.

I've got a Phing build file (build.xml) for my local development =20
(moves things around for web deployment, lints my changes, runs some =20
smoke tests), which I've attached for reference.  It doesn't do =20
DbDeploy (as that's not the project standard), but it's something you =20
might consider.

bishop

Quoting Matthew Gregg <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.
>> >  =20
>> http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketpl=
ace
>> > _______________________________________________
>> > phpESP-devel mailing list
>> > php...@li...
>> > https://lists.sourceforge.net/lists/listinfo/phpesp-devel
>> >
>>
>>
>>
>
>



--=20
Bishop Bettini
ideacode, Inc.
(main) +1 919 341 5170 / (fax) +1 919 521 4100

Visit us on the web at:
ideacode.com          Professional software research and development
reviewmysoftware.com  Improve sales! Review your software before you release
bytejar.com           Solutions to those annoying development problems