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
