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 <[email protected]> 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 <[email protected]> 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/
