You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Elias Torres <el...@torrez.us> on 2006/03/11 08:09:58 UTC
Re: VOTE: emergency releases to fix ROL-1081
-----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-----
Re: VOTE: emergency releases to fix ROL-1081
Posted by Dave Johnson <da...@rollerweblogger.org>.
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 <el...@torrez.us> 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-----
>>
RE: VOTE: emergency releases to fix ROL-1081
Posted by Matthew Schmidt <ma...@javalobby.org>.
Yea, we had a similar problem with a few different tables. I caught it
before the upgrade and set pubtime to creationdate or something similar
which was fine for most users.
-Matt
-----Original Message-----
From: Matt Raible [mailto:mraible@gmail.com]
Sent: Tuesday, March 14, 2006 11:52 AM
To: roller-dev@incubator.apache.org
Subject: Re: VOTE: emergency releases to fix ROL-1081
+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 <el...@torrez.us> 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-----
>
Re: VOTE: emergency releases to fix ROL-1081
Posted by Matt Raible <mr...@gmail.com>.
+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 <el...@torrez.us> 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-----
>