[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [bugs #8615] phpgw_contact_org_person - 2 primary
From: |
Dirk Schaller |
Subject: |
[Phpgroupware-tracker] [bugs #8615] phpgw_contact_org_person - 2 primary keys - no auto increment |
Date: |
Mon, 19 Apr 2004 05:21:17 -0400 |
User-agent: |
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) |
This mail is an automated notification from the bugs tracker
of the project: phpGroupWare.
/**************************************************************************/
[bugs #8615] Full Item Snapshot:
URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=8615>
Project: phpGroupWare
Submitted by: Dirk Schaller
On: Mon 04/19/04 at 09:20
Category: API - phpGWapi
Item Group: devel cvs
Severity: 7 - Major
Priority: 7 - High
Resolution: None
Assigned to: jarg
Status: Open
Component Version: CVS
Platform Version: None
Reproducibility: None
Summary: phpgw_contact_org_person - 2 primary keys - no auto increment
Original Submission: The phpgw_contact_org_person contains two primary keys
(org_id and person_id) and no unique auto increment primary key. That has the
effect that one person can be assigned only to one organization. When assigning
a person to a secound org I get the message:
Database error: Invalid SQL: INSERT INTO phpgw_contact_org_person
(person_id, created_on, created_by, preferred, org_id) VALUES (940,
1082362689, 5013, 'N', 11)
MySQL Error: 1062 (Duplicate entry '11-940' for key 1)
File: /srv/www/htdocs/pbgroupware/phpgwapi/inc/class.sql_entity.inc.php
Line: 515
Session halted.
I would use a auto increment pk. The person_id and org_id should be foreign
keys. Or if there shouldn't be the possibility to assign a person to more than
one orgs, it should be tested and a messege should be shown.
For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=8615>
_______________________________________________
Message sent via/by Savannah
http://savannah.gnu.org/
- [Phpgroupware-tracker] [bugs #8615] phpgw_contact_org_person - 2 primary keys - no auto increment,
Dirk Schaller <=