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

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

Matthew, I was upgrading from 1.8.2, not creating from new.  Thus, I =20
only ran the upgrade scripts.  Anyone upgrading would have this issue. =20
  The bug is that the upgrade scripts did not create the ip column.  =20
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  =20
>> 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/marketpla=
ce
> _______________________________________________
> 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