Hi Kurt, Thank you for pointing this problems out. They are already known and fixes are available with the beta 2.1.3 release. Typically, you should not experience these problems with MySQL 4.0.x, which is the one recommended for the d2.1 release.
Problem #1 is some backward incompatibility in MySQL since version 4.1. Problem #2: The "condition" keyword is available since version 5.0 - again backward incompatibility introduced. Are you sure you run Care2x with MySQL 4.0.x and not a later version? Calling /phpinfo.php under the Care2x base dir will show you the necessary information. Greetings Kaloyan On Wed, 15 Feb 2006 10:28:42 +0100 Kurt Brauchli <[EMAIL PROTECTED]> wrote: > Hello again > > > > .... Following instructions that come along with the tar package > from > > Source forge Care2x_d21_full.tar.gz but when it comes to the point > > > of using > > PHPmyAdmin to run the SQL statement that creates the Care2x > database > > structure(install/mysql/manual/care_db_structure_d21_manual_my.sql) > it > > returns the error- #1067-invalid default value for 'nr'. Can't seem > > > to find a > > way around it. > > Laptop is running SuSE 9.3, PHP 4 and MySQL4.0.21 > > I tried to reproduce this behaviour on a Mac OSX box with MySQL 4.0.x > installed and got the same error. > > I looked at the sql file and found the following two problems: > > 1) MySQL 4 does not seem to allow default values for auto_increment > fields anymore. Thus you need to remove the "DEAFULT '0'" from all > field definitions with an auto_increment. > > 2) In line 1722 the field name condition is not accepted as condition > is a reserved word. Putting it into back-apostrophes `condition` > helps. change line 1722 form > condition varchar(60) DEFAULT '0', > to > `condition` varchar(60) DEFAULT '0', > > > best greetings > Kurt > > PS: if you want, I can also send you the modified sql file. > > > > Any help would be greatly appreciated. > > George Lule > > EACOSS > > _______________________________________________ > > Fossfa-health mailing list > > [EMAIL PROTECTED] > > http://www.fossfa.net/mailman/listinfo/fossfa-health > > > > --------------------------------------------------------- > Kurt Brauchli-Haase > Department of Pathology, University of Basel, Switzerland > ++41 61 265 28 28 http://ipath.ch > --------------------------------------------------------- > > > > > ------------------------------------------------------- > 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://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 > _______________________________________________ > Care2002-developers mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/care2002-developers ------------------------------------------------------- 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://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Care2002-developers mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/care2002-developers
