Hi all,
I tried to install Care2x on Postgresql 7.4 and found
some problems, for example in Department list (file: dept_list.php).
Then I tried to debug into the department class file
(file: class_department.php) and found the error as follows:
(postgres7): SELECT *, LD_var AS "LD_var" FROM care_department WHERE
(is_inactive='' OR is_inactive='0')
AND status NOT IN ('deleted', 'hidden', 'inactive', 'void') ORDER BY
name_formal
------------------------------------------------------------------------
ERROR: invalid input syntax for integer: "":
ERROR: invalid input syntax for integer: ""
Since Postgres version 7.3 , empty string '' is no longer allowed as an
input of
integer fields. Formerly, it was silently interpreted as 0.
There will be a lot of work to do to modify the source code, is there
any better
idea ?
Thanks
daniel
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Care2002-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/care2002-developers
