+1
On Tue, 2006-03-14 at 06:46, David M Johnson wrote:
> VOTE to make emergency bug fix release:
> Roller 2.1.1
> Roller 2.0.2
>
> Only code change in these releases: the 1.3 to 2.0 migration script
> Existing 2.1 and 2.0.1 releases have been pulled from site
>
> Background:
>
> Brian Blakely discovered that the 1.3 to 2.0 migration script that
> was included in the Roller 2.0.1 and Roller 2.1 releases resets the
> weblogentry pubtime and updatetime fields, effectively destroying all
> blog entries by setting their dates to the current time. Since this
> is an extremely serious problem, I have pulled the Roller 2.0.1 and
> Roller 2.0.1 releases from the Roller download site at Java.Net.
>
> Brian's bug report is here:
> http://opensource2.atlassian.com/projects/roller/browse/ROL-1081
>
> I have fixed this problem as described below, updated the CHANGES.txt
> files and created new releases Roller 2.0.2 and Roller 2.1.1 which
> are available at http://people.apache.org/~snoopdave/release_candidates
>
> The change are in these files:
> WEB-INF/dbscripts/hsqldb/130-200-migration.sql
> WEB-INF/dbscripts/mysql/130-200-migration.sql
> WEB-INF/dbscripts/postgresql/130-200-migration.sql
>
> These are the two changes:
>
> - alter table weblogentry alter userid set default '';
> + alter table weblogentry alter userid set default '',
> pubtime=pubtime, updatetime=updatetime;
>
> - update weblogentry set status='';
> + update weblogentry set status='', pubtime=pubtime,
> updatetime=updatetime;
>
>
> - Dave
