[kronolith] error in your SQL syntax near 'NOW() NOT NULL
Jon Parise
jon@horde.org
Mon, 10 Dec 2001 12:50:06 -0500
On Mon, Dec 10, 2001 at 02:16:42PM -0500, Paul Cooper wrote:
> Well AFAICT the code never actually assumes or uses the default, it
> always populates the date fields, so there :-P Anyway since 0000-00-00
> 00:00:00 is an invalid date postgres won't accept it as a default. Either
> we should change it to a valid date 0000-01-01 00:00:00 or leave it out
> all together.
Leave it out and make sure the PHP code always populates that
field with a reasonable value.
--
Jon Parise (jon@csh.rit.edu) . Information Technology (2001)
http://www.csh.rit.edu/~jon/ : Computer Science House Member