On 8/21/07, [EMAIL PROTECTED] [EMAIL PROTECTED] 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
Hi
iam trying to populate mysql datatabase
iam getting following error
any suggstions
mysql -u root -ppassword radius mysql.sql
ERROR 1067 (42000) at line 15: Invalid default value for 'AcctStartTime'
line 15 looks like below
AcctStartTime datetime NOT NULL default '-00-00 00:00:00',
(42000) at line 15: Invalid default value for 'AcctStartTime'
Try using a valid value for this.
josh.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
On 8/21/07, Josh Howlett [EMAIL PROTECTED] 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
Post mysql.sql to the list.
josh.
-Original Message-
From: ram [mailto:[EMAIL PROTECTED]
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 [EMAIL PROTECTED] wrote
On 8/21/07, Josh Howlett [EMAIL PROTECTED] wrote:
Post mysql.sql to the list.
###
# db_mysql.sql rlm_sql - FreeRADIUS SQL Module #
#
:59:59'.
josh.
-Original Message-
From: ram [mailto:[EMAIL PROTECTED]
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 [EMAIL PROTECTED] wrote:
(42000
I know I'm a newb here, and I'm not a Mysql expert, but it looks to
me like '-00-00 00:00:00 is clearly outside the allowed range,
if that range is published as '1000-01-01 00:00:00' - '-12-31
23:59:59'
On Aug 21, 2007, at 8:59 AM, ram wrote:
On 8/21/07, Josh Howlett [EMAIL
On 8/21/07, Josh Howlett [EMAIL PROTECTED] 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
'-MM-DD HH:MM:SS' format. The
Hi,
I know I'm a newb here, and I'm not a Mysql expert, but it looks to
me like '-00-00 00:00:00 is clearly outside the allowed range,
if that range is published as '1000-01-01 00:00:00' - '-12-31
23:59:59'
just what i was thinking - but its worked until now ..hang on...
nope.
On 8/21/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi,
I know I'm a newb here, and I'm not a Mysql expert, but it looks to
me like '-00-00 00:00:00 is clearly outside the allowed range,
if that range is published as '1000-01-01 00:00:00' - '-12-31
23:59:59'
just what i was
That's what I get for thinking...
I just tried that, ie: create table test (dt datetime NOT NULL
default '-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, [EMAIL PROTECTED]
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?)
alan
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
13 matches
Mail list logo