[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: Dave Hall <address@hidden>
Date: Thu 09/18/03 at 07:04 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Fixed
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
Thanks for the follow up - Closing



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


Submitted by: None                    Project: phpGroupWare                 
Submitted on: Thu 09/11/03 at 23:44
Category:  API - Admin                Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  High                       
Resolution:  Fixed                    Assigned to:  alexbsa                 
Status:  Closed                       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: Thu 09/18/03 at 07:04         By: skwashd
Thanks for the follow up - Closing

-------------------------------------------------------
Date: Thu 09/18/03 at 04:53         By: logart
I have verified that this issue is resolved in the latest cvs.



log

-------------------------------------------------------
Date: Tue 09/16/03 at 07: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: Sun 09/14/03 at 09: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/