[Phpgroupware-tracker] [bug #5213] Impossible to edit last_name field in user admin

[nobody]

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

Changes by: Johnson <address@hidden>
Date: Mon 09/15/2003 at 21:37 (GMT)

------------------ Additional Follow-up Comments ----------------------------
I get this error as of Sept. 15, 2003



Note that the SQL is for an INSERT but should likely be an UPDATE since it is 
trying to edit an existing account record



=================== BUG #5213: FULL BUG SNAPSHOT ===================


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

Summary:  Impossible to edit last_name field in user admin

Original Submission:  In the "Edit User Account" page, if the user 
(administrator) presses the "save" button, the following error occurs, 
regardless of whether a value was entered in the "Last name" field (In this 
case, an attempt was made to edit the demo3 user and change its last name to 
'foobar'):



type1person_idvorDatabase error: Invalid SQL: INSERT INTO phpgw_contact_person 
(prefix, first_name, last_name, created_on, created_by, modified_on, 
modified_by, person_id) VALUES ('demo3', 'test', NULL , '1', '1', '1', '1', 
'11')

PostgreSQL Error: 1 (ERROR: ExecInsert: Fail to add null value in not null 
attribute last_name )



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

Line: 420



Session halted.



Follow-up Comments
*******************

-------------------------------------------------------
Date: Mon 09/15/2003 at 21:37       By: jecinc
I get this error as of Sept. 15, 2003



Note that the SQL is for an INSERT but should likely be an UPDATE since it is 
trying to edit an existing account record

-------------------------------------------------------
Date: Sat 09/13/2003 at 23:17       By: skwashd
Can you please try a cvs update - I think this one is fixed.


CC list is empty


No files currently attached


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

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