[kronolith] error in your SQL syntax near 'NOW() NOT NULL

[Jan Schneider]

Zitat von Martin List-Petersen <martin@list-petersen.dk>:

> <-snip->
> > >  ERROR 1064: You have an error in your SQL syntax near 'NOW() NOT
> NULL,
> > >      event_end datetime DEFAULT NOW() NOT NULL,
> > >      event_alarm i' at line 13
> > >  mysql>
> >
> > We're still trying to find cross database compatible sql statements.
> No
> > luck! :-/
> > Remove the DEFAULT NOW() part or replace it with DEFAULT '0000-00-00
> > 00:00:00'
> >
> 
> <-snip->
> 
> Why not just forget the DEFAULT in this case, which should be ok for
> most
> sql servers and handle it from the PHP code (allways putting the right
> values in the fields).

This is probably the best solution, but programmers are lazy, you know? ;-)

Jan.

::::::::::::::::::::::::::::::::::::::::
AMMMa AG - discover your knowledge
:::::::::::::::::::::::::::
Detmolder Str. 25-33 :: D-33604 Bielefeld
fon +49.521.96878-0 :: fax  +49.521.96878-20
http://www.ammma.de
::::::::::::::::::::::::::::::::::::::::::::::