bugphpGroupWare - Bugs: bug #5212, pg_atoi() error when adding orgs...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #5212: pg_atoi() error when adding orgs with postgreSQL 7.3.x

Submitted by:  None
Submitted on:  Thu 11 Sep 2003 01:35:09 PM UTC  
 
Item Group: 0.9.16RC1Category: addressbook
Severity: 3 - NormalPriority: 5 - Normal
Status: InvalidPrivacy: Public
Assigned to: Jonathan Rivera <jarg>Open/Closed: Closed
Component Version: NoneOperating System: GNU/Linux - Other
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

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.

Anonymous

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follows 1 latest change.

Date Changed By Updated Field Previous Value => Replaced By
Sat 13 Sep 2003 11:23:06 PM UTCskwashdAssigned toNone=>NA

Back to the top


Powered by Savane 3.1-cleanup1