i was installing 2G beta 2.1.2 FULL PACK, and when i try to dump the slq i get this error
Error
SQL-query :
CREATE TABLE care_appointment
(
pid int( 11
) DEFAULT '0' NOT
NULL ,
date
date DEFAULT '0000-00-00' NOT
NULL ,
time
time DEFAULT '00:00:00' NOT
NULL ,
to_dept_id
varchar( 25 )
NOT NULL ,
to_dept_nr smallint( 5
) unsigned DEFAULT '0'
NOT NULL ,
to_personell_nr int( 11
) DEFAULT '0' NOT
NULL ,
to_personell_name
varchar( 60 )
,
purpose text
NOT NULL ,
urgency tinyint( 2
) unsigned DEFAULT '0'
NOT NULL ,
remind tinyint( 1
) unsigned DEFAULT '0'
NOT NULL ,
remind_email tinyint( 1
) unsigned DEFAULT '0'
NOT NULL ,
remind_mail tinyint( 1
) unsigned DEFAULT '0'
NOT NULL ,
remind_phone tinyint( 1
) unsigned DEFAULT '0'
NOT NULL ,
appt_status varchar( 35
) DEFAULT 'pending' NOT
NULL ,
cancel_by
varchar( 255 )
NOT NULL ,
cancel_date date,
cancel_reason varchar( 255
) ,
encounter_class_nr
int( 1 )
DEFAULT '0' NOT NULL
,
encounter_nr int
( 11 ) DEFAULT
'0' NOT NULL ,
STATUS varchar(
25 ) NOT NULL
,
history text
NOT NULL ,
modify_id varchar( 35
) NOT NULL ,
modify_time timestamp(
14 ) ,
create_id varchar( 35
) NOT NULL ,
create_time timestamp(
14 ) ,
PRIMARY KEY ( nr
) ,
KEY
pid( pid )
MySQL said:
#1067 - Invalid default value for 'nr'
im using mysqld Ver 4.1.15-Debian_1-log for pc-linux-gnu on i486
do i need to use another mysql server ?
thanks
Javier Guajardo
