Hello Dr. Potur, I am sorry, but I am not familiar with postgre. I am currently concentrated on the issues that Care2x has with newer versions of PHP and MySQL. I will try it also with postgre, but this will not be soon. I hope there is somebody in this mailing list that could help you.
Greetings Kaloyan On Sat, 2005-12-03 at 21:31 +0200, Dr. Bülent Potur wrote: > 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, > 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 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Care2002-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/care2002-developers
