That's what I get for thinking... I just tried that, ie: "create table test (dt datetime NOT NULL default '0000-00-00 00:00:00');" on mysql 3,4 and 5. No problems. At least not with 'C' or 'en_US' locales set. Sorry for wasting the bandwidth... On Aug 21, 2007, at 10:26 AM, A.L.M.Buxey@lboro.ac.uk wrote:
Hi,
I know I'm a newb here, and I'm not a Mysql expert, but it looks to me like '0000-00-00 00:00:00" is clearly outside the allowed range, if that range is published as '1000-01-01 00:00:00' - '9999-12-31 23:59:59'
just what i was thinking - but its worked until now ..hang on...
nope. even 2.0 CVS has all 0's (though as you say...maybe it shouldnt) though 2.0 now doesnt CapiTaliZe the variables.
what version of mysql are you running? 3.x or 4.x might be very fussy?
alan - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ users.html
!DSPAM:1462,46cb20bc202631603212334!
-- Don