If now() is a MySQL function, you'll need a macro that works across the
different databases; for Oracle it's SYSDATE.
We might want to fix this in code.
--a.
----- Original Message -----
From: "Dave" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[email protected]>
Sent: Tuesday, October 24, 2006 7:06 AM
Subject: Re: VOTE: Release Apache Roller (incubating) 3.0
On 10/23/06, Dave <[EMAIL PROTECTED]> wrote:
The problem:
java.lang.NullPointerException
org.apache.roller.ui.rendering.servlets.PageServlet.doGet(PageServlet.java:168)
Looks like a 3.0 bug, your website is has a null lastmodified date.
You can work around the problem by setting lastmodified date to some
non null value, perhaps now() would work.
The root problem is that we create the new lastmodified column with
default to null.
alter table website add column lastmodified $TIMESTAMP_SQL_TYPE default
null;
What we ought to do is to set the default to now() like so:
alter table website add column lastmodified $TIMESTAMP_SQL_TYPE default
now();
So we need an RC5. Does anybody else have Roller 3.0 RC4 feedback?
- Dave