JRoller.com upgraded to 2.0 a while ago and used the 2.0 code base to
do the upgrade (not 2.0.1), so they did not experience this problem.
This problem should have only affected those upgrading from 1.3
directly to 2.0.1 or 2.1.
- Dave
On Mar 14, 2006, at 11:51 AM, Matt Raible wrote:
+1. I don't know if this is related, but a recent upgrade at JRoller
seems to have altered post times - and hence permalinks - as well.
I tried to look up the bug number in jira.javalobby.org, but it's not
responding.
Matt
On 3/11/06, Elias Torres <[EMAIL PROTECTED]> wrote:
-----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-----
