Hi Javier, What is the version of php you are using? If it is php5, then downgrade to php4. The latest 4.4.1 is ok. Care2x still does not work with php5. There are lots of obsolete function calls that has to be cleaned up.
Greetings Kaloyan On Mon, 2005-12-05 at 01:43 -0300, Javier Guajardo wrote: > hi Kaloyan, > i checked the database with phpmyadmin, i dump the > whole db and run a sql query with the script you posted, all tables > are ok. but now i get a white page on index.php > not even the lenguaje chooser or the images. > thanks again. > Javier > > > On 12/5/05, Javier Guajardo <[EMAIL PROTECTED]> wrote: > 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 > > > > > > > > > > > ------------------------------------------------------- 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
