Hi Kaloyan,
I replace the sql script with the fixed one you send, it finish the installation ok, but when i go to index, there is an error :
"Session Replace: Table 'care2x.care_sessions' doesn't exist "
i can only see lenguage choose, care2x image on top, and osi certified on bottom. no menu, no news, nothing else.
what can i do ?
thanks for your help
Javier
On 12/3/05, Kaloyan Raev <[EMAIL PROTECTED]> wrote:
Hi Javier,
The problem is that the sql script that creates the db structure is not
compatible with MySQL 4.1 and later versions. This is because from
version 4.1 on it is not allowed to have DEFAULT value for
AUTO_INCREMENT columns.
A fix will be available in the next beta release.
Till then you can use the fixed sql script attached in this mail.
Unzip the archive and copy the sql file to /install/mysql/auto.
Greetings
Kaloyan
On Sat, 2005-12-03 at 15:52 -0300, Javier Guajardo wrote:
> hello,
> 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(
>
> nr bigint( 20 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT ,
> 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
>
>
>
