I thought current_date/current_timestamp was the standard solution to this problem. I know that's the 'new' way to do it in Oracle, I thought other dbs supported it too but unsure.
Hen On 10/26/06, Anil Gangolli <[EMAIL PROTECTED]> wrote:
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 >
