[Phpgroupware-tracker] [bug #5230] pg_atoi() error in Projects.

[nobody]

=================== BUG #5230: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5230&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Sun 09/14/03 at 09:20 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | ceb




=================== BUG #5230: FULL BUG SNAPSHOT ===================


Submitted by: scintillus              Project: phpGroupWare                 
Submitted on: Fri 09/12/03 at 04:37
Category:  projects                   Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  ceb                     
Status:  Open                         Component Version:  None              
Platform Version:  Linux - Other      Reproducibility:  Every Time          

Summary:  pg_atoi() error in Projects.

Original Submission:  Attempting to add a project with PostgreSQL 7.3.x leads 
to the following error:



Database error: Invalid SQL: SELECT contact_person.first_name AS n_given, 
contact_person.last_name AS n_family, contact_org.name AS org_name FROM 
phpgw_contact_person AS contact_person RIGHT JOIN phpgw_contact AS 
contact_central ON contact_central.contact_id = contact_person.person_id LEFT 
JOIN phpgw_contact_org AS contact_org ON contact_org.org_id = 
contact_central.contact_id WHERE contact_central.contact_id = ''

PostgreSQL Error: 1 (ERROR: pg_atoi: zero-length string )



File: /var/www/htdocs/phpgroupware/phpgwapi/inc/class.contacts_sql.inc.php

Line: 556



Session halted.



The Apache version in question is: Apache/1.3.26 (Unix)

The PostgreSQL version is 7.3







No Followups Have Been Posted


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5230&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/