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

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

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;

-- 
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