Database Population problem with mysql

[Don Krause]

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 at 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