-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 +1
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 > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFEEnfGtsNTCOFcV0oRAmVuAJ4yiRE4u2ifSrjfccnLeLA9FOv6WwCggKxB zRXgAnAs6LZt2uGfOxpF5tg= =j2UV -----END PGP SIGNATURE-----
