Any known problems with automatic publication of scheduled blogentries?

[hennb]

Hello,

in the last days we made our frist experiments with blog entries
having publication dates in the future. We had the expectation to see
these blog entries get published 'on their own' as soon as the
publication date is reached (this is what happens e.g. on
'blogger.com').

But this seems not to work like we expected. To make sure it is not a
problem with timezone settings or the like we waited 24 hours but
still nothing got published. Is this a known problem in v4.0.1 (did
not find any matching entry in the jira) or is there something further
to configure?

-Henning

[Ceri Davies]

On Mon, May 25, 2009 at 04:01:52PM +0200, Henning Brune wrote:

> Hello,
>
> in the last days we made our frist experiments with blog entries
> having publication dates in the future. We had the expectation to see
> these blog entries get published 'on their own' as soon as the
> publication date is reached (this is what happens e.g. on
> 'blogger.com').
>
> But this seems not to work like we expected. To make sure it is not a
> problem with timezone settings or the like we waited 24 hours but
> still nothing got published. Is this a known problem in v4.0.1 (did
> not find any matching entry in the jira) or is there something further
> to configure?

If you are using a database other than MySQL, this is almost certainly
https://issues.apache.org/jira/browse/ROL-1760

Ceri
--
That must be wonderful!  I don't understand it at all.
                                                  -- Moliere

[hennb]

Hello Ceri,

thanks for the hint. We are using Oracle.

I will try to follow the hints in the discussion and give a feedback.

Best regards,
Henning

On Mon, May 25, 2009 at 11:15 PM, Ceri Davies <ceri@...> wrote:

> On Mon, May 25, 2009 at 04:01:52PM +0200, Henning Brune wrote:
>> Hello,
>>
>> in the last days we made our frist experiments with blog entries
>> having publication dates in the future. We had the expectation to see
>> these blog entries get published 'on their own' as soon as the
>> publication date is reached (this is what happens e.g. on
>> 'blogger.com').
>>
>> But this seems not to work like we expected. To make sure it is not a
>> problem with timezone settings or the like we waited 24 hours but
>> still nothing got published. Is this a known problem in v4.0.1 (did
>> not find any matching entry in the jira) or is there something further
>> to configure?
>
> If you are using a database other than MySQL, this is almost certainly
> https://issues.apache.org/jira/browse/ROL-1760
>
> Ceri
> --
> That must be wonderful!  I don't understand it at all.
>                                                  -- Moliere
>

--
Dipl.-Inform. Henning Brune

http://ekvv.uni-bielefeld.de/pers_publ/publ/PersonDetail.jsp?personId=10185

Universität Bielefeld
Projekt BIS
Postfach 10 01 31
D-33501 Bielefeld

Die neue Homepage des BIS Projektes:
http://www.uni-bielefeld.de/bis/

[hennb]

Just to give a feedback: The solution Ceri describes in the JIRA:

https://issues.apache.org/jira/browse/ROL-1760

works for our Oracle 11 installation. I did the following steps:

* Clear attributes TIMEACQUIRED and LASTRUN in ROLLER_TASKLOCK with this:

update roller_tasklock set timeacquired = null;
update roller_tasklock set lastrun = null;

* Resized the attributes to TIMESTAMP(2) (I did it with SQL Developer)

Now the scheduled blog entries get published.

Thanks for the help,
Henning

On Mon, May 25, 2009 at 11:26 PM, Henning Brune
<henning.brune@...> wrote:

> Hello Ceri,
>
> thanks for the hint. We are using Oracle.
>
> I will try to follow the hints in the discussion and give a feedback.
>
> Best regards,
> Henning
>
> On Mon, May 25, 2009 at 11:15 PM, Ceri Davies <ceri@...> wrote:
>> On Mon, May 25, 2009 at 04:01:52PM +0200, Henning Brune wrote:
>>> Hello,
>>>
>>> in the last days we made our frist experiments with blog entries
>>> having publication dates in the future. We had the expectation to see
>>> these blog entries get published 'on their own' as soon as the
>>> publication date is reached (this is what happens e.g. on
>>> 'blogger.com').
>>>
>>> But this seems not to work like we expected. To make sure it is not a
>>> problem with timezone settings or the like we waited 24 hours but
>>> still nothing got published. Is this a known problem in v4.0.1 (did
>>> not find any matching entry in the jira) or is there something further
>>> to configure?
>>
>> If you are using a database other than MySQL, this is almost certainly
>> https://issues.apache.org/jira/browse/ROL-1760
>>
>> Ceri
>> --
>> That must be wonderful!  I don't understand it at all.
>>                                                  -- Moliere
>>
>
>
>
> --
> Dipl.-Inform. Henning Brune
>
> http://ekvv.uni-bielefeld.de/pers_publ/publ/PersonDetail.jsp?personId=10185
>
> Universität Bielefeld
> Projekt BIS
> Postfach 10 01 31
> D-33501 Bielefeld
>
> Die neue Homepage des BIS Projektes:
> http://www.uni-bielefeld.de/bis/
>

--
Dipl.-Inform. Henning Brune

http://ekvv.uni-bielefeld.de/pers_publ/publ/PersonDetail.jsp?personId=10185

Universität Bielefeld
Projekt BIS
Postfach 10 01 31
D-33501 Bielefeld

Die neue Homepage des BIS Projektes:
http://www.uni-bielefeld.de/bis/