Hello Kaloyan,
Thank you for the mysql patch.
By the way could you possibly suggest a working version diagram for a postgresql database and care2x?. I have been trying to install postgresql in recent days. I have installed postgresql 7.4 and see it working with webmin. I even created the carepg database and created the tables manually via webmin execute sql command, though with several error messeges. The problem is when I go to page http://localhost/carepg/install/install.php and fill the necessary fields and click go it does not. The error message is :It can not connect the database.
Any tips? (php4-pgsql is installed too).
Thank you,
Thank you,
Greetings,
Dr. Bülent Potur
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
>
>
>
Yahoo! kullaniyor musunuz?
Istenmeyen postadan biktiniz mi? Istenmeyen postadan en iyi korunma Yahoo! Posta’da
http://tr.mail.yahoo.com
