[Phpgroupware-tracker] [bug #5212] pg_atoi() error when adding orgs with postgreSQL 7.3.x

[nobody]

=================== BUG #5212: FULL BUG SNAPSHOT ===================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5212&group_id=509

Submitted by: None                    Project: phpGroupWare                 
Submitted on: Thu 09/11/2003 at 09:35
Category:  addressbook                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  None                     Assigned to:  None                    
Status:  Open                         Component Version:  None              
Platform Version:  Linux - Other      Reproducibility:  Every Time          

Summary:  pg_atoi() error when adding orgs with postgreSQL 7.3.x

Original Submission:  This is a manifestation of the old pg_atoi() problem?

When attempting to add a person to the addressbook, and the user presses the 
"Add New Orgs" (Add) button to define a new organization to which that new 
person belongs, the following error is reported:



Database error: Invalid SQL: SELECT contact_central.contact_id AS contact_id, 
contact_central.owner AS owner, contact_central.access AS access, 
contact_central.cat_id AS cat_id, contact_person.first_name AS per_first_name, 
contact_person.last_name AS per_last_name, contact_person.middle_name AS 
per_middle_name, contact_person.prefix AS per_prefix, contact_person.suffix AS 
per_suffix, contact_person.birthday AS per_birthday, contact_person.pubkey AS 
per_pubkey, contact_person.title AS per_title, contact_person.department AS 
per_department, contact_person.initials AS per_initials, contact_person.sound 
AS per_sound, contact_person.active AS per_active FROM phpgw_contact_person AS 
contact_person RIGHT JOIN phpgw_contact AS contact_central ON 
contact_central.contact_id = contact_person.person_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: 789



Session halted.



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=5212&group_id=509

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