RE: Database Population problem with mysql
Not sure why this is failing; FWIW, according to the MySQL docs: "The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. " josh.
-----Original Message----- From: ram [mailto:talk2ram@gmail.com] Sent: 21 August 2007 16:29 To: FreeRadius users mailing list Cc: Josh Howlett Subject: Re: Database Population problem with mysql
On 8/21/07, Josh Howlett <Josh.Howlett@ja.net> wrote:
(42000) at line 15: Invalid default value for 'AcctStartTime'
Try using a valid value for this.
Hi
what is the correct value for that record
as per the document iam populating
iam using mysql
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
on debian
any suggestions
ram
On 8/21/07, Josh Howlett <Josh.Howlett@ja.net> wrote:
Not sure why this is failing; FWIW, according to the MySQL docs:
"The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. "
Hi thats what iam wondering and posted in the group why iam failing to populate the data which is compatable ram
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' On Aug 21, 2007, at 8:59 AM, ram wrote:
On 8/21/07, Josh Howlett <Josh.Howlett@ja.net> wrote: Not sure why this is failing; FWIW, according to the MySQL docs:
"The DATETIME type is used when you need values that contain both date and time information. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' format. The supported range is '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. "
Hi
thats what iam wondering and posted in the group why iam failing to populate the data which is compatable
ram
!DSPAM:1462,46cb0c6f301301263415243! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ users.html
!DSPAM:1462,46cb0c6f301301263415243!
-- Don
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
On 8/21/07, A.L.M.Buxey@lboro.ac.uk <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?
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 ram
On 8/21/07, A.L.M.Buxey@lboro.ac.uk <A.L.M.Buxey@lboro.ac.uk> wrote:
Hi,
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
hmm, what is your LOCALE? (and if you change the schema to default value of 1000-01-01 00:00:00 does it work
NO I have still the same problem any help ram
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
participants (4)
-
A.L.M.Buxey＠lboro.ac.uk -
Don Krause -
Josh Howlett -
ram