[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