From: Bishop B. <ph...@id...> - 2008-01-10 00:35:18
|
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 |
From: Matthew G. <mat...@gm...> - 2008-01-11 18:05:39
|
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; > |
From: Bishop B. <ph...@id...> - 2008-01-11 18:08:13
|
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 |
From: Matthew G. <mat...@gm...> - 2008-01-11 18:19:52
|
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 > > > > > |
From: Bishop B. <ph...@id...> - 2008-01-11 18:37:56
Attachments:
build.xml
|
/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 |