You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@roller.apache.org by Dave <sn...@gmail.com> on 2007/09/21 15:54:10 UTC
Apache Roller 4.0 RC3 is available for testing
Thanks to Matthew Mongomery, Jonathan Chen, Peter Petersson and Matt
Raible for help with testing and fixing the following three issues:
http://opensource.atlassian.com/projects/roller/browse/ROL-1569
Bad characters in PostgreSQL database creation script
http://opensource.atlassian.com/projects/roller/browse/ROL-1567
Problems creating and deleting blogs
http://opensource.atlassian.com/projects/roller/browse/ROL-1568
Trailing spaces in user guide + cut and paste = trouble
The new release candidate files are here:
http://people.apache.org/~snoopdave/apache-roller-4.0-rc3/
Please try it out. Unless critical issues are found I will call for a
release vote on Monday.
- Dave
Re: Apache Roller 4.0 RC3 is available for testing
Posted by Dave <sn...@gmail.com>.
On 9/30/07, Yossie <yo...@yossieworld.com> wrote:
> Sorry, my explanation was poor. I mean,
> for example,
> in http://rollerweblogger.org/roller/date/20070918,
> #showNextPrevEntriesControl($pager) says
> "Main | Next day (Sep 19, 2007) »".
>
> But I'd like to have a following result.
> "« Previous day (Sep 17, 2007) | Main | Next day (Sep 19, 2007) »".
> At least, I can have it in 3.11.
Now I understand. Thanks Yossie san!
The problem is that the 4.0 database migration script was resetting
the website.datecreated because it did not explicitly set the
datecreated field in this update:
update website set enablemultilang=1 where showalllangs=0;
So I changed it to that:
update website set enablemultilang=1, datecreated=datecreated where
showalllangs=0;
That will ensure that those who upgrade to 4.0 will not get this problem.
For your installation: if you set your website.datecreated values to
the correct value you should see this but go away.
- Dave
Re: Apache Roller 4.0 RC3 is available for testing
Posted by Yossie <yo...@yossieworld.com>.
Hello Dave san,
> On 9/25/07, Dave <sn...@gmail.com> wrote:
>> On 9/22/07, YOSHIDA Satoshi <yo...@yossieworld.com> wrote:
>>> I have upgraded my roller from 3.11rc3 to 4.0 rc3 on Apache Tomcat
>>> 6.0.14 and MySQL 5.0.45.
>>>
>>> issue 1:
>>> After upgrade, the values of [posttime] in all entries in
>>> [roller_comment] table have been changed to the upgrade time. This
>>> trouble occurs in both 'auto' installation and 'manual' installation.
>
> I can't duplicate this problem. There is a bug in the upgrade script
> that prevented me from upgading from 3.1.1 to 4.0.
>
> Once I fixed that bug I was able to upgrade and the dates of the
> comments are preserved (I'm testing with MySQL 5.0.22).
>
> I also checked the places where we update the comments table in the
> 3.1.1 to 4.0 migration script and they all do the right thing for
> preserving the posttime.
Thank you for your checking. I got your result.
But I don't figure out why I have this issue.
So I'll test again. I will reinstall roller 3.11, create new blog, post
several entries, post comments, and then upgrade it to 4.0.
>>> issue 2:
>>> As the result of #showNextPrevEntriesControl($pager) in URLs like
>>> /username/date/YYYYMM or YYYYMMDD,
>>> Previous month or day links never come out.
>>> (Only Next month or day links come out.)
>>> You can make sure this issue in
>>> http://rollerweblogger.org/project/date/20070820 or
>>> http://rollerweblogger.org/project/date/200708.
>>>
>>> Is this a spec or bug?
>
> This is by design. The day pager returns day links the month pager
> returns month links.
Sorry, my explanation was poor. I mean,
for example,
in http://rollerweblogger.org/roller/date/20070918,
#showNextPrevEntriesControl($pager) says
"Main | Next day (Sep 19, 2007) »".
But I'd like to have a following result.
"« Previous day (Sep 17, 2007) | Main | Next day (Sep 19, 2007) »".
At least, I can have it in 3.11.
In http://rollerweblogger.org/roller/date/200708,
#showNextPrevEntriesControl($pager) says
"Main | Next month (Sep 2007) »".
But I'd like to have a following result.
"« Previous month (Jul 2007) | Main | Next month (Sep 2007) »".
Thank you for your help.
Yossie
Re: Apache Roller 4.0 RC3 is available for testing
Posted by Yossie <yo...@yossieworld.com>.
> On 9/25/07, Dave <sn...@gmail.com> wrote:
>> On 9/22/07, YOSHIDA Satoshi <yo...@yossieworld.com> wrote:
>>> I have upgraded my roller from 3.11rc3 to 4.0 rc3 on Apache Tomcat
>>> 6.0.14 and MySQL 5.0.45.
>>>
>>> issue 1:
>>> After upgrade, the values of [posttime] in all entries in
>>> [roller_comment] table have been changed to the upgrade time. This
>>> trouble occurs in both 'auto' installation and 'manual' installation.
>
> I can't duplicate this problem. There is a bug in the upgrade script
> that prevented me from upgading from 3.1.1 to 4.0.
>
> Once I fixed that bug I was able to upgrade and the dates of the
> comments are preserved (I'm testing with MySQL 5.0.22).
>
> I also checked the places where we update the comments table in the
> 3.1.1 to 4.0 migration script and they all do the right thing for
> preserving the posttime.
I found out the cause of issue 1.
roller_comment.posttime should be defined as 'datetime not null'.
But my roller_comment.posttime was defined as 'timestamp NOT NULL
default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP'.
My Roller DB was created when I was using Roller 2.02.
In Roller 2.02, roller_comment.posttime was defined as 'timestamp not
null' with createdb.sql of 2.02.
I am wondering when it changed to such definition...
Anyway, so roller_comment.posttime was automatically set to
CURRENT_TIMESTAMP when
"update roller_comment set contenttype = "text/html"" and
"update roller_comment set plugins = "HTMLSubset,AutoFormat""
were executed by DatabaseInstaller.
The other columns except roller_comment.posttime were also defined
incorrectly. I corrected them with the following script.
alter table rolleruser modify datecreated datetime NOT NULL;
alter table roller_audit_log modify change_time datetime;
alter table usercookie modify datecreated datetime NOT NULL;
alter table webpage modify updatetime datetime NOT NULL;
alter table website modify datecreated datetime NOT NULL;
alter table weblogentry modify updatetime datetime NOT NULL;
alter table roller_comment modify posttime datetime NOT NULL;
alter table pingtarget modify lastsuccess datetime;
alter table pingqueueentry modify entrytime datetime NOT NULL;
alter table referer modify reftime datetime;
alter table rag_subscription modify last_updated datetime;
Thanks,
Yossie
Re: Apache Roller 4.0 RC3 is available for testing
Posted by Dave <sn...@gmail.com>.
On 9/25/07, Dave <sn...@gmail.com> wrote:
> On 9/22/07, YOSHIDA Satoshi <yo...@yossieworld.com> wrote:
> > I have upgraded my roller from 3.11rc3 to 4.0 rc3 on Apache Tomcat
> > 6.0.14 and MySQL 5.0.45.
> >
> > issue 1:
> > After upgrade, the values of [posttime] in all entries in
> > [roller_comment] table have been changed to the upgrade time. This
> > trouble occurs in both 'auto' installation and 'manual' installation.
I can't duplicate this problem. There is a bug in the upgrade script
that prevented me from upgading from 3.1.1 to 4.0.
Once I fixed that bug I was able to upgrade and the dates of the
comments are preserved (I'm testing with MySQL 5.0.22).
I also checked the places where we update the comments table in the
3.1.1 to 4.0 migration script and they all do the right thing for
preserving the posttime.
> > issue 2:
> > As the result of #showNextPrevEntriesControl($pager) in URLs like
> > /username/date/YYYYMM or YYYYMMDD,
> > Previous month or day links never come out.
> > (Only Next month or day links come out.)
> > You can make sure this issue in
> > http://rollerweblogger.org/project/date/20070820 or
> > http://rollerweblogger.org/project/date/200708.
> >
> > Is this a spec or bug?
This is by design. The day pager returns day links the month pager
returns month links.
- Dave
Re: Apache Roller 4.0 RC3 is available for testing
Posted by Dave <sn...@gmail.com>.
On 9/22/07, YOSHIDA Satoshi <yo...@yossieworld.com> wrote:
> I have upgraded my roller from 3.11rc3 to 4.0 rc3 on Apache Tomcat
> 6.0.14 and MySQL 5.0.45.
>
> issue 1:
> After upgrade, the values of [posttime] in all entries in
> [roller_comment] table have been changed to the upgrade time. This
> trouble occurs in both 'auto' installation and 'manual' installation.
>
> issue 2:
> As the result of #showNextPrevEntriesControl($pager) in URLs like
> /username/date/YYYYMM or YYYYMMDD,
> Previous month or day links never come out.
> (Only Next month or day links come out.)
> You can make sure this issue in
> http://rollerweblogger.org/project/date/20070820 or
> http://rollerweblogger.org/project/date/200708.
>
> Is this a spec or bug?
> I need a Previous link like Ver.3.11.
Thanks Yossie, item #1 looks like a critical problem. I hope to have
time to look into it this week
- Dave
Re: Apache Roller 4.0 RC3 is available for testing
Posted by YOSHIDA Satoshi <yo...@yossieworld.com>.
I have upgraded my roller from 3.11rc3 to 4.0 rc3 on Apache Tomcat
6.0.14 and MySQL 5.0.45.
issue 1:
After upgrade, the values of [posttime] in all entries in
[roller_comment] table have been changed to the upgrade time. This
trouble occurs in both 'auto' installation and 'manual' installation.
issue 2:
As the result of #showNextPrevEntriesControl($pager) in URLs like
/username/date/YYYYMM or YYYYMMDD,
Previous month or day links never come out.
(Only Next month or day links come out.)
You can make sure this issue in
http://rollerweblogger.org/project/date/20070820 or
http://rollerweblogger.org/project/date/200708.
Is this a spec or bug?
I need a Previous link like Ver.3.11.
Thanks,
Yossie
> Thanks to Matthew Mongomery, Jonathan Chen, Peter Petersson and Matt
> Raible for help with testing and fixing the following three issues:
>
> http://opensource.atlassian.com/projects/roller/browse/ROL-1569
> Bad characters in PostgreSQL database creation script
>
> http://opensource.atlassian.com/projects/roller/browse/ROL-1567
> Problems creating and deleting blogs
>
> http://opensource.atlassian.com/projects/roller/browse/ROL-1568
> Trailing spaces in user guide + cut and paste = trouble
>
>
> The new release candidate files are here:
> http://people.apache.org/~snoopdave/apache-roller-4.0-rc3/
>
> Please try it out. Unless critical issues are found I will call for a
> release vote on Monday.
>
> - Dave
>
>
>