Thu 11 Sep 2003 01:35:09 PM UTC, 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.
|